Forum Discussion

rexgardner's avatar
rexgardner
New Member
3 years ago
Solved

Multiple Snowflake Connectors in the same tenant

Can you have two Snowflake connections, each pointing to two different instances of Snowflake in the same tenant?  New to PBI so hopefully I got the verbage correct.  Thanks!

  • Hi rexgardner ,

     

    Power BI offers two different connection types when connecting to your Snowflake instance: Import and Direct Query. Only AAD SSO  within Snowflake supports DirectQuery.

    When you use Desktop to connect Snowflake as below. It will prompt you to enter your Server and Warehouse ID, which can be located on Snowflake. Your server name will be the URL you use while connected to your Snowflake instance. 

    You can try to use multiple snowflake connectors to connect different instances of snowflake.

    And you can reference the following documents.

    How to Connect Power BI to Snowflake | phData

    Downloading Snowflake Clients, Connectors, Drivers, and Libraries — Snowflake Documentation

     

    Best Regards,
    Community Support Team _ xiaosun

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • v-xiaosun-msft's avatar
    v-xiaosun-msft
    Community Support

    Hi rexgardner ,

     

    Power BI offers two different connection types when connecting to your Snowflake instance: Import and Direct Query. Only AAD SSO  within Snowflake supports DirectQuery.

    When you use Desktop to connect Snowflake as below. It will prompt you to enter your Server and Warehouse ID, which can be located on Snowflake. Your server name will be the URL you use while connected to your Snowflake instance. 

    You can try to use multiple snowflake connectors to connect different instances of snowflake.

    And you can reference the following documents.

    How to Connect Power BI to Snowflake | phData

    Downloading Snowflake Clients, Connectors, Drivers, and Libraries — Snowflake Documentation

     

    Best Regards,
    Community Support Team _ xiaosun

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.