Forum Discussion
Helper IISLOW Power Query Editor
Hello,
I have a relatively small dataset (compared to how much my Power BI Premium account can hold- around 35k rows of less than 10 columns.
The power query editor is extremely slow for EVERY step. I am not sure how to get this to speed up so I can work efficiently. It is slow for displaying the 1000 row preview, for clicking a function, for loading the "preview" window for a column, for simple functions like rename or TRIM, etc.
How can I fix this? Is it a setting, or a back-end issue I'm not aware of? Or, is this what I'm stuck with for the forseeable future?
Hello W2SANC
Disable Background Data Refresh
Go to:
`File > Options & Settings > Query Options > Data Load > Uncheck "Allow data preview to download in the background"`
This stops Power Query from continuously fetching data for previews during edits, reducing lagTurn Off Relationship Auto-Detection:
`File > Options > Data Load > Relationships > Uncheck "Auto detect new relationships"`Try these
1 Reply
- nilendraFabric
Super User
Hello W2SANC
Disable Background Data Refresh
Go to:
`File > Options & Settings > Query Options > Data Load > Uncheck "Allow data preview to download in the background"`
This stops Power Query from continuously fetching data for previews during edits, reducing lagTurn Off Relationship Auto-Detection:
`File > Options > Data Load > Relationships > Uncheck "Auto detect new relationships"`Try these