topic Re: Update DataSet Credentials using Service Principal in Developer

Update DataSet Credentials using Service Principal

akarkal — Mon, 13 Dec 2021 16:09:29 GMT

- I have a dataset that is setup to load data from Azure Storage

- I recently switched to using Service Principal.

- I am trying the below code after taking ownership of the dataset

- tenant settings has the toggle enabled for service principal to access admin apis

- service principal is the admin of the workspace (groupId) used below

- There are no gateways configured as all the data is in azure.

- However when I use access the dataset using C# nuget package, the gatewayId on datasource is populated.

 var datasources = powerbiClient.Datasets
                .GetDatasourcesInGroup(groupId, dataSetId.ToString()).First();
Assert.NotNull(datasource.GatewayId.Value)

the only way I found to update a datasource was

var credentials = new CredentialDetails(
                @"{""credentialData"":[{""name"":""accessToken"", ""value"":""" + accessToken + @"""}]}",
                CredentialType.Anonymous,
                EncryptedConnection.NotEncrypted,
                EncryptionAlgorithm.None,
                PrivacyLevel.None
            );
   powerbiClient.Gateways
        .UpdateDatasource(datasource.GatewayId.Value, dataSetId, new UpdateDatasourceRequest(credentials));

However I get error that the action is unauthorized.

I don't see any gateways in app.powerbi.com (not as admin) and I get empty result when I get all gateways

How do I update credentials of data set that the Service Principal is the owner of?

Re: Update DataSet Credentials using Service Principal

Anonymous — Thu, 16 Dec 2021 08:21:01 GMT

Hi @akarkal ,

First, please review the following links to check if you have missed any necessary step.

Refresh a Power BI Dataset with PowerShell and a Service Principal

The Tenant Management Application for Power BI

Just for example,

Allow service principals to use Power BI APIs in Admin PortalAllow service principals to use Power BI APIs
Add the Service Principal as an Admin to the workspaceAdd the Service Principal as an Admin to the workspace

Then verify if you are experiencing a problem similar to the one in the posts below. If so, you can refer to the solution to solve your problem.

How to update Azure SQL datasource credentials of PowerBI dataset programmatically?

Best Regards

Re: Update DataSet Credentials using Service Principal

Anonymous — Tue, 21 Dec 2021 09:29:06 GMT

Hi @akarkal ,

Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem with you. Thank you.

Best Regards