Skip to main content

Power BI

Needs Votes

Allow Power BI to query internal DMVs

Vote (2) Share
Jordan's profile image

Jordan on 30 Apr 2019 05:01:35

I used DMVs in SSAS Tabular to create data dictionaries and relationship guides - it's very handy for users to quickly see DAX formulas for each measure, plain text column descriptions as well as what tables relate to each other. Using OPENROWSET queries I can actually bake these data dictionaries into the model itself. I want Power BI to have the same functionality - maybe by opening up the XMLA end point as a data source.