How to update the credentials of a dataset with a Service Account

[Charline_74]

Hello,

I have set up a deployment pipeline and so I am using a Service Principal. And I would like to add a refresh task for the dataset once deployed. However when this task is executed I get this error:

Do you have a solution to update the credentials automatically with a Service Principal ?

[v-rzhou-msft · Accepted solution]

Hi @Charline_74 , 

According to your statment, I think you want to update the dataset credential with Service Principal.

For reference:

Refresh a Power BI Dataset with PowerShell and a Service Principal

The Tenant Management Application for Power BI

Just for example,

1.  Allow service principals to use Power BI APIs in Admin Portal Allow service principals to use Power BI APIs
2.  Add the Service Principal as an Admin to the workspace

Then verify if you are experiencing a problem similar to the one in the posts below. If so, you can refer to the solution to solve your problem.

How to update Azure SQL datasource credentials of PowerBI dataset programmatically?

 

Best Regards,
Rico Zhou

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