Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

Multiple connections to the same sql warehouse with different credentials using the same user

So basically I have the following scenario: I have a CICD pipeline (using a Service Principal credentials) that is responsible for deploying power bi files from multiples teams in multiples workspaces. All datasets from all teams share the same SQL Warehouse in Databricks. This means that the process is creating only one connection to Databricks.
My issue is that these datasets came from different databases, each of these databases have dedicated a service user that only has access to that specific database. So one dataset can only be connected to a single database. My plan is creating one token per service user and use this token in the datasource connection in power bi. So basically each dataset could have a dedicated connection but because I'm using a single user to deploy everything if I update the connection for a new dataset, it will update for all dataset that already exists in power bi.

 

Is there a way of setting different credentials (multiple connections) to the same SQL Warehouse in the same Power BI account for a single user?

1 REPLY 1
GilbertQ
Super User
Super User

Hi @Anonymous 

 

As far as I know this is not possible today.

 

You will need to create a seperate data source for each connection which would then allow you to create a different credential.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors