Forum Discussion
Snowflake custom SQL fails to load when merged in Power Query with another PowerBI Service dataflow
Hello fellow experts! We're having problems loading data from Snowflake into PowerBI desktop when using custom SQL. I appreciate this is relatively new feature having only just been released in J...
Anonymous have you tried to query the Snowflake database by using an ODBC connector within Dataflows?
As the Dataflow version of the Snowflake connector does NOT support Custom SQL Statements yet (as opposed to the PBI Desktop version which DOES support Custom SQL for Snowflake, see the latest posts here) using ODBC within Dataflows may actually resolve your issue. Note that ODBC connectors also allow you to add Custom SQL Statements.
We're talking about mixing existing dataflows and merging them with a custom Snowflake SQL query