Forum Discussion
Formula.Firewall - Query references other queries...
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
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?Have you tried to separate your R script from directly referencing your data source script by using a function? You can create a staging query for your data source and then create a function on it to output a new query, and then you use the new query to do all the R transformations. Here is a post about that: Formula.Firewall Error Referencing Queries – R & Python Scripts
