Forum Discussion
Solved
Reduce PBIX file size
Hi Team, The data has been taken from SQL Server, and my two PBIX file size is (2591219KB,1962302KB) very large. I would like to know how to reduce the file size. I have already removed unused co...
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?
