Forum Discussion
10GB limit on Service ?
Hello AmirY ,
this is a huge data model, I suggest you work on optimizing your data model.
You could use DAX Studio to evaluate query performance. And you could improve Power BI performance through the following ways:
1.Turn off auto date/time
2.Remove unnecessary columns
3.Optimizing the data model
4.Reducing the number of values but not the information
5.Reducing precision
6.Choosing measures over calculated columns
7.Optimize your DAX
To learn more details ,you could read the following articles:
10 Best practice tips to improve your Tabular Model performance
HOW TO IMPROVE POWER BI PERFORMANCE - PART I
HOW TO IMPROVE POWER BI PERFORMANCE - PART II
HOW TO IMPROVE POWER BI PERFORMANCE - PART III
Resolver IIIf use Premium per User, your limit for semantic model should be 100 GB. Make sure that your semantic model setting for Large Datasets is turned on:
Here is more info on this:
Large semantic models in Power BI Premium - Power BI | Microsoft Learn
I do have Large semantic model ON , hee is the error I get:
- More detailsResource Governing: This query uses more memory than the configured limit. The query — or calculations referenced by it — might be too memory-intensive to run. Either simplify the query or its calculations, or if using Power BI Premium, you may reach out to your capacity administrator to see if they can increase the per-query memory limit. More details: consumed memory 13393 MB, memory limit 10240 MB.