Problem:
I need to import Dataflow json using Powershell
I created a copy of my Dataflow json file with a separate name and able to import using Powershell
It is able to Create the copied Dataflow
But when I run the function on original Dataflow json file it returns with exception: "The remote server returned an error: (404) Not Found."
I'm using the following function:
function ImportDataflow([string]$GroupID, [string]$DataflowName, [string]$DataflowDefinition) {
$UserAccessToken = Get-PowerBIAccessToken
$bearer = $UserAccessToken.Authorization.ToString()
$DataflowListurl = "groups/$GroupID/dataflows"
$flowItems = Invoke-PowerBIRestMethod -Method GET -Url $DataflowListurl | ConvertFrom-Json
$flow = $flowItems.value | Where-Object { $_.name -eq $DataflowName }
if ($flow) {
$CreateOrReplace = "&nameConflict=CreateOrOverwrite"
Write-Host "Overwriting Dataflow: $DataflowName";
} else {
$CreateOrReplace = ""
Write-Host "Creating new Dataflow: $DataflowName";
}
$url = "https://api.powerbi.com/v1.0/myorg/groups/$GroupID/imports?datasetDisplayName=model.json$CreateOrReplace"
$boundary = [System.Guid]::NewGuid().ToString("N")
$LF = [System.Environment]::NewLine
$body = (
"--$boundary",
"Content-Disposition: form-data, name=`"model.json`" filename=`"model.json`"",
"Content-Type: application/json$LF",
$DataflowDefinition,
"--$boundary--$LF"
) -join $LF
$headers = @{
'Authorization' = "$bearer"
'Content-Type' = "multipart/form-data; boundary=--$boundary"
}
Invoke-RestMethod -Uri $url -ContentType 'multipart/form-data' -Method POST -Headers $headers -Body $body
}
FYI - I am clearing Partition entity from $DataflowDefinition before passing it to the function
