Forum Discussion
Power ParticipantPBIX file size
Hi ArchStanton ,
Is 13GB local pbix file size or PBI Memory Costs? The 16GB file size is more than the limit for direct publish. But from the other info, the amount of data doesn't seem to be that large, and from experience, PBI can easily handle a table of 45,000 records, And the data model for this volume should not be 10GB.🤔
So I think as a first step you may need to evaluate the overhead of the model with some external tool.
Analyze Model - SQLBI Docs
Videos | DAX StudioAnd base on this to optimize model.
Data reduction techniques for Import modeling - Power BI | Microsoft Learn
Optimization guide for Power BI - Power BI | Microsoft LearnFor some calculated columns and calculated tables, try to build them in the data source/upstream as well if you can, which will reduce the memory expense for PBI.
Others may heleful:
Optimize DAX queries in Power BI (Top 21 Ways) | Edu4SureBest Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Hi ArchStanton ,
Is 13GB local pbix file size or PBI Memory Costs? The 16GB file size is more than the limit for direct publish. But from the other info, the amount of data doesn't seem to be that large, and from experience, PBI can easily handle a table of 45,000 records, And the data model for this volume should not be 10GB.🤔
So I think as a first step you may need to evaluate the overhead of the model with some external tool.
Analyze Model - SQLBI Docs
Videos | DAX Studio
And base on this to optimize model.
Data reduction techniques for Import modeling - Power BI | Microsoft Learn
Optimization guide for Power BI - Power BI | Microsoft Learn
For some calculated columns and calculated tables, try to build them in the data source/upstream as well if you can, which will reduce the memory expense for PBI.
Others may heleful:
Optimize DAX queries in Power BI (Top 21 Ways) | Edu4Sure
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Power ParticipantThank you so much for this information. The 16GB is the actual pbix file size
I'm not actually having any trouble publishing this to the shared workspace which is good, this despite there being 40 queries in the data model. Some of my measures are quite slow (3-4 secs) but it doesn't matter as the model only refreshes once a day at midnight.
As I mentioned originally, I inherited this data model, its extremely complicated and I dare not try to pull it apart and re-build it as that is way above my pay grade! I will however look at your recommendations and look at stripping out unused columns, rows etc.
Hi ArchStanton ,
16521 kb ≈ 16.13 mb (not Gb).
From your description it looks like maybe some of the measure are not performing well, you can start a new thread to discuss how to go about optimizing the Dax query of the measures in your case.
The next step you may need:
Use tools to optimize Power BI performance - Training | Microsoft Learn
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
- ArchStanton
Thank you for your help!