Forum Discussion
Formula.Firewall error when using if-then-else
Hi Anonymous ,
Ken Puls blogged about this here
Power Query Errors: Please Rebuild This Data Combination
And, @freder1ck summed it upbrilliantly in the following post: "...each query needs to be loaded into a staging query first. Then, you can combine these staging queries."
Formula.Firewall: Query references other queries, so it may not directly access a data source.
Try to refer to this post in the hope of helping you.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The formula firewall is there to prevent accidental or malicious cross-site scripting. That's what your code is trying to do, basically.
One (crude) remedy would be to run both queries first (you will need to set the privacy level accordingly) and then run the if then else logic.