Unable to Update Datasource cerdentials using OAuth2 authentication

amol8286 — Mon, 20 May 2019 08:14:44 GMT

I'm trying to update datasource for my Power BI Reports using the " Gateways-Update Datasource" API. The Datasource is on cloud. I tried to use the below link to test it https://docs.microsoft.com/en-us/rest/api/power-bi/gateways/updatedatasource#oauth2_credentials_example

Below are other details:

Datasource: Cloud

OAuth2 Authentication

Gateway ID and Datasource ID entered which are mandatory

Body: as given in the example from the above link. In the Ket part I have entered the Baerer Key. Also tried with Refresh Key but same error.

Below is the Response:

{
"error": {
"code": "DM_GWPipeline_Gateway_InvalidConnectionCredentials",
"pbi.error": {
"code": "DM_GWPipeline_Gateway_InvalidConnectionCredentials",
"parameters": {},
"details": [
{
"code": "DM_ErrorDetailNameCode_UnderlyingErrorCode",
"detail": {
"type": 1,
"value": "-2147467259"
}
},
{
"code": "DM_ErrorDetailNameCode_UnderlyingErrorMessage",
"detail": {
"type": 1,
"value": "The credentials provided for the Dynamics365BusinessCentral source are invalid. (Source at Dynamics365BusinessCentral.)"
}
},
{
"code": "DM_ErrorDetailNameCode_UnderlyingHResult",
"detail": {
"type": 1,
"value": "-2147467259"
}
},
{
"code": "Microsoft.Data.Mashup.CredentialError.DataSourceKind",
"detail": {
"type": 1,
"value": "Dynamics365BusinessCentral"
}
},
{
"code": "Microsoft.Data.Mashup.CredentialError.DataSourceOriginKind",
"detail": {
"type": 1,
"value": "Dynamics365BusinessCentral"
}
},
{
"code": "Microsoft.Data.Mashup.CredentialError.DataSourceOriginPath",
"detail": {
"type": 1,
"value": "Dynamics365BusinessCentral"
}
},
{
"code": "Microsoft.Data.Mashup.CredentialError.DataSourcePath",
"detail": {
"type": 1,
"value": "Dynamics365BusinessCentral"
}
},
{
"code": "Microsoft.Data.Mashup.CredentialError.Reason",
"detail": {
"type": 1,
"value": "AccessUnauthorized"
}
},
{
"code": "Microsoft.Data.Mashup.MashupSecurityException.DataSources",
"detail": {
"type": 1,
"value": "[{\"kind\":\"Dynamics365BusinessCentral\",\"path\":\"Dynamics365BusinessCentral\"}]"
}
},
{
"code": "Microsoft.Data.Mashup.MashupSecurityException.Reason",
"detail": {
"type": 1,
"value": "AccessUnauthorized"
}
}
],
"exceptionCulprit": 1
}
}
}

Kindly let me know if I have missed something....

Re: Unable to Update Datasource cerdentials using OAuth2 authentication

amol8286 — Tue, 21 May 2019 06:22:43 GMT

Any inputs my above query...

Re: Unable to Update Datasource cerdentials using OAuth2 authentication

rahulverma — Wed, 22 May 2019 06:06:16 GMT

Hi @v-qiuyu-msft Can you please check it out as we are getting the same problem while updating the credentials using the rest api and data source is Dynamics business central.

Re: Unable to Update Datasource cerdentials using OAuth2 authentication

Anonymous — Wed, 03 Nov 2021 09:59:20 GMT

Same problem here:

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

A valid response from a MS expert would be highly appreciated.

Re: Unable to Update Datasource cerdentials using OAuth2 authentication

Anonymous — Thu, 09 Dec 2021 10:50:49 GMT

Here the solution that worked for me:

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

topic Unable to Update Datasource cerdentials using OAuth2 authentication in Developer

Unable to Update Datasource cerdentials using OAuth2 authentication

Re: Unable to Update Datasource cerdentials using OAuth2 authentication

Re: Unable to Update Datasource cerdentials using OAuth2 authentication

Re: Unable to Update Datasource cerdentials using OAuth2 authentication

Re: Unable to Update Datasource cerdentials using OAuth2 authentication