Forum Discussion
Unable to use snowflake variables while using Snowflake connector in Power BI
While copying snowflake query to Power BI with the help of snowflake connector gives error
Error
If I remove semicolon from variables gives me below error
Have anyone faced this before? or any solution known to resolve this case?
1 Reply
It's likely to be this: https://blog.crossjoin.co.uk/2022/03/06/why-not-all-sql-queries-can-be-used-as-a-source-in-power-bi-directquery-mode/
If you can't use the query as a subquery, it won't work.
