Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
DLGross
Frequent Visitor

Production Configuration

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?

1 ACCEPTED SOLUTION
Petebro
Employee
Employee

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-se...

 

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

View solution in original post

3 REPLIES 3
Petebro
Employee
Employee

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-se...

 

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

Anonymous
Not applicable

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

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.