Update Data source credentials via API for SharePoint Online

[tzavertnik]

Has anyone had any success updating the Data source credentials via API when the Data Source is a SharePoint site? I have a Power BI Report (pbix) which is added to a workspace via the API but the refresh errors out because the credentials have to be re-added. I would like to update the OAuth credentials via the API. Is that possible? Thanks.

[v-shex-msft · Accepted solution]

Hi @tzavertnik,

You can refer to the following link to use 'account/password' or 'client/secret id' to get an access token for rest API usages:

Solved: Pull data from a REST API Authentication - Microsoft Power BI Community
In addition, you can also try to create a custom data connector to package the rest API and corresponding verify steps in it:

Chris Webb's BI Blog: Connecting To REST APIs With OAuth2 Authentication In Power Query/Power BI Chr...

Start developing custom connectors for Power Query - Power Query | Microsoft Docs
Regards,

Xiaoxin Sheng

[Gabrielmoraisdt]

I'm sorry, but how does this solve his/her problem?!

We also have the need to set the credentials for Sharepoint Online via the API, and until now had no luck. Can anyone else help?