Forum Discussion

JacksonAndrew's avatar
JacksonAndrew
Frequent Visitor
6 years ago
Solved

Connecting Snowflake to Dataflow

Hi,   Is there a way to connect Snowflake to Dataflow? The only option I found was Blank Query. But got an error:- The data source kind= "Snowflake" is unspported Regards, Jackson
Dataflow
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi JacksonAndrew ,

     

    Sorry for that, but based on thisocument,  it seems there is no direct connector for Snowflake in dafaflow  based on this document :

    The following list shows which connectors you can currently use by copying and pasting the M query into a blank query:

    • Azure analysis Services
    • Adobe Analytics
    • ODBC
    • OLE DB
    • Folder
    • SharePoint Online folder
    • SharePoint folder
    • Hadoop HDFS
    • Azure HDInsight (HDFS)
    • Hadoop file HDFS
    • Informix (beta)

    Have you tried to use the ocbc connector to get data from snowflake in dataflow?

     

    Best regards,

     

JacksonAndrew's avatar
JacksonAndrew
Frequent Visitor
6 years ago

v-lid-msft ,thanks for the suggestion. I'll try the ODBC and come back.

JacksonAndrew's avatar
JacksonAndrew
Frequent Visitor
6 years ago

v-lid-msft , ODBC works like a charm... thanks.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi JacksonAndrew ,
    Same situation here. Can you pls share how did you use ODBC for snowflake  in power bi service for dataflow

    When we are using blank query, and getting weird error - "The field 'OdbcErrors' of the record wasn't found".
    With the latest connectivity update between pbi -snowflake, we didnt need any driver installation while connecting from desktop to snowflake.
    Please help and thansk in advance.

    • JacksonAndrew's avatar
      JacksonAndrew
      Frequent Visitor
      6 years ago

      Anonymous - use by copying and pasting the M query into a blank query