I am copying a complete workspace to another using PowerShell. I've pieced together several scripts I found and filled in where I was missing things. All that is working as I expect. Now, I need to change a few things on the new dataflows.
First - I need to change the data gateway that it uses. I have parameters in my dataflows for the server and database names. Updated those in the script but it also needs the gateway set and I cannot find a way to do that with APIs. Maybe I'm missing that - if so please point me in right direction. Right now, I have my script pause so I can set manually and then proceed. Not ideal, but it serves the purpose.
Next, I would like to add the refresh schedules to my dataflows. I have tried the refeshSchedule (https://docs.microsoft.com/en-us/rest/api/power-bi/dataflows/update-refresh-schedule) but am getting errors.
Here is my script :
$urir = [string]::Format("https://api.powerbi.com/v1.0/myorg/groups/{0}/dataflows/{1}/refreshSchedule", $destinationWorkspace.Id, $dfInfo.objectId);
$ApiRequestBody = @"
{
"value": {
"days": [
"Sunday",
"Monday",
"Tuesday",
"Wednesday",
"Thursday",
"Friday",
"Saturday"
],
"times": [
"12:00"
],
"notifyOption": "NoNotification",
"localTimeZoneId": "035",
"enabled": true
}
}
"@
Write-Host -ForegroundColor White ( [string]::Format("Request Body '{0}'", $ApiRequestBody ) );
Invoke-RestMethod -Uri $urir -Method PATCH -Body $ApiRequestBody;
Here is the output from my script :
Request Body ' {
"value": {
"days": [
"Sunday",
"Monday",
"Tuesday",
"Wednesday",
"Thursday",
"Friday",
"Saturday"
],
"times": [
"12:00"
],
"notifyOption": "NoNotification",
"localTimeZoneId": "035",
"enabled": true
}
}'
Invoke-RestMethod : The remote server returned an error: (415) Unsupported Media Type.
+ Invoke-RestMethod -Uri $urir -Method PATCH -Headers $headers -Body $ApiRequestBody;
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (System.Net.HttpWebRequest:HttpWebRequest) [Invoke-RestMethod], WebExc
eption
+ FullyQualifiedErrorId : WebCmdletWebResponseException,Microsoft.PowerShell.Commands.InvokeRestMethodCommand
I've tried ConvertTo-Json / ConvertFrom-Json - same error message. I know my ids in the variables are correct. I've used same ones to do a single refresh and those work fine.
My gut is it has something to do with the PATCH method but I do not know where to even start on that.
