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.

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

    Hi Icey 

     

    Thank you for your reply. Unfortunately, I do not see the option on my server. I am using SQL Server 2019.

     

     

    Regards,

    KL

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

      Hi kitti ,

       

      Do you connect to "Reporting Services"?

       

       

       

      Best Regards,

      Icey

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

        Hi Icey 

         

        Thank you. I am able to see it now. I just doubt that the .pbix file size it's the problem. The .pbix file size is 450MB which is quite far from the max size (1000MB). Can you please help me better undetstand? 

         

         

        Regards,

        KL