Using Parameter in Queries

[allan_oliveira]

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?

[v-yingjl · Accepted 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 Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AlexisOlson]

This is a security settings issue. Check out this article referenced in these previous posts.