Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
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
Solved! Go to Solution.
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.
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
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
Try:
$refreshScheduleState = '"true"'
Cheers, Mike
@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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
2 | |
2 | |
1 | |
1 |