Forum Discussion
Snowflake-based project update via gateway
So why are we installing On-Premise Gateway? I want to connect to Snowflake directly. I installed On-Premise Data Gateway and I added a Snowflake data source to: https://app.powerbi.com/groups/me/gateways/. The 'Test Connection' button indicated the connection was successful. However, I'm still receiving a message to install a personal gateway.
Yes, I absolutely agree, connecting directly to Snowflake would make much more sense :)
Cyber81 Anonymous
Accodring to July Feature Summary, on-premises data gateway is needed for the Service connection to Snowflake. If you prefer to connect to Snowflake directly without any gateway, You can create an idea in https://ideas.powerbi.com.
Best Regards,
HerbertI created an idea here: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/20446081-connect-to-live-data-in-snowflake-from-the-powerbi
I have had all kinds of trouble getting the PowerBI.com service to recognize my Snowflake datasets so that I can refresh them through the gateway. If anyone at MS has time to help me debug I would love to help.
I'm running into similar problems. There needs to be a well crafted Data Gateway server configuration document. I've received guidance from one Microsoft contact that suggested we install the ODBC driver on the server and, then, add an ODBC Data Source Type rather than a Snowflake Data Source Type to the Data Gateway connections. In which case, I'd ask what is the point of the Snowflake Data Source Type? A member of my team suggested we should ask about the JDBC driver, but there is not guidance on where to place or how to install this driver on the Data Gateway server.
