Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Data Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more

cmsouth

Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.

Submitted by on ‎01-05-2022 05:45 AM

This PowerBI worked for the past year, but has recently started failing during scheduled refresh with the error "Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.".  I can refresh in desktop and when i manually click the refresh the data set in the online site, but fails during the schedule (on-prem data gateway).  I have moved the refresh time to different windows in case there was a conflict with other refreshes.  We've changed the server memory (its a virtual Hyper-V).  Its strange that it will refresh manually, but not on schedule.  Suggestions?

Status: Investigating

Hi @cmsouth 

 

My I know whether this issue happens when you set scheduled refresh at a relative fixed time? If you change the scheduled time, will you get same issue? What’s the data source of the dataset? What kind of connection mode does this dataset use to connect to the data source? Is this dataset created on a large amount of data from data source?

 

Best Regards,

Community Support Team _ Caiyun

See more ideas labeled with:
9 Comments (9 New)
Comments
v-cazheng-msft
Community Support
Community Support
‎01-05-2022 09:20 PM
Status changed to: Investigating

Hi @cmsouth 

 

My I know whether this issue happens when you set scheduled refresh at a relative fixed time? If you change the scheduled time, will you get same issue? What’s the data source of the dataset? What kind of connection mode does this dataset use to connect to the data source? Is this dataset created on a large amount of data from data source?

 

Best Regards,

Community Support Team _ Caiyun

cmsouth
Frequent Visitor
‎01-06-2022 06:26 AM

To answer your questions:

1) It is scheduled to refresh daily at 4am EST.  I have tried different times after the refresh started failing, but receive the same error.  I can usually manually refresh the dataset in the app.powerbi.com screen the day I upload a new version, but even the manual will fail after a day or so.  Then i have to refresh on desktop and upload a new version.

2) The datasource is a MySQL query against an AWS RDS MySQL instance. It uses the MySQL connector to access the database and calls a procedure that runs the query.   
  I have 20+ other PBi's that run against the same MySQL instance with no other errors. 

  In this PBi, there are 5 queries, 3 that are larger and return 6k, 15k, and 40k records.  The other 2 are used for last update date and date dimension (7k),  The queries takes 5 minutes to refresh from the desktop.Clipboard02.png

 

v-cazheng-msft
Community Support
Community Support
‎01-09-2022 11:04 PM

Hi @cmsouth 

 

Thanks for your reply! I understand and this issue only happens in Power BI service but not local Power BI Desktop. May I know whether this report is published in a shared but not a Premium capacity(there is a diamond icon beside the premium workspace name)? According to the error information, it seems like there isn’t enough memory to handle these queries. I do suggest you simplifying your calculation and reducing the data amount used or you may consider opening a support ticket to ask for further help if you are a Pro user. For how to create a support ticket, please refer to this blog.

 

Best Regards,

Community Support Team _ Caiyun

AGo
Post Patron
Post Patron
‎05-14-2022 11:48 AM

Same problem for me, my dataset has always refreshed correctly for the past couple of years, but not now.

AGo
Post Patron
Post Patron
‎05-14-2022 12:04 PM

My collegue is telling me that this problem is getting more frequent since 6 months even with the same amount of rows and dax code, due to dax measures or columns, it's like the service is reducing memory or computational capacity available to Pro licences.

aggregator3000
Advocate II
Advocate II
‎02-19-2023 02:58 PM

Hi @cmsouth @AGo 

 

I had this issue for the past month, and found an easy fix

 

Of course, before using that fix.. I rebuilt most of the report to no avail. Had to refresh locally daily and republish...

If I deployed fresh to another workspace it would refresh fine in Service (pro only).. was not RLS related either.

 

As it seemed to be Service-Workspace specific I thought maybe there is a cache going on and that would have an issue or be too big.

Searched around that and the first result solved it for us

 

It was fixed simply by clearing the caches in the PBIX file and then republishing. That solution is here

 

Hopefully this works for you. Good luck

cmsouth
Frequent Visitor
‎02-20-2023 06:20 AM

@aggregator3000 - You ROCK! That solved my problem - refreshed first time on its own in months.  I had a ticket with MS and they told me to redo a bunch of the queries, but that didn't make a difference - your solution fixed for me!

aggregator3000
Advocate II
Advocate II
‎02-28-2023 08:11 PM

@cmsouth great outcome, you're very welcome.. Hopefully this helps other people who have sunk many hours into it like us.

ramdasanudas
Frequent Visitor
‎07-11-2023 03:14 AM

get more space in C: drive
or
Try to clean the data load cache: File -> Options and Settings -> Options -> Data Load -> Clear cache and Save the file and Load again

Idea Statuses