Memory analysis via DMVs

The same DMVs that provide information about SSAS Tabular databases are also available for Power BI datasets. Querying these DMVs can provide schema information, such as the columns used to define relationships, the definitions of DAX Measures, and the memory usage of columns and other structures. From a memory analysis standpoint, the two most important DMVs are DISCOVER_STORAGE_TABLE_COLUMNS and DISCOVER_STORAGE_TABLE_COLUMN_SEGMENTS.

In the following query from DAX Studio, the dictionary size of each column of a Power BI dataset is retrieved via the DISCOVER_STORAGE_TABLE_COLUMNS DMV:

Dictionary size by Column

Get Mastering Microsoft Power BI now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.