Update the parameter while using service principal with certificate

kulandai — Wed, 25 Sep 2024 13:17:01 GMT

Hi,

I'm trying to update the dataset parameters using update parameter api. But i'm unable to do it:

below is the code mockup:

var credentialDetails = new UpdateDatasourceRequest();

var oAuthTokenData = new CredentialData
{
credentialData = new List<Credential>
{
new Credential { Name = "accessToken", Value =GetSQLAccessToken().Result.ToString()}
}
};
credentialDetails.CredentialDetails = new CredentialDetails
{
CredentialType = "OAuth2",
Credentials = JsonConvert.SerializeObject(oAuthTokenData),
EncryptedConnection = "Encrypted",
EncryptionAlgorithm = "None",
PrivacyLevel = "None"

};
var getDatasources = pbiClient.Datasets.GetDatasourcesInGroup(workspaceId, pbiReport.DatasetId);
var refreshRequested = new RefreshRequest
{
NotifyOption = NotifyOption.NoNotification
};
if (getDatasources.Value.Count > 0)
{

pbiClient.Datasets.TakeOver(workspaceId, pbiReport.DatasetId);
await pbiClient.Gateways.UpdateDatasourceAsync((Guid)getDatasources.Value[0].GatewayId, (Guid)getDatasources.Value[0].DatasourceId, credentialDetails);
await pbiClient.Datasets.UpdateParametersInGroupAsync(workspaceId, datasetIds.FirstOrDefault().ToString(), updateRequest);
await pbiClient.Datasets.RefreshDatasetAsync(workspaceId, datasetIds.FirstOrDefault().ToString(), refreshRequested);
}

how ever i'm unable to perform UpdateDatasourceAsync .Why i'm using this is because to refresh the dataset , i need to use this method here i'm facing the issue and it returning the bad request. i'm using the SQL Acces token for the crendentials. Is there any way to update the parameter . please let us know

Re: Update the parameter while using service principal with certificate

lbendlin — Wed, 25 Sep 2024 17:59:18 GMT

does it work in the sandbox?

Datasets - Update Parameters In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Re: Update the parameter while using service principal with certificate

kulandai — Tue, 01 Oct 2024 13:16:12 GMT

Hi,

I'm trying to take over the dataset for update parameter, but however while taking over dataset credentials for that dataset is getting lost. So is there is any way to take over the dataset without credentials being lost.

Re: Update the parameter while using service principal with certificate

lbendlin — Tue, 01 Oct 2024 13:19:26 GMT

No, that's how this is designed, and (to me) it makes sense. Prevents unauthorized access and data loss.

topic Update the parameter while using service principal with certificate in Developer

Update the parameter while using service principal with certificate

Re: Update the parameter while using service principal with certificate

Re: Update the parameter while using service principal with certificate

Re: Update the parameter while using service principal with certificate