Forum Discussion

nixonyx's avatar
nixonyx
Helper I
7 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

nixonyx's avatar
nixonyx
Helper I
7 years ago
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?
  • sqlitybi's avatar
    sqlitybi
    Regular Visitor
    6 years ago

    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