Forum Discussion
Error using a service principal with Method Patch on PowerBI REST API to update refresh schedule
Hello,
I'm facing an issue (bad request) using method patch with service principal on API REST PowerBI.
I'm currently working on a powershell script to deploy a pbix file with a service principal.
The script works fine. It does :
- Connect to PowerBI Service
- Create report and dataset
- Update parameter (credentiels)
- BindToGateway (with principal service added to user of the gateway, thanks to Adam Saxton)
- Refresh
but impossible de UpdateRefreshSchedule. It's only API Call with Method Patch.
$ApiBindToGatewayUrl="https://api.powerbi.com/v1.0/" + $TenantId + "/groups/" + $WorkspaceObject.Id + "/datasets/" + $DatasetId + "/Default.BindToGateway"
Invoke-PowerBIRestMethod -Url $ApiBindToGatewayUrl -Method Post -Body ("$ApiBindToGatewayRequestBody")
Write-Host "Gateway bind end"`r`n
$headers = Get-PowerBIAccessToken
$ApiRefreshScheduleUrl = "https://api.powerbi.com/v1.0/" + $TenantId + "/groups/" + $WorkspaceObject.Id + "/datasets/" + $DatasetId + "/refreshSchedule"
$ApiRefreshScheduleRequestBody = @"
{
"value":{
"days":[
"Sunday",
"Tuesday",
"Friday",
"Saturday"
],
"times":[
"07:00",
"11:30",
"16:00",
"23:30"
],
"localTimeZoneId":"UTC"
}
}
"@
Method 1 = Invoke-PowerBIRestMethod -Url $ApiRefreshScheduleUrl -Method Patch -Body ("$ApiRefreshScheduleRequestBody") | ConvertFrom-Json
Method 2 = Invoke-RestMethod -Uri $ApiRefreshScheduleUrl -Headers $headers -Method POST -Body ("$ApiRefreshScheduleRequestBody") -ContentType "application/json"
4 Replies
- lbendlin
Super User
Your body data looks ok, but the inclusion parameter looks weird. Try this format (adjust as needed):
$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 Is there already a solution for this problem?
