Forum Discussion
markive
10 years agoAdvocate II
Formula.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/
MattAllington
10 years agoCommunity Champion
Ken Puls blogged about this here
http://www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/
markive
10 years agoAdvocate II
Hi MattAllington, thanks for the info..
Yes I was able to get around it just now by effectively moving all of the steps from the other query into the same query. This gets around the problem but it's a bit annoying.
- michaelshparber6 years agoAdvocate V
All steps in the same Query! Without "Reference"!!!
This did the trick!
You are a lifesaver!!!
Thank you so much!
Michael