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
I only have a calculated column which is concatenate of two fields to create a unique Key to join two tables . I was not able to join the two fields as many to one relations. Thank you so much
I'm pretty close to concluding that Power BI Web is **bleep**ware.
It has a pattern of choking on high data volumes.
We have too much COST data volume, so the more we spend with Azure, the less the chance that Power BI can report on it -- insane!