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?
