Forbidden: Importing Large PBIX via Temporary Upload Location in Group

[Anonymous]

Hi all,

could you help me with an issue i am facing with the REST API and uploading a large PBIX report, please?

My organization has premium Premium capacity workspaces.

I try to upload a large PBIX file (~1.3 Gigabytes) via a temporary upload location in group, see

Imports - Create Temporary Upload Location In Group - REST API (Power BI Power BI REST APIs) | Micro...

Step 1 and 2 worked for me, so I was able to get a SAS URL and I was able to upload the file to that temporary location.

Step 3, however, does not work for me, the remote server responds with 403 forbidden.

The following snippet is written in PowerShell:

 $ImportUri = "https://api.powerbi.com/v1.0/myorg/groups/$GroupId/imports?datasetDisplayName=$FileName&nameConflict=CreateOrOverwrite"

  $ImportBody = @{

    fileUrl = $CreatedTemporaryUploadLocation.Url

  }

  $result = Invoke-RestMethod `

    -Method Post `

    -Headers $Headers `

    -ContentType "application/json" `

    -Uri $ImportUri `

    -Body $ImportBody

The headers contain simply a bearer access token.

So I try to send the fileUrl in a Json Request Body. The error message is:

"The remote server returned an error: (403) Forbidden."

Note that importing reports without a temporary upload location is possible.

Any thoughts how to solve that problem?

Thanks

[GilbertQ]

Hi @Anonymous 

Yeah some things have different limits via the API when going via the web... I would see if you can get it small enough to upload and then refresh from the XMLA end point?

[Anonymous]

Hi @GilbertQ 
thanks for your input and thoughts.

We recommended for our users to keep the pbix very small. Problem still exists since the team agreed that is somehow possible to upload such large data. However, I hope that the quality of the offical API documentation imrpoves in future.

[GilbertQ]

Hi @Anonymous 

have you tried to import without the temporary location?

[Anonymous]

Hi @GilbertQ ,

thank you very much for your reply.

I tried to import the large file directly but the server always responds with 400 Bad Request and no error message. The direct import with smaller reports work and the service accepts it.

But if I try to upload the happens with the large report of 1.3 Gigabytes. Problem is that we cannot modify the report to reduce the size right now.

An interesting aspect is that it seems to work with the following Powershell PowerBI  Mgmt cmdlet https://docs.microsoft.com/en-us/powershell/module/microsoftpowerbimgmt.reports/new-powerbireport?vi...

Currently, it cannot be installed in our infrastructure. That's why I tried to use the the HTTP REST API.