Formula.Firewall: Query references other queries, so it may not directly access a data source.

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".