Forum Discussion
Solved
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 th...
If every user sets Data>Get Data>Query Options> Global Privacy to always ignore then it works. Thanks
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.