Skip to main content

    Power BI

    New

    Snowflake connector should not require On-Premises gateway

    Vote (48) Share
    Mac White's profile image

    Mac White on 13 Apr 2018 00:49:43

    Connecting to snowflake is great in Development.
    It did require a download of the ODBC connector. Is there a way, that we could have this baked in when publishing the report, otherwise I need to do this locally and then publish, or establish an On-Prem gateway.

    I would really love if Snowflake connections did not require an On-Premises gateway

    Comments (3)
    Mac White's profile image Profile Picture

    d3d350f5 68ec-4ac4-aa65-543002586941 on 06 Jul 2020 00:08:32

    RE: Snowflake connector should not require On-Premises gateway

    Looks like PBI no longer requires the on-premise gateway for Snowflake data sources

    Check out the PBI blog: https://powerbi.microsoft.com/en-us/blog/announcing-enhanced-connectivity-for-snowflake/

    Mac White's profile image Profile Picture

    f44f55e7 d6e8-4077-8a8f-986eba794a04 on 06 Jul 2020 00:02:48

    RE: Snowflake connector should not require On-Premises gateway

    Yes, this seems like a no-brainer! Snowflake is a cloud resource as is Power BI. Why would we need a gateway?

    Mac White's profile image Profile Picture

    a6966d00 35c5-4f4f-b011-1f73ec2a9792 on 05 Jul 2020 23:42:42

    RE: Snowflake connector should not require On-Premises gateway

    It would be helpful to know if this is technically feasible, particularly when it comes to Snowflake on Azure. There are probably logistical challenges for Snowflake's own VNET/public network endpoints as well as potential challenges around which Azure region hosts the tenant's PowerBI instance vs. Snowflake's Azure region.