topic Re: Update Azure Blob Storage credentials using REST API in Developer

Update Azure Blob Storage credentials using REST API

sipati — Tue, 24 Dec 2019 10:39:11 GMT

I have a PowerBI report, and I want to update Accountname and accountkey using Rest API. I found a way to use parameter as an account name, but didn't find anything on AccountKey.

Any help regarding this? Is it possible to update it using this-
https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/updatedatasources
OR-
https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/updateparameters

In Any way?

Re: Update Azure Blob Storage credentials using REST API

Jayendran — Thu, 26 Dec 2019 09:19:07 GMT

Hi @sipati ,

Currently you couldn't able to use either parameters/ update datasource api to dynamically change the account key from the azure blob.

The only workaround for this, you have to use a gateway.

Parameter your azure blob storage account name
Configure both azure storage blobs in the gateways
Update the parameter to change the account name
Then automatically the report will use the other data source in the gateway.

Re: Update Azure Blob Storage credentials using REST API

NandanHegde — Thu, 30 Apr 2020 04:41:41 GMT

Hello @Jayendran ,

Any reason why it is not possible to update the Credentials for the Blob storage?

Becaue based on the MSFT documentation link :

https://docs.microsoft.com/en-us/rest/api/power-bi/gateways/updatedatasource#basic-credentials-example

we can patch the Cred with Key type :

So cant we use this powershell to update the cred:

Invoke-PowerBIRestMethod -Url "gateways/$($BounGateway.value.gatewayId)/datasources/$($BounGateway.value.id)" -Method PATCH -Body $Body | ConvertFrom-Json

where the body is the above JSON format .

Thanks

Re: Update Azure Blob Storage credentials using REST API

Jayendran — Sun, 03 May 2020 11:11:27 GMT

Hi @NandanHegde ,

Thanks for correcting me . I can confirm using update datasource you can update the keys.

Good catch ! Sorry for the wrong information

Re: Update Azure Blob Storage credentials using REST API

cnitchai — Fri, 30 Oct 2020 13:44:09 GMT

Good Morning... I can update the credential, but the records are not updating Did you succeed with this feature?

Re: Update Azure Blob Storage credentials using REST API

baden27 — Thu, 13 Oct 2022 08:16:50 GMT

Hi,

I hope you can help me!

How can i update my azure blob credentials in powerbi with SA access api (rest api)

I keep getting a bad request.

foreach($datasource in $datasources) {

Write-Host $datasource.DatasourceType

$gatewayId = $datasource.gatewayId

$datasourceId = $datasource.datasourceId

$ApiUrl = "https://api.powerbi.com/v1.0/myorg/gateways/$gatewayId/datasources/$datasourceId"

Write-Host "gatewayId $gatewayId"

Write-Host "datasourceId $datasourceId"

Write-Host "Patching url $datasourePatchUrl"

#Build the request body

$ApiRequestBody = @"

{

"credentialDetails": {

"credentialType": "Key",

"credentials": "{\"credentialData\":[{\"name\":\"key\", \"value\":\"MYKEY......\"}]}",

"encryptedConnection": "NotEncrypted",

"encryptionAlgorithm": "None",

"privacyLevel": "Private"

}

Invoke-PowerBIRestMethod -Url "gateways/$gatewayId/datasources/$datasourceId" -Method PATCH -Body $ApiRequestBody | ConvertFrom-Json -Verbose

Write-Output "Credentials for data source ""$DataSourceId"" successfully updated..." `n

}