Forum Discussion

Mai_Tran's avatar
Mai_Tran
Regular Visitor
2 years ago

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 Power Query step, it takes too much time with notification as the image attached. I don't know why the volume is huge and how to shorten refreshing time each time I edit my Power Query.

 

 

 

Thanks a lot for your help.

Need Help

2 Replies

  • AmiraBedh's avatar
    AmiraBedh
    Icon for Super User rankSuper User
    2 years ago

    If you go back to your question, you have the answer.

    If your PQ steps are complex or involve intensive calculations, they can significantly slow down the refresh time. Simplify your queries where possible. If you're pulling data from an external source, the performance of that source can impact refresh times.

    Even though your Excel file is only 12MB, the volume of data processed during the transformation might be much larger. Power Query may load and process a large amount of data before filtering it down to your final result.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.