topic Re: Update Data source credentials via API for SharePoint Online in Developer

Update Data source credentials via API for SharePoint Online

tzavertnik — Sat, 05 Feb 2022 21:31:03 GMT

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.

Re: Update Data source credentials via API for SharePoint Online

Anonymous — Tue, 08 Feb 2022 01:51:09 GMT

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 Chris Webb's BI Blog (crossjoin.co.uk)

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

Xiaoxin Sheng

Re: Update Data source credentials via API for SharePoint Online

Anonymous — Wed, 30 Mar 2022 19:49:59 GMT

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?