Forum Discussion

Testeri's avatar
Testeri
Icon for Helper II rankHelper II
3 years ago

Memory allocation failure on dataset refresh

Hi, my dataset refresh at Power Bi Service takes from 45 minutes to 2 hours and sometimes, not always, I get error "Memory error: Memory Allocation failure . Try simplifying or reducing the number o...
Need Help
TheCreepster1's avatar
TheCreepster1
Icon for Helper II rankHelper II
3 years ago

What's your data source? Have you tried opening in the .pbix and refreshing each individual query one at a time to identify where the issue is, or stepping through the Power Query steps? That's where I'd start.

Testeri's avatar
Testeri
Icon for Helper II rankHelper II
3 years ago

Thanks for your reply. I'm using SQL Server as datasource. Like I said I know what tables takes long time but I want to know what is it exactly in those tables. Can't remove columns for testing because they might affect other calculated columns in the table. Is it possible to track what happens when you refresh Individual table? After rows are loaded (image below) nothing happens for a long time (8 minutes). That gif just keeps rolling. Would be nice to know what happens in the bacground during that.