Dataset based on Dataflows - update credentials

[RakeshSinghr]

Hi,

    I have a dataset with 2 dataflows as the source in import mode.

Once the pbix file is published to power bi service programatically using service principal - appid, secret, Dataset refresh  via rest api's fail. The reason is credentils need to be updated or i'm having to manually take over and sign in.

Is there an alternative to manual steps? can we update/authenticate service principal programatically to then be able to refresh the dataset?

Thanks

[v-lionel-msft]

Hi @RakeshSinghr ,

Datasets - Refresh Dataset (Power BI Power BI REST APIs) | Microsoft Docs

Have you used this Rest API to refresh your dataset?

You can configure scheduled refresh for your dataset so that you don't need to update the credential every time you execute the refresh schedule.

Best regards,
Lionel Chen

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

[RakeshSinghr]

@v-lionel-msft yes i have used that API but the question is how to get around authenticating/signing in after dataset is deployed programtically. A direct refresh after deploying fails.