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...
Hi nixonyx ,
According to your description, it sounds like a common power query error message when you invoke other query steps. Maybe you can take a look at following link to know how to deal with this:
Power Query Errors: Please Rebuild This Data Combination
Please understand that this link is provided with no warranties or guarantees of content changes, and confers no rights.
Regards,
Xiaoxin Sheng
- 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 stagesHi 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.
