topic Re: Keep getting a 400 Bad Request error when trying to update refresh schedule via API in Developer

Keep getting a 400 Bad Request error when trying to update refresh schedule via API

h4tt3n — Fri, 26 Feb 2021 07:57:02 GMT

Hello folks,

I am developing Power BI reports and managing them via API calls as a part of my job. I have developed a number of powershell scripts to streamline management via the rest API. It all works pretty well, except when I attempt to update a refresh schedule of a report. Some details:

Enabling scheduled refresh is done separately and is not a problem
I have taken over or is aleady the dataset owner.
Updating the refresh schedule consistently returns a 400 Bad Request error.

Here are the PS functions:

function EnableDatasetRefreshSchedule { [CmdLetBinding()] param ( [Parameter(Mandatory=$true, Position=0)] [string] $groupId, [Parameter(Mandatory=$true, Position=1)] [string] $datasetId, [Parameter(Mandatory=$true, Position=2)] [string] $refreshScheduleState ) $urlRefreshScedule = "https://api.powerbi.com/v1.0/myorg/groups/$groupId/datasets/$datasetId/refreshSchedule" $body = '{ "value": {"enabled": '+$refreshScheduleState+' }}' Invoke-PowerBIRestMethod -Url $urlRefreshScedule -Body $body -Method PATCH } function UpdateDatasetRefreshScheduleTime { [CmdLetBinding()] param ( [Parameter(Mandatory=$true, Position=0)] [string] $groupId, [Parameter(Mandatory=$true, Position=1)] [string] $datasetId, [Parameter(Mandatory=$true, Position=2)] [string] $refreshScheduleDays, [Parameter(Mandatory=$true, Position=3)] [string[]] $refreshHours, [Parameter(Mandatory=$true, Position=4)] [string[]] $refresMinutes ) $randomHour = $refreshHours | Get-Random $randomMinute = $refresMinutes | Get-Random $refreshScheduleTime = '"'+$randomHour+':'+$randomMinute+'"' $urlRefreshScedule = "https://api.powerbi.com/v1.0/myorg/groups/$groupId/datasets/$datasetId/refreshSchedule" #$body = '{ "value": {"days": ['+$refreshScheduleDays+'], "times": ['+$refreshScheduleTime+'],"localTimeZoneId": "UTC"}}' $body = '{"value": {"days": ['+$refreshScheduleDays+'], "times": ['+$refreshScheduleTime+']}}' Invoke-PowerBIRestMethod -Url $urlRefreshScedule -Body $body -Method PATCH }

Any hints on what might be wrong is very appreciated!

Cheers, Mike

Re: Keep getting a 400 Bad Request error when trying to update refresh schedule via API

lbendlin — Sun, 28 Feb 2021 02:40:11 GMT

Always test your API calls in the sandbox.

Datasets - Update Refresh Schedule In Group (Power BI Power BI REST APIs) | Microsoft Docs

Refreshes can only be scheduled at :00 and :30 (top and bottom of hour). You can't supply a random minute number.

Re: Keep getting a 400 Bad Request error when trying to update refresh schedule via API

h4tt3n — Mon, 01 Mar 2021 06:58:33 GMT

@lbendlin

"Refreshes can only be scheduled at :00 and :30 (top and bottom of hour). You can't supply a random minute number."

This indeed was the problem. Unfortunately, it appears thet the official documentation does not cover this crucial detail. Also, the error returned simply states "Bad request", which is not very helpful. But your reply was, thank you.

Cheers, Mike

Re: Keep getting a 400 Bad Request error when trying to update refresh schedule via API

shubhamquick — Thu, 30 Sep 2021 08:03:04 GMT

Hi,

Trying to automate the schedule refresh enable portion once they are in disable state.

Using below code:-

$refreshScheduleState ="true"

$urlRefreshScedule = "https://api.powerbi.com/v1.0/myorg/groups/{groupid}/datasets/{datasetid}/refreshSchedule"

$body = '{ "value": {"enabled": '+$refreshScheduleState+' }}'

Invoke-PowerBIRestMethod -Url $urlRefreshScedule -Body $body -Method PATCH

But getting error while running this code.

Invoke-PowerBIRestMethod : One or more errors occurred.
At line:1 char:2
+ Invoke-PowerBIRestMethod -Url $urlRefreshScedule -Body $body -Method ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : WriteError: (Microsoft.Power...werBIRestMethod:I
nvokePowerBIRestMethod) [Invoke-PowerBIRestMethod], AggregateException
+ FullyQualifiedErrorId : One or more errors occurred.,Microsoft.PowerBI.C
ommands.Profile.InvokePowerBIRestMethod

Kindly suggest

Re: Keep getting a 400 Bad Request error when trying to update refresh schedule via API

h4tt3n — Thu, 30 Sep 2021 08:28:20 GMT

Try:

$refreshScheduleState = '"true"'

Cheers, Mike

Re: Keep getting a 400 Bad Request error when trying to update refresh schedule via API

lbendlin — Thu, 30 Sep 2021 17:47:48 GMT

This works for me:

$uri = "https://api.powerbi.com/v1.0/myorg/groups/$groupsPath/datasets/$datasetID/refreshSchedule" $body = "{ value : { enabled :`"true`" }}" $res = Invoke-RestMethod -Uri $uri –Headers $authHeader –Method PATCH -body $body