Forum Discussion

Dmitry22's avatar
Dmitry22
New Member
3 years ago
Solved

Disable refresh when working in PowerQuery

Hi everybody.   I am using PowerQuery to combine data tables from several separeate Excel files. However, when trying to add some calculated columns into the resulting table, after each column is e...
Need Help
  • foodd's avatar
    foodd
    3 years ago

    One option would be to disable background data refresh to prevent changes from triggering an automatic refresh while you make changes.   

     

    Follow this:  Disable Power Query background refresh

     

    Steps:

    In Power BI Desktop, you disable automatic background refresh by selecting File > Options and settings > Options, Current File > Data Load page > Background Data.   While editing:  Uncheck 'Allow data preview to download in the background'.  When done, return and Check this option to enable background refresh for the current file.

     

     

mdubdata's avatar
mdubdata
Regular Visitor
1 year ago

I agree with VickyDev18 i have unchecked that box while using a Direct Query model and the painful pageloads slow down the report development quite a bit. 
I guess I am forced to put a TOP(100) in my SQL to handle this whiel building.

What do others do?