PBIT in report server

Hi Sudhakar510 ,

Using PBIT is not a very good choice. In fact it actually has nothing to do with the type of file you have.

Behind PBIRS there is a tabular SSAS instance that hosts Power BI models: When a user views a report, the PBIX file is uncompressed into memory and a copy of the "imported" data model is dragged into a "hidden" SSAS instance. In addition, the SSAS instance also needs memory to run and at least double of the size of the model to process it. Indeed during the treatment a copy of the model is created next to allow the existing model to remain available. Not to mention the memory also necessary to meet the needs of queries running on this data. And the more users that query a PBIX (model), the more RAM space you need for these queries.

You must therefore ensure that your PBIRS server has enough RAM to meet these different needs.

For more you may refer to：

Memory Issues and Management in Power BI Report Server (PBIRS) - Business wIntelligence

Size of models in Power BI Report Server (linkedin.com)

Although Reporting Services can use all available memory, you can override default behavior by configuring an upper limit on the total amount of memory resources that are allocated to Reporting Services server applications. You can also set thresholds that cause the report server to change how it prioritizes and processes requests depending on whether it is under low, medium, or heavy memory pressure.

You could also refer this ：Configure Available Memory for Report Server Applications - SQL Server Reporting Services (SSRS) | Microsoft Learn

Best Regards,
Community Support Team _ Caitlyn

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