Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello everyone,
I have several excel files with power queries and everything was working fine until recently when the refresh starts to stop working
in each file. In fact, one query refreshes and then the next one stuck and just spins with the message Loading data ...
When I close the file and open it again, the query refreshes almost immediately.
Then when I try the next query it stuck again and I have to close the excel file again and when I open it again the query executes very quickly.
I note that this is not the case with just one file, but with all of them where I have power queries.
Has anyone had a similar case and is there a solution to prevent this from happening?
Regards
Solved! Go to Solution.
Hi @Hoki71 ,
According to your description, have you enabled the Enable Background Refresh option, if this option is enabled, the data will be refreshed automatically, which may result in a slow refresh. You can try to enable the fast load data option, this will speed up your data loading.
Refresh Power Query in Excel: 4 ways + advanced options - Excel Off The Grid
Enable Background Refresh in Power Query - Solve and Excel Consulting
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @Hoki71 ,
According to your description, have you enabled the Enable Background Refresh option, if this option is enabled, the data will be refreshed automatically, which may result in a slow refresh. You can try to enable the fast load data option, this will speed up your data loading.
Refresh Power Query in Excel: 4 ways + advanced options - Excel Off The Grid
Enable Background Refresh in Power Query - Solve and Excel Consulting
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly