PBIT in report server

[Sudhakar510]

HI Experts,

We have a Power BI Reporting Server and but RAM is having in Server is like 64 GB.

When we move the reports into Prod, it stores the data During Refresh and After Refresh too, So its like doubling the RAM correct?

So what if we can use PBIT (Power BI Template) file? instead of PBIX? Does it supports in Reporting Server? I am thinking this will help not to occupy RAM twice correct? becasue it stores in RAM only as when we refresh but after refresh data sits in specified location so it won't eat RAM after refreshing? is that correct what I said or please let me know If I am wrong.

Thanks in Advance

[Anonymous · Accepted solution]

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) | M...

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.