Visual Memory Limit on PBI Service

[dobregon]

Hi guys,

I'm having problems in a report in the PowerBI Services related that some visuals have the error "memory limit". The messagge error is something like my visual exceded the limit memory (1gb) when the service limit is 1gb.

The problem is that me Dataset and me PBI desktop file have something like 60mb of size, so, it is dificult why this goes up to 1GB in the memory of PowerBI Service. I'm using DAX Studio and Tabular Editor in order if i can see how much memory produces each visual (with mupltiples measures) in order to see this >1gb that powerbi service says, but i dont find anything that can analyse the memory of a visual. Trying the performacne analyser of a visual in desktop and export to DAX studio i can see only the timing that Server needs to execute but it is not much time. Checking the size for each table in the database there are a lot of tables, rows, etc but the size of the PowerBI is 60mb so i have discarded this, Any idea that can help me?

Other thing about this is that i'm having this problems in some visuals when i use RLS, when i dont use the RLS i dont have the problem so, it is possible that the RLS applied in the report increase the memory of the visual but i dont receive any confirmation about that, someone know this?

Thanks in advance,

[v-gizhi-msft]

Hi,

I advise using DirectQuery connection mode.

Reference:

https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about#when-is-directquery-useful 

Hope this helps.

Best Regards,

Giotto Zhi

[GilbertQ]

Hi there

What you could do, is to have the report open and create a new page.

Take each individual visual and copy it into the report page. Then monitor the overall memory usage of your PBIX file using task manager to see which visual is affecting the memory.

Once you have the visual try change the visual to a built in visual. If the memory is still high then have a look at the DAX and underlying data model.