Desktop Refresh Error: Query "references other queries or steps ... "

Hi Anonymous ,

that was the link I actually looking for earlier to post here, however, I couldn't find it anymore. I can unfortunately say for sure that this is not always a solution. I do this with all my queries and I still get the error. It is definitely a bug.

Essentially, always load your sources in a "loading stage". I usually group those source queries. I trim them, select columns and sometimes filter them (as long as those filters don't depend on external sources, otherwise you get this formula.firewall error). There queries are not loaded to the report.

In a second stage you can do all transformations, merging, etc. I usually group those too. These are still not loaded to the report though.

And finally in a third stage I just do appending (when applicable) and finally some reordering if desired and renaming. These queries are the ones I load as tables to the report (I group those too).

This way, you shouldn't encounter the formula.firewall issue.

However, that is unrelated to the primary issue raised here. It does solve Sophie her refreshing problem most likely. Also, my advice would be to leave the privacy levels intact. They are there for a reason. If you set your privacy levels correctly (usually organizational), than you shouldn't have any problem refreshing via a gateway, as long as you have a "common" datasource (there are exceptions, where you might need to build a custom connector).