Hi,I created a parameter based on an SQL query that shows the companies, but I would like to use this parameter inside another SQL query, but when the query ends, the following error appears:
"Formula.Firewall: Query 'Contratos' (step 'Source') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination"
How to resolve this?
Go to Solution.
Hi @allan_oliveira ,
Formula.Firewall errors are the result of Power Query’s Data Privacy Firewall which exists to prevent Power Query from unintentionally leaking data between sources.
In this case, the direct way to solve this issue is ignore all privacy levels in Power BI Desktop.
If you want to keep the privacy levels, you can refer Chris Webb's blog or Ken Paul's blog which introduce it in details.
For more details about Data Privacy Firewall, please refer: Behind the scenes of the Data Privacy Firewall
Best Regards,Community Support Team _ Yingjie LiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
View solution in original post
This is a security settings issue. Check out this article referenced in these previous posts.
Click here to read more about the December 2021 Updates!
Mark your calendars and join us for our next Power BI Dev Camp!
Learn how to create your own user groups today!