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,
Here looks like error is because the compressed size is exceeding the per dataset limit on your capacity. In power bi service --> under dataset settings --> Large dataset storage format, turn On.
- If possible, store the images as url’s for example in azure blob storage and reference them in your report visuals instead of embedding the actual image data in the model
- If the large dataset format is already enabled and you are still hitting the limit, please share the exact error message and the current dataset size from the dataset settings so we can look more into the issue and provide you the best solution possible
Thanks and regards,
Anjan Kumar Chippa
Hi NehaGoel_2203,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.
Thanks and regards,
Anjan Kumar Chippa