Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

PowerBI - REST API - Export and then Import in Flow / Power Automate

Hi all,   I've been banging my head against a brick wall for a while here.   I've followed a number of the guides for connecting to PowerBI REST APIs using a custom connector in Flow, and general...
Need Help
  • mwegener's avatar
    mwegener
    6 years ago

    Hi Anonymous ,

     

    i found the solution.

    To import a file, request Headers should include Content-Type: multipart/form-data with the file encoded as form data in the request body.

    {
  "$content-type": "multipart/form-data",
  "$multipart": [
    {
      "body": @{body('Export_PBIX')}
    }
  ]
}
cwebb's avatar
cwebb
Advocate V
6 years ago

Does your import step work with a pbix file that you haven't just exported, ie one that you've built yourself in Power BI Desktop?

 

The only other thing I can suggest is to look at this example of how to call the export/import endpoints in PowerShell, which might highlight something that you're doing wrong:

https://github.com/Azure-Samples/powerbi-powershell/blob/master/copyWorkspace.ps1

 

HTH,

 

Chris

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi cwebb 

 

Thanks for looking at this.

 

I have indeed tried manually too, still failing. From looking at the powershell it looks like the bit that I'm missing is the conversion to the multipart form data:

 

$packageFileStream = New-Object System.IO.FileStream @($temp_path, [System.IO.FileMode]::Open)
        
	    $contentDispositionHeaderValue = New-Object System.Net.Http.Headers.ContentDispositionHeaderValue "form-data"
	    $contentDispositionHeaderValue.Name = "file0"
	    $contentDispositionHeaderValue.FileName = $file_name
 
        $streamContent = New-Object System.Net.Http.StreamContent $packageFileStream
        $streamContent.Headers.ContentDisposition = $contentDispositionHeaderValue
        
        $content = New-Object System.Net.Http.MultipartFormDataContent
        $content.Add($streamContent)

 

Any ideas how to do that in Flow?

 

Thanks,

 

Tom.