Forum Discussion
Sean
Community Champion
9 years agoList ALL Calculated COLUMNS in a Data Model
Does anyone know how to get a List of all Calculated COLUMNS in a Data Model? Very easily done if you have a PowerPivot Model using the Power Pivot Utilities - Tool Dax Studio gets me all th...
Sean
Community Champion
9 years agoDoes anyone know why this works in DAX Studio when connecting to a PowerPivot Model but it does NOT work with a PBI Model?
SELECT * From $SYSTEM.DISCOVER_CALC_DEPENDENCY
WHERE OBJECT_TYPE = 'MEASURE' OR OBJECT_TYPE = 'CALC_COLUMN'
ORDER BY [EXPRESSION] ASC
Perhaps marcorusso can tell us? :smileyhappy: Thanks!
Looking around I also found this interesting Idea by avisingh that is kind of related.
It will not solve the above issue but would be a nice feature to have!
Measure Dependency View (similar to the Query Dependency View)
Thanks! :smileyhappy:
MattAllington
Community Champion
9 years agoHave you looked at my new Local Host template? This extrats table data from Power BI Desktop direct into Excel