Forum Discussion

markive's avatar
markive
Advocate II
10 years ago
Solved

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

I am creating a lot of reports but they always hit the same API's on my app. To try to speed up the manual creation of reports I created a table called APISettings with a ProjectURL column. This mean...
Need Help
  • pqian's avatar
    pqian
    10 years ago

    Hi markive, the Firewall error is thrown when one evaluation is trying to access more than one data sources. Normally we partition your query automatically to split it into multiple evaluations across data sources, but there are some cases where this partitioning isn't smart enough. Can you post the query which has this problem?

     

    Alternatively, you can turn this off in Options->Global->Security->Privacy Levels->Always Ignore (machine wide), or Options->File->Privacy (for the current file)

pqian's avatar
pqian
Microsoft Employee
10 years ago

Hi markive, the Firewall error is thrown when one evaluation is trying to access more than one data sources. Normally we partition your query automatically to split it into multiple evaluations across data sources, but there are some cases where this partitioning isn't smart enough. Can you post the query which has this problem?

 

Alternatively, you can turn this off in Options->Global->Security->Privacy Levels->Always Ignore (machine wide), or Options->File->Privacy (for the current file)