Forum Discussion
markive
Advocate II
10 years agoFormula.Firewall: Query references other queries, so it may not directly access a data source.
I am getting the following error: Formula.Firewall: Query 'Query1' (step 'Added Custom') references other queries or steps, so it may not directly access a data source. Please rebuild this dat...
- 10 years ago
Ken Puls blogged about this here
http://www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/
Anonymous
6 years agoNot applicable
For anyone still experiencing this issue, under File > Options, select Privacy, and if it's appropriate, select Ignore privay levels. Even after following all the other suggestions referenced in this thread, I still got an error when refreshing. It worked when I was in the Query Editor just fine (no errors), but refreshing from the regular report view would fail.
- Anonymous6 years agoNot applicable
I can not believe this do work, and no failure rasied after clicking apply change. thanks, buddy!
- kristhian145 years agoRegular Visitor
thank you