SLOW Power Query Editor

[W2SANC]

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? 

[nilendraFabric · Accepted solution]

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 lag

 Turn Off Relationship Auto-Detection:
`File > Options > Data Load > Relationships > Uncheck "Auto detect new relationships"`

Try these