Forum Discussion

gampy's avatar
gampy
Advocate I
4 years ago

Power Query’s Data Privacy Firewall

Hello Community! I get a well-known firewall error when I try to embed data received from another source (DataFlow) into an SQL subquery. The option "Always ignore Privacy Level Settings" is set in ...
Dataflow
Need Help
GilbertQ's avatar
GilbertQ
Super User
4 years ago

Hi gampy 

 

I have found that the only way to get it working is to refactor as per the suggestion in your link.

 

Or what I have done is to then put all the queries into a single table to get it to run.