topic Update parameter via Powershell API call in Developer

Update parameter via Powershell API call

h4tt3n — Mon, 30 Nov 2020 13:31:24 GMT

Hello, I am having some difficulties updating a dataset parameter via the PBI rest api. I am using PowerShell and "Import-Module MicrosoftPowerBIMgmt".

I have based my script on these ressources:
https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/updateparameters
https://community.powerbi.com/t5/Developer/Update-parameters-through-Powershell/td-p/1167203

I am pretty sure I got the syntax right, but the script *sometimes* returns an error, and I can't see any cange in the dataset after running it.

I have defined a string parameter named ReportVersion which I am trying to update. The parameter has "enable load" checked off and is visible in the report.

This is how I attempt to do it:

Connect-PowerBIServiceAccount $datasetId = "my dataset id" $urlUpdateParams = "https://api.powerbi.com/v1.0/myorg/datasets/$($datasetId)/Default.UpdateParameters" $body = '{ "updateDetails": [ { "name": "ReportVersion", "newValue": "2.0" } ] }' $content = 'application/json' write-host $urlUpdateParams Invoke-PowerBIRestMethod -Url $urlUpdateParams -Method POST -Body $body -ContentType $content Disconnect-PowerBIServiceAccount

The error I get looks like this:

Invoke-PowerBIRestMethod : One or more errors occurred. At C:\...\Power BI report upload tool 10.ps1:83 char:17 + ... Invoke-PowerBIRestMethod -Url $urlUpdateParams -Method PO ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : WriteError: (Microsoft.Power...werBIRestMethod:InvokePowerBIRestMethod) [Invoke-PowerBIRestMethod], AggregateException + FullyQualifiedErrorId : One or more errors occurred.,Microsoft.PowerBI.Commands.Profile.InvokePowerBIRestMethod

Can you help me pinpoint what is going wrong?

Thanks in advance,

Mike

Re: Update parameter via Powershell API call

Anonymous — Wed, 02 Dec 2020 06:02:59 GMT

Hi @h4tt3n,

How many requests did you send? Request data size? AFAIK, rest API has its usage limitation, you can take a look at the official document to confirm if your test has exceeded the limits.

Power BI REST API limitations

Regards,

Xiaoxin Sheng

Re: Update parameter via Powershell API call

h4tt3n — Wed, 02 Dec 2020 12:24:53 GMT

I am not POST'ing any data to the dataset, just small querys to update parameters or refresh datasets. I find it very hard to believe that these queries should exceeded the daily limit.

Re: Update parameter via Powershell API call

Anonymous — Tue, 08 Dec 2020 08:25:01 GMT

Hi @h4tt3n,

Any other operations based on rest API with your power bi contents? In addition, you can also try to remove the front part of the URL, this part seems not to use in the document samples:

$urlUpdateParams = "/datasets/$($datasetId)/Default.UpdateParameters"

Regards,

Xiaoxin Sheng