Change data source credentials to service principal

[Capstone]

All,

I have a dataset connected to an Azure SQL DW and published to a TEST workspace and it gets deployed to PROD via the deployment pipeline. It uses the OAuth2 authentication method and has organizational privacy setting while using my organzational credentials (connected via windows).

I would like to change the credentials in the TEST workspace to a non-prod service principal and in the PROD workspace to a different prod service principal. When I tried changing the credentials in the TEST workspace to the non-prod service principal, it also changed the credentials in the PROD workspace to the same service principal. Seems like I cant set two different credentials to the same dataset in TEST and PROD. Can anyone confirm this ?

[v-yadongf-msft · Accepted solution]

Hi @Capstone ,

You had to use another account to take over the dataset in one of the workspaces, so that you could set different credentials for the two datasets.

Here is a user who encountered the same problem as you and solved it successfully, this post is for your reference:

Solved: Add two different credentials for same data source... - Microsoft Power BI Community

Best regards,

Yadong Fang

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