Formula.Firewall Query XXXXX refrences other queries tor steps

[maysamjahromi]

Hi there, I am trying to parameterize one of my reports (PowerBI) and the value of the parameter is coming from a query. I right-click on the column that I want to be a parameter and created a new query; I created a parameter that its value refers to the query; When I try to use the parameter in my query, I get the following error: Formula.Firewall: Query 'XXXXXXX' (Step 'Source') references other queries or steps, so it may not directly access a datasource; please rebuild this data combination. Thanks for your help.

[maysamjahromi · Accepted solution]

I found the solution ina article in mssqltips; I was using parameters wrong; PowerBI made life much easier and simpler, I simply filtered the column like excel and used parameters, I was trying to change query myself.

[v-piga-msft]

Hi @maysamjahromi,

Glad to hear the issue is resolved,  you can accept your reply as solution, that way, other community members would benefit from your solution.

Best  Regards,

Cherry

[maysamjahromi]

I found the solution ina article in mssqltips; I was using parameters wrong; PowerBI made life much easier and simpler, I simply filtered the column like excel and used parameters, I was trying to change query myself.

[jeffshieldsdev]

Please see this blog post: https://blog.crossjoin.co.uk/2017/06/26/data-privacy-settings-in-power-bipower-query-part-3-the-form...

[Anonymous]

This got me past the error.  Thanks for posting!