cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
h4tt3n
Resolver I
Resolver I

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

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

 

1 ACCEPTED SOLUTION
lbendlin
Super User III
Super User III

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.

View solution in original post

2 REPLIES 2
h4tt3n
Resolver I
Resolver I

@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

lbendlin
Super User III
Super User III

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.

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Kudoed Authors