Is there any maximum size limit and data storage limit when using Power BI Report Server?

Hi panda2004,

The size is limited, but there is no exact answer to the limit, it depends on your set-up, how much RAM have you got, how many PBIX solutions in simultaneous use, other software on the server etc... You will need to experiment with the PBIX solutions you have built and see how they perform under use.

Good questions about multiple users of the PBIX and its implications on memory use, I'm not sure about that, I wonder if anybody else is? We mainly use SSAS Tabular models, which by their nature are single models supporting multiple users, our PBIX file sizes are very small, our SSAS tabular data models very large.

The Power BI server does all of the hard work, the user viewing through a browser only receives the presentation layer back to their browser,  that does include a lot of data if you are displaying a lot of data, but not the whole data model, this is a client / server style implementation.

If your PBIX is 5GB then that's not very big, so is likely to be fine. We have much larger datasets and they work well. You  manage the size by being careful  what you include in the model, and what DAX you use to define additional elements. There are some tools for monitoring this stuff, take a look at the  https://www.sqlbi.com/tools/    site, they are experts on this sort of thing.

Where are you getting the 2GB size limit info from, I'm not aware that is the case. It maybe that the basic Azure cloud based deployment has a limited data size, but not the on-prem version........ I don't think?

Rob