10GB limit on Service ?

[AmirY]

I just upgraded my PowerBI to Premium because I was hitting a 10GB memory limit on my desktop but still getting the same error on Service. Here is what I have done, I appreciate if someone direct me to the right solution:

- I created a new workspace as PPU 

- I published my repport (about 3 GB) to this workspace

- When I run a report , it gives me an erorr like " you are using 12GB , the limit is 10GB" (or something like that). 

Is there anything else I should change to allow me to run my reports ?

[pallavi_r]

Hi AmirY,

Are you using calculated columns? Most of the times calculated columns takes lot of memory because those are stored in model. Can you try converting the calculated columns to measures. I suggest try removing the calculated column completely and check once if this is the rootcause.

[AmirY]

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

[chizuml_ds]

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!

[PawelWrona]

All columns are stored in the model. It is better in general to create columns before they are loaded into model, but tests done by guys from SQLbi rather showed that sometimes calculated columns are cheaper, and sometimes more expensive on memory. It is not a rule unfortunately. 

[AmirY]

I will play with that to see. Thanks

[pallavi_r]

Calculated columns are stored for every single row and that might consume lot of memory.

[pallavi_r]

Calculated columns are stored for every single row and that might consume lot of memory.

[PawelWrona]

If 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

[AmirY]

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. 

[Brunner_BI]

Try to kick out some columns that you currently do not need, you can use Measure Killer to find which ones you need and which ones you do not.

[AmirY]

Thank you, I can definitely do that to get it wokring but I have many more data to add to this report that I have not loaded yet. The premium is suppose to give me 100GB memory but somehow it caps at 10GB . Thanks again

[Idrissshatila · Accepted solution]

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