topic Re: Power BI Report Server capacity planing in Report Server

Power BI Report Server capacity planing

pdeville — Thu, 09 Nov 2017 14:47:14 GMT

I have been reading https://powerbi.microsoft.com/en-us/documentation/reportserver-capacity-planning/

I was wondering why the "Report Server Database" server was sized so large ? It's larger than the PIB RS server in the small configuration.

Would it be possible to see the load test resutls for the "Report Server Database" server and the SSAS server in addition to the PBI RS Server?

I was considering putting the RS database on the same server as SSAS but I am wondering if it is realy a good idea.

Re: Power BI Report Server capacity planing

v-yulgu-msft — Wed, 15 Nov 2017 05:56:18 GMT

Hi pdeville,

Per my knowledge, the Report Server Database server needs to store many metadata and object definitions, so it needs enough space. But I am not sure about this.

For whether it is possible to see the load test resutls for the "Report Server Database" server and the SSAS server, I have emailed to PG to consult with them. Once I get any response, I will update here.

Regards,
Yuliana Gu

Re: Power BI Report Server capacity planing

v-yulgu-msft — Thu, 16 Nov 2017 09:57:48 GMT

Hi pdeville,

From PG's response, they haven’t started the work for capacity planning yet. This is on their board. Currently, it might not possible to see the load test resutls for the "Report Server Database" server and the SSAS server.

Regards,

Yuliana Gu

Re: Power BI Report Server capacity planing

pdeville — Mon, 20 Nov 2017 10:33:32 GMT

Thanks for your answers.

The performance of Power BI and the end user exprience certainely depends on the performances of SSAS and the reports server database.

So having the test results for others servers in the farm would be very instresting.

Best regards.

Re: Power BI Report Server capacity planing

hugoberry — Tue, 21 Nov 2017 17:36:06 GMT

Are you aware that the latest release of Power BI Report Servere comes with an embedded SSAS instance, simillar to the Power BI desktop architecture? Maybe that's why needs a greater capacity. It can become a bottleneck if the refresh of non direct-query reports are taking all of the memory resources with this embedded instance of SSAS.