Forum Discussion

SimonT88's avatar
SimonT88
Regular Visitor
1 year ago
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...
Need Help
  • SimonT88's avatar
    SimonT88
    1 year ago

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

Akash_Varuna's avatar
Akash_Varuna
Icon for Super User rankSuper User
1 year ago

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