Forum Discussion
Formula.Firewall: Query references other queries, so it may not directly access a data source.
Ken Puls blogged about this here
http://www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/
Ken Puls blogged about this here
http://www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/
The error can occur from privacy permissions as well. It may be necessary to take the steps outlined in the solution above and also to change the privacy options. File>Options and settings>Query Options>Privacy
Then choose "Always ignore privacy level settings".
I actually ran across this same error...
Going to: Options --> CURRENT FILE --> Privacy then setting the Privacy Level to "ignore the privacy levels and potentailly improve performance" did the trick.
Thank you so much guys!
Fernando
That was brilliant, it worked like charm!!! thank you 🙂
Thanks, this solved my today problem!
