Forum Discussion
Power Query Editor Steps are painfully slow
I am using power query editor in power bi with many (like 30) different queries. Now every step in a query takes literally ages to load in preview. Even If I go on the very first query step, which ...
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.
I'm getting impossibly slow response when changing small things in power query.
Does anyone know of a list of these "Settings where Power Query tries to mess with..."?
I would turn off the preview but it's ticked and greyed out. 😞
Any help appreciated.
Show a screenshot of your options page current file/report settings.
Try to avoid doing table merges in Power Query. Join the tables in the data model.