Forum Discussion
Reduce PBIX file size
Another option is to use Direct Query instead of Import. This way the data is stored in the SQL database, not in the cloud.
Hi NehaGoel_2203,
Take a look at this article:
Data reduction techniques for Import modeling - Power BI | Microsoft Learn
If you have already removed unused columns, the next step would be to look at the granularity of your data. Does it need to be that granular for the reporting that you are doing? Can you summarize the data to reduce the number of rows you have?
tayloramy thankyou for the help sir. That is a university data and all rows data are important. It can't help to reduce data size
Hi NehaGoel_2203,
If there is no way to reduce the dataset size, then the last option is to upgrade your capacity.
how?
Hi NehaGoel_2203,
Thank you for reaching out to Microsoft Fabric Community.
Thank you cengizhanarslan, Tutu_in_YYC and tayloramy for the prompt response.
Upgrading capacity should be the last option.
Even if all rows are required, large pbix file size is usually because of high cardinality columns, date time precision, auto date/time tables and data types, not just row count. So before upgrading, please try DirectQuery or optimize the model properly (cardinality, date time columns, data types, incremental refresh).
If the dataset is still large after proper modelling, then consider PPU or Fabric capacity.Thanks and regards,
Anjan Kumar Chippa
