Tabular Editor (TE) Script to Delete Measures

[wsnyder]

Hi all,

I imported a Data Model from Power Pivot into Power BI. I see many aggregation measures (Sum of, Average of, Max of) in Power BI that I do not see in Power Pivot.
1 of 2 things:
The measures exist in Power Pivot, but I cannot see them in Power Pivot
The measures are automatically created when I import the Data Model into Power BI
At any rate, I do not need them
I was trying to create a script in TE2 (I do not have access to TE3) to delete these "phantom" measures.

I did find much documentation on how to delete measures in the TE documentation

Thanks,
-w

 

[Matt Allington]

I have many articles on TE, including sample scripts Tabular Editor Archives

you Should be able to just select the measures and click delete, or modify one of my scripts that cycles over all measures.

these measures you refer to are implicit measures created by Power Pivot when you add a column to the values section of a pivot table. They are not visible in the fields list, but you can see them in the power pivot window.

 

[jdellasala]

Hi all,

I imported a Data Model from Power Pivot into Power BI. I see many aggregation measures (Sum of, Average of, Max of) in Power BI that I do not see in Power Pivot.
1 of 2 things:
The measures exist in Power Pivot, but I cannot see them in Power Pivot
The measures are automatically created when I import the Data Model into Power BI
At any rate, I do not need them
I was trying to create a script in TE2 (I do not have access to TE3) to delete these "phantom" measures.

I did find much documentation on how to delete measures in the TE documentation

Thanks,
-w

I've seen this before, and then remembered what this probably is. When a Pivot Table is built from a Data Model, and aggregations done without a measure are automatically generated, but hidden. I don't remember if you can even see them in Power Pivot.
The extra measures you see are probably them. They are called Intrinsic Measures (ones created by dragging fields into a pivot table), while those that are created within Power Pivot (DAX) are Explicit Measures.
Found this while trying to make sure I wasn't making a fool of myself!