Forum Discussion
Power Query refreshes too long without reasons
Hi guys, I use Power Query to transform and summarise data. In excel file, there are several tables but total file size just 12MB. The problem is each time I add new steps or has any change in Po...
Hi Mai_Tran
Some factors may affect power query performance, such as the number of queries, number of transformations, source data type, and query folding.
You can try the following to increase refresh speed:
Use the Table.Buffer function to reduce the number of times you load source data
Solved: Power Query taking forever to load or refresh - Microsoft Fabric Community
Enable the Allow data preview to download in the background option in Power BI Desktop
Disable Power Query background refresh - Power BI | Microsoft Learn
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.