Estimate size of Report/Model

[manalla]

Hi,

Is there a way to calculate the approximate size of Power BI Report when we know what would be tables we would use to build the  model?

We know the tables, #of rows and #of columns that would go to in building model and would like to estimate the growth as over all size is limited to 2GB.

[Greg_Deckler · Accepted solution]

The issue with that is Power BI uses a columnar compression algorithm to compress data. So, you would have to understand exactly how that algoritm works and exactly what data you have. For example, if you have lots of the same value in a column, that will compress very well, but if you have lots of unique values, that will compress less well.