Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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"
Is there already a solution for this problem?
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
The thing is that the exact same code works when i try to connect with an identified user (not a service principal).
I'm wondering itf this feature is not supported with service principal
Hi,
I'm facing the same problem 😞
have you found a solution?