topic Unable update Datasource Credentials using credential type as OAuth2 using Power BI Rest API in Developer

Unable update Datasource Credentials using credential type as OAuth2 using Power BI Rest API

Anonymous — Thu, 04 Jun 2020 13:34:27 GMT

Hello,

While trying to update a Datasource credentials for oAuth2 authentication using the Power BI Rest API, it throws an error saying the credentials are invalid.

Error: The credentials provided for the Web source are invalid.

(https://docs.microsoft.com/en-us/rest/api/power-bi/gateways/updatedatasource#oauth2-credentials-example )

As shown in this documentation, it requires an access token to be passed while using the API to change the data source credentials. It is not clear as to what type of access token needs to be used for this and how to generate the same.

Any help would be appreciated plus official documentation needs to be updated to include more details related to generation of access token.

Re: Unable update Datasource Credentials using credential type as OAuth2 using Power BI Rest API

Anonymous — Thu, 15 Jul 2021 11:03:25 GMT

Any succes with fixing this? I'm running into the same problem, need to update oauth2 credentials via the API for my dataset connection to a SharePoint file.

Re: Unable update Datasource Credentials using credential type as OAuth2 using Power BI Rest API

Anonymous — Wed, 03 Nov 2021 09:55:33 GMT

Same here:

Re: AccessUnauthorized on Mashup engine using Gateways - Update Datasource API

Re: Unable update Datasource Credentials using credential type as OAuth2 using Power BI Rest API

Anonymous — Thu, 09 Dec 2021 10:53:47 GMT

Here what worked for me:

https://community.powerbi.com/t5/Developer/AccessUnauthorized-on-Mashup-engine-using-Gateways-Update/m-p/2158106