real size of data model

[powerbiexpert22]

how to check the exact size of data model in power bi? pbix file does not provide the exact size since it consist of compressed data model and visualazations

[v-jtian-msft · Accepted solution]

Hi,@powerbiexpert22.Hello @Ritaf1983.Thank you very much for your help of this issue.Your solution is great.
Now I want to show other solutions of this issue.

1.The real size of a pbix file changes depending on the state it is in.

When we open a pbix file and view it, the real size of the file will be larger than what is displayed because some compression has occurred in the file and various other elements in the file will not pass through the disk to display the size.(Many elements in a pbix file take up memory: such as calculate column).

2.How to see the real memory consumption of pbix

Below I recommend some ways to see the real actual memory consumption of pbix.
(1) VertiPaq Analyzer
URL: VertiPaq Analyzer - SQLBI

Here are the results of the analysis of a table model

Here's a list of metrics that provide some insight into memory consumption.
"Table Size": the size of the table, which is the sum of all of the following values - excluding the column total size

"Column Total Size": all structure sizes associated with columns
"Data Size": all compressed data in a partition
"Dictionary Size": dictionary structure with unique values
"Columns Hierarchy Size": automatically generated hierarchy for columns
"User Hierarchy Size": user-defined hierarchy.
"Relationship Size": the relationship between tables.

This tool allows you to easily view the  data about pbix files.
(2)Dax Studio
You can do this with Dax Studio: a tool for writing, executing, and analyzing DAX code that helps us optimize and debug. Again, this is done by establishing a connection to the Power BI model
URL：DAX Studio | DAX Studio
By downloading and then select Power BI desktop>External tools>DAX Studio.

DAX Studio >Advanced

You can use VertiPaq Analyzer to view the data of the file.

3.Some ways to reduce the size of pbix file

You can refer to the following article, hope it can give you some help.

URL: How to Reduce Size of Power BI PBIX File in Fewer Steps (xavor.com)

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

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

[Ritaf1983]

Hi @powerbiexpert22 

Please refer to the linked video :

https://www.youtube.com/watch?v=vI7kVVHxsiM

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