Forum Discussion

Copper Contributor

Jan 31, 2022

Disable automatic updates of excel file

Hi, I have an Excel file that automatically updates from different data connections (SQL) when users open it. However I want to save an static copy that does not update to latest data when it is op...

BI & Data Analysis

excel

SergeiBaklan

Diamond Contributor

Jan 31, 2022

Kasper22

You may right click on returned by Power Query table and disconnect table from it.

Table will be disconnected forever and Power Query will be shifted to Connection only mode.

Kasper22

Copper Contributor

Jan 31, 2022

Thank you, but I can not locate above view in my Excel?
I have 7 queries in the Excel sheet that are used by 30+ pivottables.

SergeiBaklan
Diamond Contributor
Jan 31, 2022
Kasper22 What are your query load options, you load query to data model only ?
- Kasper22
  Copper Contributor
  Jan 31, 2022
  Yes the queries are loaded only to the data model
  - SergeiBaklan
    Diamond Contributor
    Jan 31, 2022
    Kasper22
    
    When simply disable all refresh options, includes Refresh All, in the final file.