Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
shailendra
New Member

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

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.

 

1 REPLY 1
Tad17
Solution Sage
Solution Sage

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.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.