topic Dataset based on Dataflows - update credentials in Developer

Dataset based on Dataflows - update credentials

RakeshSinghr — Tue, 04 May 2021 10:20:29 GMT

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

Re: Dataset based on Dataflows - update credentials

v-lionel-msft — Fri, 07 May 2021 05:20:41 GMT

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.

Re: Dataset based on Dataflows - update credentials

RakeshSinghr — Fri, 07 May 2021 08:31:23 GMT

@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.