Forum Discussion

W2SANC's avatar
W2SANC
Helper II
1 year ago
Solved

SLOW 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 EV...
Need Help
  • nilendraFabric's avatar
    nilendraFabric
    1 year ago

    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

nilendraFabric's avatar
nilendraFabric
Super User
1 year ago

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