Formula.Firewall: Query

[Anonymous]

Hi experts!

I changed the path of my datasource to another file, but when I applied it I got a firewall error:

Formula.Firewall: Query 'f_cas' (step 'Expanded Table Column1') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.

I want to know how I can solve this. I have read som posts that this can happen when you merge to sources but Im not merging. I just applied the same step with a different file name so dont undertsand why its not working?

We have already defined a Brand variable which tells which file path to select for the current brand report. Thats why we have this query: the yellow is the only thing I changed

then I have another query which packs out the file in the way we want: the yellow is the only thing I changed

Can anyone please tell me why its not working and how I can fix this?

[Anonymous]

Hi @Anonymous ,

Please try disabling data privacy checks. See if these two blogs by Chris Webb are helpful.

Part 4: Disabling Data Privacy Checks

Part 3: The Formula.Firewall Error

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum