Forum Discussion

arusky's avatar
arusky
Frequent Visitor
4 years ago

Power BI Dataflow from Snowflake without Gateway

Hi,   I am currently grabbing the data from Snowflake using advanced editor to query the data in dataflow. It requires the data gateway to be on, and I wonder if we can connect the dataflow to Sno...
Dataflow
Need Help
Tips and Tricks
DarinSpence's avatar
DarinSpence
Icon for Helper II rankHelper II
3 years ago

Here's what I've tried so far to connect a Power BI Service Dataflow to a Snowflake database:

  1. Downloaded and Installed Snowflake ODBC Driver to my local computer:  ODBC - Snowflake Developers
  2. Successfully setup ODBC connection
  3. Used the ODBC connection in Power BI desktop to conect to Snowflake, worked great!
  4. Installed Power BI Gateway on local computer
  5. Tried creating a Dataflow, ODBC, and copied the M from Power BI Desktop into the Power BI Service Dataflow.  Didn't work.
  6. Tried createding a Dataflow, Snowflake this time, and was able to get a list of the databases on Snowflake, but when I tried to drill-down on the tables the query failed.

I submitted a ticket and we captured network traces when using Power BI Service to create a Dataflow for analysis.