Update the parameter while using service principal with certificate

[kulandai]

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

[kulandai]

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.

[lbendlin]

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

[lbendlin]

does it work in the sandbox?

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