Forum Discussion

cubs8476's avatar
cubs8476
New Member
3 years ago
Solved

On-Premise data set size limit

Hello We are running into an issue where the scheduled cacshe will not refresh once the data set gets over 1 GB (This data set is unusually large).  Is there a limit of 1GB for on-premise power bi d...
On-premise data
  • d_gosbell's avatar
    d_gosbell
    3 years ago

    1Gb is the default max file size, you can increase this in the Advanced Settings to 2Gb using SQL Server Management Studio.

     

    If you open SQL Server Management Studio, then choose the "Reporting Services" option

    Then connect to https://<servername>/reportserver

    Then right click on the server and go into properties

     

    Then you can change the MaxFileSizeMb setting upto 2000

     

     

d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
3 years ago

1Gb is the default max file size, you can increase this in the Advanced Settings to 2Gb using SQL Server Management Studio.

 

If you open SQL Server Management Studio, then choose the "Reporting Services" option

Then connect to https://<servername>/reportserver

Then right click on the server and go into properties

 

Then you can change the MaxFileSizeMb setting upto 2000