Today we had a great Annoucement 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 great news for my Projects where we 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:
Views: 504