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.

     

     

pmanueco's avatar
pmanueco
New Member
2 years ago

Hi Dmitry22,
I encountered the same problem with a different data source, did you find a solution? I have a big database and it takes forever to do any change and its always refreshing. Also if I change from one page to the other whatever was loaded before it unloads.

Thanks in advanced, ill let you know if I find a solution.

  • Dmitry22's avatar
    Dmitry22
    New Member
    2 years ago

    Hello. Unfortunately not really. I tried to implement proposed solution from this topic, but it does not change much. The only workaround seems to be to use a "dummy" data source with only a few entries at the time of coding and then replace it by "normal" once finished.