Forum Discussion

vitaly's avatar
vitaly
Advocate II
9 years ago

Formula firewall error - possible bug

We are getting the error message "Formula.Firewall: Query '[Query Name]' (step '[Step Name]') references other queries or steps, so it may not directly access a data source. Please rebuild this data ...
vitaly's avatar
vitaly
Advocate II
9 years ago

Yes, I've seen that post. The question is, why is the formula firewall activating in the first place in our scenario? It sure seems like a bug to me.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

I think's it's supposed to be a feature rather than a bug, designed to prevent inadvertant security breaches - per https://social.msdn.microsoft.com/Forums/en-US/69153a6d-2205-4456-bcac-3a4689c787cf/parameterising-queries?forum=dataexplorer

"we have tried to optimize for the non-advanced user to do things easily and also protect them from cases like the above. For the more advanced user scenarios, they may need to go a bit off the happy path to make the scenario work, such as enabling this non-default mode."

 

I agree the product could be more helpful than just presenting "Formula firewall error"...  Add as an Idea?