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 ...
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.