In Power BI Embedded (App Owns Data) how to update Sharepoint credentials?

[nishanttayal]

Hi,

I am developing an custom app embedding Power BI using App Owns Data (Embed for your customers). In that I want to publish the report using custom app through service principle and then I am looking for way to update the Sharepoint connection of the report published through service principle as we want to refresh it at regular frequency.
I am able to publish the report using REST API's but as it is published through Service Principle so the Sharepoint credentials has become invalid. How can I update them using REST API's? 
I have read REST API documentation of Update Parameters in Group and Update Data Sources in Group but none of them making sense to me for Sharepoint.

[v-yueyunzh-msft]

Hi , @nishanttayal 

As far as I know, SharePoint is also a cloud service product of Microsoft, which uses your tenant's AAD account to log in and uses AAD tokens to access cloud services and embedded Power BI content, and the AAD tokens it uses expire every hour. At your convenience, you can try reading this document to explore ways to refresh your AAD token regularly to ensure that AAD tokens remain valid in your solution:

Microsoft identity platform refresh tokens - Microsoft Entra | Microsoft Learn

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

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

[nishanttayal]

Hey @v-yueyunzh-msft ,
Thanks for your response.
The above solution would work when we use AAD Tokens on PBI Desktop to connect with Sharepoint. 
However, I am looking for way to refresh data source credentials while publishing the report through service principle using Organization AD User and Password like the way it ask when we connect Sharepoint Data through Power BI Desktop.