Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
SimonT88
Regular Visitor

Query references..... error when referencing a variable in a SQL query

I am pulling a table into Power Query and to speed it up I am doing the initial load with a SQL query with a WHERE clause that references a parameter that is input by the user in an excel table in the same xls. This all worked for me and sped things up nicely. However when other users refresh the query they get this error "Formula.Firewall: Query 'Dynamic query' (step 'Source') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination." Privacy Settings are none for both sources. I now get thie error as well

1 ACCEPTED SOLUTION
SimonT88
Regular Visitor

 If every user sets Data>Get Data>Query Options> Global Privacy to always ignore then it works. Thanks

View solution in original post

3 REPLIES 3
SimonT88
Regular Visitor

 If every user sets Data>Get Data>Query Options> Global Privacy to always ignore then it works. Thanks

SimonT88
Regular Visitor

Hi - yes the global settings are set to ignore privacy level and yes it works if I hard code the parameter in the sql query. 

 

Akash_Varuna
Community Champion
Community Champion

Hi 

First check in options settings global if the ignore privacy level has been checked

You could also check by passing the parameter directly thorugh sql query if you havent tried that do try

 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.