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.

     

     

foodd's avatar
foodd
Icon for Community Champion rankCommunity Champion
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.

 

 

  • VickyDev18's avatar
    VickyDev18
    Icon for Advocate II rankAdvocate II
    2 years ago

    This didn't work, at least not with Azure Data Lake Gen2 as the source. Every change triggers a refresh and then a painful wait.☹️