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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. 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
Helper V
Helper V

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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