Forum Discussion

Capstone's avatar
Capstone
Icon for Resolver I rankResolver I
3 years ago
Solved

Change data source credentials to service principal

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 org...
Need Help
  • v-yadongf-msft's avatar
    v-yadongf-msft
    3 years ago

    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.

v-yadongf-msft's avatar
v-yadongf-msft
Icon for Community Support rankCommunity Support
3 years ago

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.