Forum Discussion

kitti's avatar
kitti
Icon for Helper III rankHelper III
5 years ago
Solved

Issue with uploading report to Power BI Report Server

Hi experts,   I am using Power BI Report Server (May 2021). I tried to upload a report .pbix file with 450MB size to the server several times but got issues. When it finished uploading, there was n...
Upload
  • Icey's avatar
    Icey
    5 years ago

    Hi kitti ,

     

    To my understanding, 1000 MB limit for MaxFileSizeMb is not really 1000 MB for file size. Because we need other memory to run the queries. Then, more memory is needed. And  Anonymous explained in detail here: Re: PBI Report Server - data size limitation: - Microsoft Power BI Community.

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Icey's avatar
Icey
Icon for Community Support rankCommunity Support
5 years ago

Hi kitti ,

 

Since that "this issue does not occur when I upload a small report file, 10MB for example.", try to increase the "MaxFileSizeMb" limit in the Report Server settings in SQL Server Management Studio (SSMS).

 

Reference: What's new in Power BI Report Server - Power BI | Microsoft Docs

Large file upload/download

You can upload files up to 2 GB in size, though by default this limit is set to 1 GB in the Report Server settings in SQL Server Management Studio (SSMS). These files are stored in the database just as they are for SharePoint, and no special configuration for the SQL Server catalog is required.

 

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.