topic Re: REST API Dataflow refreshschedule fails to disable refresh in Developer

REST API Dataflow refreshschedule fails to disable refresh

rich_russell — Sat, 12 Mar 2022 20:31:50 GMT

I need to turn off the scheduled refresh of a dataset, via Powershell. I've successfully used the REST API to enable the refresh and set days/times, and the corresponding REST API works to disabled refresh on datasets. The Invoke-RestMethod call below does not return an error or throw an exception, but it has no effect on the dataflow:

function DisableDataflowRefresh([String]$workspaceId,[String]$dataflowId) {

$UserAccessToken = Get-PowerBIAccessToken

$bearer = $UserAccessToken.Authorization.ToString()

$url = 'https://api.powerbi.com/v1.0/myorg/groups/'+$workspaceId+'/dataflows/'+$dataflowId+'/refreshSchedule'

$headers = @{

'Authorization' = $bearer

'Content-Type' = 'application/json'

}

$body = @{

"value" = @{

"enabled"="false"

}

$bodyjson = $body | ConvertTo-Json

try {

(Invoke-RestMethod -Method PATCH -Uri $Url -Headers $headers -Body $bodyjson)

} catch {

write-output ">>> REST API failed with error $($Error[0])"

}

Thanks in advance!

Re: REST API Dataflow refreshschedule fails to disable refresh

rich_russell — Sun, 13 Mar 2022 18:31:01 GMT

Updating: I've worked past this, but for the life of me I don't know how. That is, I re-wrote the function (using exactly the same approach) on the off chance that doing so would avoid a typo or something in the original function...and the new function works. Old function still fails. So I'm going to slink away, knowing I've got some stupid mistake and suspecting that resolving it would not really enlighten anyone else, anyway.

Re: REST API Dataflow refreshschedule fails to disable refresh

lbendlin — Sun, 13 Mar 2022 18:39:54 GMT

Not sure if it matters but was a refresh running at the time? Assume you didn't change dataset ownership either?