Today we had a great announcement about Azure Data Factory and Snowflake:
ADF now supports data integration with Snowflake
Power BI Dataflows now support data integration with Snowflake
But the next thing I tried today was using the native Snowflake Connector in Power BI Dataflows. And it works – very good news for my projects where we were struggling with ODBC connections through a Power BI Gateway.
NOW the native Snowflake Connector can be used in Dataflows, but how? There is still no Database Connector in the “Get Data” Dialog:
Solution, just copy and paste the query from Power BI Desktop:
Source = Snowflake.Databases() will be recognized now:
Related reading: Snowflake Account Usage in Power BI, Snowflake and Microsoft Azure Data Factory, and A Jump Start to Power BI Dataflows.
Views: 571