I want to set the query so that it is not updated automatically or manually.

[Tome_05]

It has become indebted to.

I would like to set it so that it does not update itself, whether it is automatic update or manual update, since I may update the query by mistake. Please tell me how to do this.

[Brunner_BI · Accepted solution]

The only way that I know of to really fix the data is if you go via "Enter data" copy pasting your table.

[Anonymous · Accepted solution]

Hi @Tome_05,

If you are working on the power bi desktop, you can enter to the query editor and right click on the query table to  turn off the 'include in report refresh' option, then the refresh operation should not triggered on the query table.

Also if this table not stored too many records, you can also consider to use 'enter data' method to import data, these records will convert to static base64 strings and transform to the query table.

Regards,

Xiaoxin Sheng

[Brunner_BI · Accepted solution]

The only way that I know of to really fix the data is if you go via "Enter data" copy pasting your table.