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')}
    }
  ]
}
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Any ideas at all? Spent some more time looking at this and still getting nowhere!

 

Thanks,

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks v-xuding-msft 

     

    These are indeed very helpful, and I've spent a lot of time looking at these to get me as far as I have, but do not help with my specific issue. 

     

    Pretty much the only thing I think I am missing, is what do I need to do with the output of the export step, before injecting it into the import step. It's probably as simple as a compose with some text to define something, but I just cannot figure it out.

     

    Thanks,

     

    Tom.

    • 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.