Forum Discussion
Formula.Firewall - Query references other queries...
I see that this error crops up quite regularly on these fora but I haven't found a scenario that matches my experience. A former team member (who has left the organisation) created quite a comple...
Thanks for the suggestion.
I did follow that process, it's what I meant by breaking the query down into 'baby steps'. I separated the bigger query into multiple smaller, staging queries and still get the Formula.Firewall error when running the R script that uses those queries as the source
I will try again, maybe I put the break point at the wrong stages
I did follow that process, it's what I meant by breaking the query down into 'baby steps'. I separated the bigger query into multiple smaller, staging queries and still get the Formula.Firewall error when running the R script that uses those queries as the source
I will try again, maybe I put the break point at the wrong stages
Hi nixonyx ,
You can click on query table steps(applied steps panel) to review the result of that step. Please find out the first query steps who appears the error message.
Regards,
Xiaoxin Sheng
- The query fails at the R script step.
I have broken the query into as many individual steps as I can and still it fails with Formula.Firewall error at the R script step.
It runs fine on one PC but no other device. Rolling back the version of R to match the working device version hasn't worked. I am not sure how to determine what version of PBI desktop is running and whether it is from the Win10 store or downloaded exe.Hi nixonyx ,
I guess your query table not contain r script code, right?
If this is a case, I think it should invoke r script code from a local file, you can find out local file and move it to new device to fix this issue.
Running Local R Scripts in Power BI
Please understand that this link is provided with no warranties or guarantees of content changes, and confers no rights.
Regards,
Xiaoxin Sheng
- Thank you for the suggestion. I have had a look at the scripts and I cannot see any external links. The R scripts appear to be within the query. I'm assuming, from what you suggest, that I should see a file path reference to an external script? This is not evident in the queries.
However, you have given me an idea! Maybe I should move the scripts out of the queries and onto a network share? Would that work?