topic Production Configuration in Report Server

Production Configuration

DLGross — Wed, 21 Jun 2017 12:00:06 GMT

In a production scenario, should Power BI Report Server be installed on a dedicated computer?

How does the choice of Operating System affect the functionality/maintainability/reliability of the Report Server application?

What is the recommended approach to ensure High Availability of the Report Server?

Re: Production Configuration

Petebro — Wed, 21 Jun 2017 18:15:00 GMT

Power BI Report Server does not require a dedicated computer to operate, but as with any server in production isolation leads to less issues where one failure in an unrelated system brings down the machine hosting several systems.

As for High Availablilty there are two pieces to consider. First the catalog should be created and stored on a SQL Server configured for high availablity. More information for that can be found here https://docs.microsoft.com/en-us/sql/sql-server/failover-clusters/high-availability-solutions-sql-server

Second for the Power BI Report Server itself we recommend a scale out deployment with several Power BI Report Server nodes across several machines behind a network load balancer (NLB). This can be read about here https://technet.microsoft.com/en-us/library/ms159114(v=sql.105).aspx

Re: Production Configuration

desertislesql — Mon, 10 Jul 2017 18:33:03 GMT

While the information provided on how to configure a Power BI Report Server are I am sure technically correct, neither specifically addresses anything specific on Power BI Report Server, as those links are for SSRS report server.

Does Microsoft have any specific guidelines for configuring a Power BI Report Server which are different from anything provided for the SSRS? I realize the server is SSRS plus Power BI, but I was wondering if there are any other Power BI things to consider like perhaps the need for more memory? I am looking for spefic guidance to spec out a server or two so anything anyone could provide would be appreciated.

Regards,

Ginger

Re: Production Configuration

Anonymous — Wed, 21 Feb 2018 15:44:26 GMT

Hi @Petebro,

i wonder if it would als be supported to have a 2-Node Windows Failover Cluster, Node1 runs SQLDB , Node2 runs PBIRS (WFE). Do you think that would work? Can a i add the PBIRS-WFE as a cluster resource? The configuration would be for < 2000 Users and we wouldn't need a NLB and a third/dedicated WFE maschine... WFE-scaleout makes only sense if you need to scale to more users one VM can provide?! Any other options on that?

Regards,

Jochen