Snowflake-based project update via gateway

Cyber81

Have you downloaded the latest on-premises gateway? According to this blog, after you install this month’s Gateway update, you will be able to register your Snowflake instances in the “Add Data Source” page within the Power BI Service.

Best Regards,
Herbert

v-haibl-msft
Hello Herbert,

actually yes, I have done so. I have downloaded both new version of PBI Desktop (2.48.4792.481) and Gateway (14.16.6390.2). PBI Desktop Snowflake connector is production version, not beta. In PBI Service I can see an option to add Snowflake database (which wasn't there before July) and the screenshot above is from adding credentials using this source.
Previously (this June) I was able to connect to the same Snowflake database using ODBC connector and it worked fine.
Anyways, does it really need to connect through Gateway? I was hoping PBI Service would connect directly to Snowflake database.

Thanks for any other comments,
Jiri

Cyber81

Could you please help collect the fiddler traces during register your Snowflake instances in the “Add Data Source” page within the Power BI Service?

Best Regards,
Herbert

@v-haibl-msft

Fiddler trace

Cyber81

It seems that you've already resolve the original problem by re-installing the 64 bit version Snowflake driver. You only need to register the on-premises data gateway with correct server and database name.

Best Regards,
Herbert

Issue resolved.

The problem was eventually solved by:
1) uninstalling the gateway
2) rebooting PC
3) re-installing the gateway
4) removing the data source from PBI service
5) adding new data source to PBI service using snowflake warehouse name as database name

Thanks to v-haibl-msft for help!

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.