cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

Accepted Solutions
Petebro Resolver I
Resolver I

Re: Production Configuration

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 Resolver I
Resolver I

Re: Production Configuration

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

desertislesql Helper III
Helper III

Re: Production Configuration

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

jjuelke Helper II
Helper II

Re: Production Configuration

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

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.