cmsouth's avatar
cmsouth
Frequent Visitor
4 years ago
Status:
Investigating

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

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 qu...
Gateways
cmsouth's avatar
cmsouth
Frequent Visitor
4 years ago

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.

 

Completed Ideas