Forum Discussion
Formula.Firewall - Query references other queries...
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
