Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
Frenchtom811
Resolver I
Resolver I

Loads and Refreshes are stalling.

Is there somehting wrong with PowerBI these days?  I will make a minor change via Power Query and then select Apply Changes.  Sometimes the pop up window stays stuck at the initial "Evaluating Queries" step.  Other times the pop up window will show either a count of Megabites getting processed or a count of rows getting processed.  These two steps also stall at a certain point.  This never happened before but now it happens every time on a big dashboard I built this week.  At the beginning of the week, I had no problem with the apply changes steps stalling.  Now I cannot get past this step even after waiting overnight.  Is there a trick around this?

 

FWIW, I have discarded all changes since the last time my dash worked and now I am applying tyhe changes 1 at a time and performing a full refresh bewteen each single change I make.  This is tedious but in the long run should take less time than the 3 days I have spent waiting on the application of all my chnages at once.

2 REPLIES 2
v-stephen-msft
Community Support
Community Support

Hi @Frenchtom811 ,

 

Did this data source load slowly from the start, or did it start to slow after you made a few changes in power query?

Try to disable load tables to save your memory, it will save your refresh loading time to a certain extent.

Performance Tip for Power BI; Enable Load Sucks Memory Up - RADACAD

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

Have you tried clearing the cache? Was there a change in the source data that you might not know about?

 

--Nate

Helpful resources

Announcements
Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.