How to Fix Formula.Firewall Error in Power Query

You've created a query that picks up the source file from a cell in an Excel worksheet. This is to allow users to easily change the file that they want the query to address. You post the file with the query to a network location so others can use it. The queries run fine for you but whenever anyone else tries to refresh the query they get an error that states "Formula.Firewall Error: this query references other queries or steps, so it may not directly access a data source. Please rebuild this data combination. It’s Another Power Query error, that’s actually really easy to fix and I will show you exactly how in this video.

Timestamps:
00:00 The Formula.Firewall Error to Fix
00:55 The Key to Fixing the Error
02:01 Understanding How Queries Depend on Each Other
04:47 How to Fix the Formula.Firewall Error

✅ Please see link to videos mentioned in this video:

✅ If you would like to buy me a coffee, so I can get my caffeine in to keep creating as many videos as possible for you :). It's really quick and easy, please use this link:

✅ For more videos please subscribe:

✅ Please also check out my Excel course on Udemy, please use this link:

An excellent, clear and efficient proposed solution.
The simulation of the failure was very well set up.
With this solution I was able to solve a problem with a report.
Thank you very much for all the effort in sharing knowledge.
Greetings from Bogotá - Colombia

[rameshep]

I was searching on this subject for quite some time. Thanks for posting with detailed explanation on the error.

[driverside]

Great videos ! learning so much with what things mean and how to use it in a clear and concise way. Amazing videos keep up the good work !

My only feed back is your intro and outro sound balance is way too loud. I could barely hear the explanations but then the outro actually hurt my hears through the head phones because i had to have the volume so high.

[RodolpheFALZERANA]

Very well explained! Simple and powerful solution! Thanks!

[rescogita]

Excelente, no encontraba la manera de resolverlo. Gracias por tu ayuda.

[cnesfgs]

After many searches about my error, this video resolve my problem. Thank you so much

[jeromeastier]

This is a killer, Love it!! Hats Off Miss Microsoft. Thank you so much for posting your videos.

[viniciusmoretti]

Thank you so much for the lesson. You helped me a lot!

I just subscribed in the channel

[pannerselvammaruthachalam]

Thank you so much for Detailed explanation.

[sunnygala]

This works, a very big thanks to you. :)

[AvinashKumar-qidy]

Thank you so much for this topic. Your videos are very well explained and making the subject easy to understand. Appreciate the efforts and work. Many Thanks.😊

[wken]

Thanks Miss Microsoft, this and the previous Dynamic Filepath video are superb 👏👏👏. I am now a happy subscriber and I look forward to watching more of your Power Query videos...Ken

[JaniceCook-jxpw]

This has been fantastic for me to have configurable data sources (great for switching between Live/Test, and different years). My user however is using Excel on a Mac and since switching to this method of accessing the source data, they get an error "Query ... is accessing data sources that have privacy levels which cannot be used together. Please rebuild this data combination" when they go to absolutely fine on my windows machine! Any ideas for the Mac?

[caschque]

Edit: TLDR: Use a parameter...

Well, I read the official documentation on the topic. What the Firewall needs is written in this one statement: "A partition may either access compatible data sources, or reference other partitions, but not both." A Partition is a split up query like e.g. instead of five steps you now have 3 steps in the first partition and 2 steps in the second, because each of these partitions contain a different reference to another object (e.g. Source and a merge step). The whole topic is under the slogan "Behind the scenes of data privacy wall". I still do not understand the issue with the sequential path, but whatever...

[erikanaya]

Hi there, i have problems Formula.Firewall: Query 'Display Corporativo (2)' (step 'Invoked Custom Function') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.

im using this code to get images form url

(url as text) as text =>
let
Image = "data:image;base64, " & Binary.ToText(Web.Contents(url), BinaryEncoding.Base64)
in
Image.

How can i ovoid the Firewall?

[erikanaya]

Hi there, i have problems Formula.Firewall: Query 'Display Corporativo (2)' (step 'Invoked Custom Function') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.

im using this code to get images form url

(url as text) as text =>
let
Image = "data:image;base64, " & Binary.ToText(Web.Contents(url), BinaryEncoding.Base64)
in
Image.

How can i avoid the Firewall?

[Faisal]

Is there a way to track changes in the data after refreshing power query