cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RakeshSinghr
Resolver I
Resolver I

Dataset based on Dataflows - update credentials

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

2 REPLIES 2
v-lionel-msft
Community Support
Community Support

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.

v-lionel-msft_1-1620364833447.png

 

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.

 

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

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors