Forum Discussion
Estimate size of Report/Model
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.
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.
1 Reply
- Greg_Deckler
Community Champion
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.