Forum Discussion
slow data refresh with the below query
ok. What is your question?
After running these 2 querys the data refresh is too slow and when I try and add new columns to the second query it gets stuck. What should I do?
Hi NamrataParekh ,
Slow data refresh in Power Query and stuck when adding new custom columns, you can try the following methods to resolve:
Refine the query: Check each step in the query to ensure that they are necessary. Remove steps that you don't need and merge steps that can be merged to reduce query complexity.
Avoid time-consuming operations: Some operations, such as merging queries, expanding columns, and grouping, can cause performance degradation. Minimize the use of these operations or, if necessary, use more efficient alternatives.
Reduce the amount of data: When loading data, only the columns and rows you need are preserved. This can be done by removing unwanted columns, filtering rows, or aggregating data.
Turn off background data loading: In Power Query Editor, tap File> Options and Settings> Query Options, and then uncheck the Background data loading option. This will allow data refresh to occur in the foreground, potentially improving performance.
Try incremental refresh: If you're using a Power BI Premium or Power BI Pro subscription, you can try the incremental refresh feature. This way, only new or changed data is refreshed, not the entire dataset.
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.
