Forum Discussion
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...
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.
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.