Multiple Connections Same Snowflake Server

[chris_decker]

I am having a similar issue to the one described here, where I have multiple databases on the same server each with different access credentials: https://community.powerbi.com/t5/Desktop/Connect-to-multiple-SQL-Server-databases-on-the-same-server...

However, I am using Snowflake and the Snowflake connector does not have an option to set database-level credentials. My thought would be to set up separate connections for each of them, but since they all use the same server and warehouse, I do not seem to be able to; when I try I just end up editing the existing connection.

Is there a way to force Power BI to create a separate connection for the same server/warehouse? Or is there any other way I could resolve this issue?

[v-rzhou-msft · Accepted solution]

Hi @chris_decker ,

As far as I know, we could only input Server and Warehouse in Snowflake connector in Power BI Desktop.

So we could not determind the database directly by Snowflake connector.

For reference: Connect to Snowflake in Power BI Desktop

We can add Database (advanced option) as parameter in query in Advanced Editor in Power Query Editor.

For reference:

Connect using advanced options

Best Regards,
Rico Zhou

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