cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mcrowe
Regular Visitor

Using Both Power Bi Report Server and Power Bi Services

Our Organization is already using Power Bi Services. There are certain groups within the organization that need to utilize the Power Bi Services and others that would need to utilize Power Bi Report Server. In my example lets say you have a business analysis(1) who publishes reports using the Power Bi Services that the end user utilizes PowerBi.com to view the final report. Business analysis (2) publishes reports in a different department in Power Bi Report Server which its end user would view the reports in Power Bi Report Server URL setup. Is this possible and would it effect performance? I would love to hear from people that may have this situation going on at their company. 

1 ACCEPTED SOLUTION
lbendlin
Super User III
Super User III

Assuming you have a Premium capacity - that includes Power BI Report Server too.  You can set that up in parallel to the Power BI Service Premium SKU, and run both as needed.

 

There are many (many) things to be aware of

 

- Power BI Report Server does not have feature parity with Power BI Service.  Some of the Power Query and DAX commands will not work

- You need a really powerful machine to host Power BI Report Server.  It also requires a SQL Server license but you likely already have that.

- You need a special Power BI Desktop client ("RS" version) to author content for Power BI Report Server which - you guessed it- does not have feature parity with the regular Power BI Desktop.

 

etc etc

View solution in original post

2 REPLIES 2
AbhiSSRS
Impactful Individual
Impactful Individual

There is in general no difficulty in this set up unless you have features that work exclusivley in the Service only.

Now with respect to the performance it may entirely depend on the way your reports are :

 

If the datasource is on-premise for both the service and server ( server would in fact work faster and may be a upto 10X if your source resides on the same server as ReportServer)

If the connection is Live/Direct Query and on-prem source even then the on-prem is faster

If its import mode then performance is similar, RS may be slower in some cases depending on your server capacity

If you are working connected Live to Power Bi dataset ( as single source) then there is a major impact (upto 5-6X slower and recommendation would be to work with seperate source altogether for the onpremise reports.

 

lbendlin
Super User III
Super User III

Assuming you have a Premium capacity - that includes Power BI Report Server too.  You can set that up in parallel to the Power BI Service Premium SKU, and run both as needed.

 

There are many (many) things to be aware of

 

- Power BI Report Server does not have feature parity with Power BI Service.  Some of the Power Query and DAX commands will not work

- You need a really powerful machine to host Power BI Report Server.  It also requires a SQL Server license but you likely already have that.

- You need a special Power BI Desktop client ("RS" version) to author content for Power BI Report Server which - you guessed it- does not have feature parity with the regular Power BI Desktop.

 

etc etc

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.