Forum Discussion
R Scripts and Firewall Error
I read the Excel Guru article but I've only had partial success.
For some queries it works if I move the R script into an earlier query (the staging query) that loads the data from the CSV, rather than placing the R script in a later query that connects to the staging area. Which is odd, because that's not what I'm using staging queries for.
That works but only as long as my staging queries contain all the right data. If I want to use R in a later query, there doesn't seem to be a working solution to get around the firewall error, execpt for switching off the whole privacy thing.
Hi Anonymous ,
Sometimes it helps to transform the query into a function (without a parameter) instead.
Go to the advanced editor and add a " () =>" in front of the existing code (so before the "let").
Then your have to modify the dependent queries by adding parenthesis after the query reference.
So if your R-query (that previously returned a table) is called "MyRQuery", then you reference it like so "MyRQuery()".
This calls the function without a parameter and thereby returning the original result.
This sometimes "fools" the engine an will not be checked by the firewall logic.