Forum Discussion
Multiple Connections Same Snowflake Server
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-but/td-p/2109171
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?
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.