Appended queries - Formula firewal

[stribor45]

I have "Query A", "Query B", "Query C" which all make API calls (same query just different dates)

I used Query A to append Query B and Qiuery C. All these queries hold historical data so I disabled refresh "include in report refresh". I wanted to go back to the table Query A (which now has appended Query B and query C) to clear some values in a column. I clicked on Refresh and got this error "Formula.Firewall: Query 'Query A' (step 'Appended Query') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination"

How do I fix this?

[stribor45]

that worked for me. thank you @parry2k 

side question....since this is historical data I don't need to query the remote server any more  so is there a way to prevent it from running? Every time I want to do something to the table it runs it again

[parry2k · Accepted solution]

@stribor45 yes or ignore privacy level, it will be for all the queries.

[parry2k]

@stribor45 set the privacy level to be the same or ignore the privacy level, check it here Understand Power BI Desktop privacy levels - Power BI | Microsoft Learn

[stribor45]

For the each query?