Forum Discussion
markive
Advocate II
Advocate IIFormula.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...
Ken Puls blogged about this here
http://www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/
freder1ck
Kudo Kingpin
Kudo KingpinThis is the article previously referenced in this thread:
https://www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/
I confess I had to read it a few times to get it.
from the article by Ken Puls
Basically, each query needs to be loaded into a staging query first. Then, you can combine these staging queries.
Fred
Digger
Post Patron
Post PatronYou wrong it not working like you think, separated queries still show error firewall