Forum Discussion
Power Query Editor Steps are painfully slow
Uncheck all the settings where Power Query tries to mess with the meta data (column type inference, relationship detection etc.) Uncheck anything you don't want Power Query to do for you.
Hi Anonymous ,
Try doing the below items. This should help improve performance
1. Disable the Auto date/time under Time intelligence
2. Turn Off Auto detect relationships under Relationships in Data Load section
3. Replace any duplicate queries in your report with Query references and include only the differing steps to the Query reference
4. Remove any unwanted Columns from the dataset. (Wide Table hugely slow down the performance)
5. Disable loading of any unwanted queries during refresh
Regards,
If this helps, mark it as solution and appreciate with a Kudo!!
Careful with #4 - that is a very sharp double edged sword, especially in scenarios with query folding and poorly performing data sources. In such scenarios a full table spool is often faster than hand-picking columns.