Forum Discussion
Power Query Formula.Firewall Error in Desktop
I’m seeing a 'Formula.Firewall' error when I try to refresh my query. The message says about combining data sources, even though both sources are actually from the same file. This just started happening, so I’m a bit unsure what triggered it.
Mohit_009 Try the below approaches to resolve the issue.
1. Go to File -> Options and settings -> Data source settings, make sure both sources have the same privacy level and then refresh the query.2. You can enable ignore privacy levels option to bypass the privacy error.
5 Replies
Mohit_009 Try the below approaches to resolve the issue.
1. Go to File -> Options and settings -> Data source settings, make sure both sources have the same privacy level and then refresh the query.2. You can enable ignore privacy levels option to bypass the privacy error.
I think PQ throws that Firewall when the eval-scope slips inside the same file… if u open the query, hit Refresh Preview, set the Excel src to *Organizational*, and—if it still nags—add a tiny stg-hop so both reads stay in one context.
Hi Mohit_009
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Thank you.Hi Mohit_009
May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.
Thank you
