Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to avoid data refreshing when applying query changes?

Hi,   I have a Power BI report that purposely is not refreshed anymore due to the need to reflect the data as how it was stored at a certain point in time a while ago. Now there is a need to make a...
Need Help
  • BA_Pete's avatar
    BA_Pete
    5 years ago

    Hi Anonymous ,

     

    Quick-and-dirty fix:

     

    View your static table(s) in the Data view, right click on the table, select 'Copy table', paste to Excel/Access/Other in order to save as static position. Reconnect Power Query to this static source.

     

    Pete

v-angzheng-msft's avatar
v-angzheng-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, Anonymous 

 

The table will refresh if changes to the APPLIED STEPS pane are detected. There is no way to prevent a refresh from happening if you modify a step. If you change the data in the data source but the APPLIED STEPS pane has not changed, it will not be refreshed. You can do it manually.

Unfortunately there is no way to stop the data from refreshing, the method mentioned above might be a good one to try.

 

 

Hope this helps.

 

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Ok, thanks for the explanation. I thought this might be the case, but was hoping there was a way to work around it!