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
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?
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.