Forum Discussion
Use SQL variables in Snowflake with ODBC connector
Hi Anonymous ,
The parameter can't be directly used in sql statement window, you need to modify it in anvanced editor. Please refer to Use Case 2: Loading Dynamic Columns from the Data Source in https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi Anonymous ,
Would you please try something like :
Odbc.Query("dsn=xxxx", "Select * from xxxxx where xxxxx="&Parameter&"")
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hello v-deddai1-msft , thanks, I think it could work as a workaround but to make it simple, I would like to declare and use variables directly in the SQL statement
Hi Anonymous ,
The parameter can't be directly used in sql statement window, you need to modify it in anvanced editor. Please refer to Use Case 2: Loading Dynamic Columns from the Data Source in https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Thank you!!