Scripting a refresh schedule

[daive]

Hi all,

I am busy writing a process to import workspaces & reports into a new tenant. I am now on the refresh schedule and wanting to script it as all reports have different schedules.

I am following this article: https://martinschoombee.com/2020/10/27/automating-power-bi-deployments-update-refresh-schedule/

For now I am testing with one workspace and report but will eventually incorporate a csv and a loop

This is the actual script:

#API url for the refresh schedule
$ApiUrl = "groups/" + $WorkspaceObject.Id + "/datasets/" + $PbiReportObject.DatasetId + "/refreshSchedule" 

$ApiRequestBody = @"
    {
        "value": {
            "days": [
                "Sunday",
                "Monday",
                "Tuesday",
                "Wednesday",
                "Thursday",
                "Friday",
                "Saturday"
            ],
            "times": [
                "$RefreshTime"
            ],
            "notifyOption": "MailOnFailure", 
            "localTimeZoneId": "$Timezone", 
            "enabled": true
        }
    }
"@ 


#Update refresh schedule
Invoke-PowerBIRestMethod -Url $ApiUrl -Method Patch -Body ("$ApiRequestBody")

Write-Output "Data refresh schedule for report ""$ReportName"" updated successfully..."

Now i am geting this error

VERBOSE: Request Uri:
https://api.powerbi.com/v1.0/myorg/groups/796cceb9-aaa9-441e-900e-223b3z2e5719/datasets/86b9b214-c0f5-4682-9256-4462dba
4e370/refreshSchedule
VERBOSE: Status Code: Forbidden (403)
Invoke-PowerBIRestMethod : Encountered errors when invoking the command: {
  "code": "InvalidRequest",
  "message": "This operation is only supported for the dataset owner"

My user account and the service principle are both admins for the workspace. I have read that I may need to set the service principle as the dataset owner - is that necessary and what will be the consequence of doing that?

Thanks,
David

[lbendlin · Accepted solution]

Yes, it is necessary, and yes, a semantic model "take over"  will result in ALL credentials being nuked and having to be re-provided.

[daive]

Thanks @lbendlin ,

Credentials will need to be entered in any case as i am importing workspaces & reports into a new tenant.