Skip to content

Write-RsRestCatalogItem doesn't work with large Power BI reports (>25 MB or > MinLargeFileSizeInMb) #417

Description

@snarf-br

Do you want to request a feature or report a bug?

bug, tested with 28MB Power BI report.

What is the current behavior?

Error message: Failed to create catalog item: Response status code does not indicate success: 500 (Internal Server Error).

If the current behavior is a bug, please provide the steps to reproduce and if possible a minimal demo of the problem.

1: Create Power BI report larger than 25 MB, but smaller than 2GB, name it e.g. LargeReport.pbix
2: In Powershell : Create session to your local Power BI report server
3: Write-RsRestCatalogItem -WebSession $Session -Path "LargeReport.pbix" -RsFolder $Destination -OverWrite -Verbose

What is the expected behavior?
Successfully uploaded Report, similar to the quick and dirty

$Uri= "https://localreportserver/powerbireports/api/v2.0/PowerBIReports(Path='/LargeReport').Model.Upload

$Form= @{ 
    File= Get-Item -Path "LargeReport.pbix"
}
Invoke-WebRequest -Uri $Uri -Method Post -Form $Form -UseDefaultCredentials -Verbose

which uploads the file correctly (barring typo's) using the Uri the library constructs internally if the current user has the correct rights.

Which versions of Powershell and which OS are affected by this issue? Did this work in previous versions of our scripts?

Powershell 7 on Windows,
Power BI Report Server September 2023

This is the first time we had a Power BI report larger than 25 MB to deploy.

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions