Metadata management

As Power BI projects grow to support more teams and business processes, the dataset(s) supporting the reports and dashboards for these projects will also grow. For example, integrating the general ledger into the existing AdWorks Enterprise dataset would require new fact and dimension tables, new relationships, and additional measures with their own unique business rules or definitions. Additionally, it's common for hundreds of DAX measures to be built into datasets over time to support more advanced analytics and address new requirements.

Given this added complexity, BI teams and specifically the dataset designer described in Chapter 7, Planning Power BI Projects can embed descriptions to aid report authors incorrectly utilizing the data model. Additionally, the dynamic management views (DMVs) for Analysis Services models can be leveraged to generate metadata reports providing detailed visibility to all essential objects of the dataset. The combination of field descriptions...