Using INFO.VIEW to document the contents of models

This page has 0 threads | Add post

Blogs

Finding our blogs useful? Please consider helping us to share more!

Power BI Desktop - Updates for October 2024 Part five of a five-part series of blogs
You can now create data-bound reference layers in Azure maps, document your model's measures, tables and columns using the INFO.VIEW function in DAX, format chart markers within inches of their lives and apply dynamic formatting using DAX. Power BI Desktop - Updates for October 2024 Data-bound reference layers in Azure maps New ways to format markers Dynamic format strings in DAX Using INFO.VIEW to document the contents of models (this blog) We've been creating our idiosyncratic monthly blogs on Power BI updates since November 2016, and also deliver online and classroom Power BI courses.

Power BI Desktop - Updates for October 2024

Part five of a five-part series of blogs

You can now create data-bound reference layers in Azure maps, document your model's measures, tables and columns using the INFO.VIEW function in DAX, format chart markers within inches of their lives and apply dynamic formatting using DAX.

Power BI Desktop - Updates for October 2024
Data-bound reference layers in Azure maps
New ways to format markers
Dynamic format strings in DAX
Using INFO.VIEW to document the contents of models (this blog)

We've been creating our idiosyncratic monthly blogs on Power BI updates since November 2016, and also deliver online and classroom Power BI courses.

Posted by Andy Brown on 05 November 2024

You can now use a DAX query to show the contents of your model:

This query would list out (separately) the tables, columns, relationships and measures in your report.

Each of these can give useful information. For the tables, you can see for example how much storage each requires:

The Region table uses up most space out of those listed.

Listing columns shows you how much space each column (rather than table) takes up in memory:

There are other columns giving interesting bits of information not shown here.

Listing relationships documents the links between the tables in your model:

You can see which links there are between which tables.

Finally listing measures gives their syntax:

Here I've only created one measure in this model.

You can now possibly uninstall DAX Studio (Power BI users of a certain age will know what I mean by this).

Parts of this blog
Power BI Desktop - Updates for October 2024 Data-bound reference layers in Azure maps New ways to format markers Dynamic format strings in DAX Using INFO.VIEW to document the contents of models (this blog)