Memory error: you have reach the maximum allowable memory allocation for your tier

[shailendra]

Hi, I have Power Bi report/App running with 200 Million+ data. Data source is Ms-SQL database where we have multiple tables/views/columns. I have identified if after many filteration my report is publishing 30 Million records all is working fine. but more than 30 M records, I am getting "Memory error: you have reach the maximum allowable memory allocation for your tier ".

This is critical and answer which has posted in this community is not satisfying my requirement here.  I need your immediate attention on this.  

If not through this forum, I need immediate MS- support expert to engage with me.

[Tad17]

Hey @shailendra 

View this article here for size limitation information: https://docs.microsoft.com/en-us/power-bi/service-admin-manage-your-data-storage-in-power-bi#:~:text...

The answer in this thread also gives some good insight into this issue: https://community.powerbi.com/t5/Desktop/Power-BI-memory-limit/td-p/206477

Basically, you are not limited on Desktop. You are limited in Power BI Service. If you need more space you will have to upgrade to premium. Consider splitting the query between workspaces and then sharing visuals in a dashboard using content packages. See this thread for an example: https://community.powerbi.com/t5/Service/How-to-share-content-from-multiple-workspaces/td-p/333282

If this helps please kudo.

If this answers your question please accept it as a solution.