Forum Discussion

SofBL's avatar
SofBL
Icon for Advocate II rankAdvocate II
1 year ago
Solved

update-refresh-schedule-in-group error 415 Unsupported media type using powershell

Hello everyone,  Using the script below I try to update a dataset refresh schedule I Think this thing is OK I tried all kind of variations on it. but it keeps responding Invoke-RestMethod : The ...
Need Help
  • SofBL's avatar
    SofBL
    1 year ago

    https://github.com/mschoombee/Blog/blob/main/2020/automating-power-bi-deployments/Reports%20-%20Update%20Refresh%20Schedule.ps1 
    on this github site I found the solution. 

    # https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/update-refresh-schedule-in-group

## once in a lifetime you got to do this: 
## Install-Module -Name MicrosoftPowerBIMgmt
## somtimes in a lifetime you got to do this:
## Update-Module -Name MicrosoftPowerBIMgmt
## Depending on your execution policy do not forget to trust the session
## Set-ExecutionPolicy -ExecutionPolicy remotesigned -Scope Process

## login to the platform
Login-PowerBI

##Build the body
 $ApiRequestBody = @"
        {
            "value": {
                "days": [
                    "Sunday",
                    "Monday",
                    "Tuesday",
                    "Wednesday",
                    "Thursday",
                    "Friday",
                    "Saturday"
                ],
                "times": [
                    "08:00",
                    "08:30"
                ],
                "notifyOption": "MailOnFailure", 
                "localTimeZoneId": "UTC", 
                "enabled": true
            }
        }
"@ 

## Invoke the API but do not include the header
Invoke-PowerBIRestMethod -Url 'https://api.powerbi.com/v1.0/myorg/groups/74601087-ad5e-481c-a20c-1965baa8607b/datasets/d469f67e-4568-49eb-b6bc-e42f2c5d37d5/refreshSchedule' -Method Patch -Body ("$ApiRequestBody")

     

    I tried to schedule between full and half hours but then the response is 
    Invoke-PowerBIRestMethod : Encountered errors when invoking the command: {
    "code": "InvalidRequest",
    "message": "Refresh schedule time must be full or half hour (HH:00 or HH:30)" so if you can live with that this is the solution

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi SofBL ,

 

I suggest you to try code as below.

Invoke-PowerBIRestMethod -Url 'groups/groupid.../datasets/datasetid.../refreshSchedule' -Method PATCH -Body ([pscustomobject]@{
  "value"= [ordered]@{
  "days"= @("Sunday")
  "times"= @("08:00","16:00")
  }
} | ConvertTo-Json -Depth 2 -Compress)

For reference: Power BI Cmdlets reference | Microsoft Learn

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

SofBL's avatar
SofBL
Icon for Advocate II rankAdvocate II
1 year ago

Thanks for helping! The biggest error I made is that I included the -headers and that is not necessary  Secondly I used the Invoke-RestMethod, you suggest using Invoke-PowerBIRestMethod 
according to the docs

Invoke-RestMethod likes to have the -body formatted as an <object> and does not need the -headers

Invoke-PowerBIRestMethod wants the -body as an <string> and needs the header