Check data modeling size for each table

[Anonymous]

Hi,

Is there any field I can check the data table size? 

[Ritaf1983 · Accepted solution]

Hi @Anonymous 

There isn’t a built-in field in Power BI Desktop that shows the size of each individual table in the data model.

One basic workaround is to copy a specific table into a new PBIX file, save it, and check the file size — but this only gives a rough approximation.

It’s also important to understand that total model size is not simply the sum of the table sizes. It depends on several factors, including:

• Relationships between tables

• Column cardinality (number of unique values)

• Encoding method used (value vs. hash encoding)

• Visuals, filters, and how the data is consumed in the report

For a more accurate and detailed analysis, you can use external tools like:

🔹 DAX Studio – Connect your model and run VertiPaq Analyzer, which gives you a full breakdown of table and column sizes, cardinality, compression rate, and more.
🔹 Tabular Editor – Also useful when working with larger models and optimizing metadata.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly