As data models grow and change to support new business processes and logic, access to current documentation becomes imperative. Visibility to basic metadata such as the relationships of the model, columns of the tables, and the filtering logic built into measures can significantly aid business teams in utilizing Power BI datasets. Additionally, business intelligence and IT professionals who may be new to a specific model or unfamiliar with a component of the model can benefit greatly from direct access to technical metadata such as data source parameters, SQL and M queries, and the configured security roles.
In this recipe, several dynamic management views (DMVs) related to the schema of a Power BI dataset are accessed and integrated into a Power BI report. A template is then created with parameters...