cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kr77025 Frequent Visitor
Frequent Visitor

Unable to refresh dataset due to "not enough memory to complete this operation".

Unable to refresh a dataset from the Dataset page on the PBI service. The PBIX file is around 540Mb on our laptop. The workspace has 9Gb+ of available memory. But starting last night we are unable to refresh the dataset with message below:

Processing error.There's not enough memory to complete this operation. Please try again later when there may be more memory available. Memory error: Memory Allocation failure : The paging file is too small for this operation to complete. . Try simplifying or reducing the number of queries.
Cluster URIWABI-US-NORTH-CENTRAL-redirect.analysis.windows.net
Activity IDb5808310-5d56-4a86-9101-4d2f673c93bd
Request ID1a75fbe5-1eff-3de9-e1de-eb1decad3a06
Time2019-04-23 16:21:51Z
 
Single datasource is from an Azure SQL DW. Biggest table has 70M rows in it. File size of PBIX is 540Mb (containing all data). Vertipaq analyzer report shows it takes up 1.3 Gb of memory. 
 
Just not able to refresh the dataset on the service.
3 REPLIES 3
Super User
Super User

Re: Unable to refresh dataset due to "not enough memory to complete this operation".

Hi there

There is a data size limit as far as I am aware when moving data into the Power BI Service which is 1GB, this is before the compression takes place.

Could you possibly see if the source has gotten more rows?

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog
kr77025 Frequent Visitor
Frequent Visitor

Re: Unable to refresh dataset due to "not enough memory to complete this operation".

Actually, i started getting the error now on PBI Desktop as well. After reading in the data, I see (from task manager) that the memory shoots up to 12 Gb and then goes back down to the typical 1.5 Gb. 

 

I'm able to process 20M rows but not 30M rows, even though i see the memory spike occur.


I was able to reduce the total number of records from 70M (which btw processed fine a couple of days ago) down to 40M. But now we can't refresh this in either the service or PBI desktop. Very strange.

Super User
Super User

Re: Unable to refresh dataset due to "not enough memory to complete this operation".

Hi there

From the spike in Memory it would indicate that there is a column of data that takes some time to compress.

When you look in the Task Manager which process is taking all the memory?

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 58 members 1,308 guests
Please welcome our newest community members: