Update Datasource Credentials With OAuth2 using PowerBI Rest API on C#

Anonymous — Fri, 26 Apr 2019 12:36:27 GMT

Hello,

I need to update a Datasource credential, inside a Workspace on Powerbi, inside a C# Project.

I'm using the PowerBI Rest API to do it, but when I try to update the Datasource Credentials, I get an error.

Error Body:
"... HTTP/1.1 400 Bad Request
{"error":{"code":"BadRequest","message":"Bad Request","details":[{"message":"The property 'oauthcredentials' does not exist on type 'Microsoft.PowerBI.ServiceContracts.Api.GatewayDatasource'. Make sure to only use property names that are defined by the type.","target":"datasourceDelta"}]}}"

My code :

var AccessToken = userAuthnResult.AccessToken;
string restUrlPatchCredentials = PowerBiServiceRootUrl + "gateways/" + gatewayToUpdate.gatewayId + "/" + "datasources/" + gatewayToUpdate.id;
 
PBIDataSourceCredentials dataSourceCredentials = new PBIDataSourceCredentials
{
    credentialType = "OAuth2",
    oauthcredentials = new PBICredentialData
    {
        accessToken = AccessToken
    }
};
string jsonDelta = JsonConvert.SerializeObject(dataSourceCredentials);

// add JSON to HttpContent object and configure content type
HttpContent patchRequestBody = new StringContent(jsonDelta);
patchRequestBody.Headers.ContentType = new MediaTypeWithQualityHeaderValue("application/json");
 
var method = new HttpMethod("PATCH");
var request = new HttpRequestMessage(method, restUrlPatchCredentials);
request.Content = patchRequestBody;
 
HttpClient client = new HttpClient();
clien.DefaultRequestHeaders.Add("Accept", "application/json");
clien.DefaultRequestHeaders.Add("Authorization", "Bearer " + AccessToken);
 
var result = client.SendAsync(request).Result;

I think the error is the name of the "oauthcredentials" propriety, but i can't find the correct name.
Anyone having the same issue?

Thanks you!

Re: Update Datasource Credentials With OAuth2 using PowerBI Rest API on C#

waddockuk — Wed, 29 May 2019 13:04:33 GMT

i did you resolve this issue?

we have a very similar problem so would love to see your fix.

Thanks

Re: Update Datasource Credentials With OAuth2 using PowerBI Rest API on C#

nipunja — Thu, 27 Jun 2019 09:51:25 GMT

Any updates on this issue ?

topic Re: Update Datasource Credentials With OAuth2 using PowerBI Rest API on C# in Developer

Update Datasource Credentials With OAuth2 using PowerBI Rest API on C#

Re: Update Datasource Credentials With OAuth2 using PowerBI Rest API on C#

Re: Update Datasource Credentials With OAuth2 using PowerBI Rest API on C#