cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
stpnet Established Member
Established Member

Re: Power BI Report Server Licensing

Sorry but I have an edge case kind of question here.

 

We are using PBI-SSRS through our SQL EE with SA license.

 

Under SSRS we used to role out SSRS Farms (two or three SSRS front ends with a single backend/DB server) this seems like an approach that might be even more relevant when serving up PBIX files with a ton of imported content.

 

How is this addressed in the license docs? I have had a very quick scan and can't seem to see find it (that may well be me being a bit thick)

 

many thanks

 

Steve

 

 

DN Member
Member

Re: Power BI Report Server Licensing

So, either option, I need SQL Server to make PBI Premium work On-Premises. Is this correct?

Or does the Report Server works fine without the SQL Server?

Super User
Super User

Re: Power BI Report Server Licensing

@DN Correct, you need to install SQL Server to support the PBIRS. Documentation

Near SE WI? Join our PUG Milwaukee Brew City PUG
Highlighted
hernan_russy Frequent Visitor
Frequent Visitor

Re: Power BI Report Server Licensing

 Hi @riccardomuti@Seth_C_Bauer: it seems clear to me that a Pro license is required to upload reports to PBI Report Server. However, the platform does not perform any validation and any user can upload contents. Then, how can you prevent users not having a Pro license from uploading reports? I think this licesing policy cannot be applicable if there is no means for the organization to control it. Please can you advise?

 

Thanks

maulikvankawala Frequent Visitor
Frequent Visitor

Re: Power BI Report Server Licensing

Hello @Seth_C_Bauer I read the post you mentioned but didn't get clear answer.

 

My major concern right now is We have total 3 SQL Server Enterprise licenses. 2 of them are through MPN and 1 of them is through SA program. The SQL Server Enterprise + SA product key is being used for different department right now. But they don't use the Power BI report server available with their SA subscription.

 

My question is, as it is within the organization, can we use that Power BI report Server key avilable in SA subscription and install it on a server which has SQL Server Enterprise part of our MPN subscription.

 

Thanks in advance.

Super User
Super User

Re: Power BI Report Server Licensing

@maulikvankawala Unless someone from MSFT knows this, I would recommend you reach out to your local MSFT Rep, or licensing specialist. I don't know the exact answer, and a hypothetical for me could go either way.

Near SE WI? Join our PUG Milwaukee Brew City PUG
Power BI Team riccardomuti
Power BI Team

Re: Power BI Report Server Licensing

You can run Power BI Report Server on a server/VM to which you've allocated SQL Server Enterprise + Software Assurance licenses.

 

Say you have, for example, SQL Server Enterprise + Software Assurance licenses for 24 cores.

  • If all 24 cores are already allocated to some server/VM (to run SQL Server), then you must run Power BI Report Server on that server/VM.
  • If, say, 16 cores are allocated to some server/VM (to run SQL Server), then you could run Power BI Report Server on that server/VM, or, since you have 8 licenses unallocated, you could allocate them to a different, 8-core server/VM and run Power BI Report Server there.

Hope this example helps.

solobud Frequent Visitor
Frequent Visitor

Re: Power BI Report Server Licensing

Does a customer need a minimum number of cores in their SQL EE with SA to use Power BI Report Server? My understanding was that it needed to match PBI P1 capacity as a minimum, is this correct? if so, is it the 8 v-cores (P1 front end) that need to be matched, 4 cores (P1 back end), or something else?

Power BI Team riccardomuti
Power BI Team

Re: Power BI Report Server Licensing

Per the Product Terms, there's no minimum # of cores overall or per server, but there's an effective minimum of 4 cores per physical processor or per VM. That said, for a production environment, we usually recommend at least 8 cores.

dude15000 Frequent Visitor
Frequent Visitor

Re: Power BI Report Server Licensing

This pricing is insane.  Without SA, we're looking at a minimum of $5k per month just to get licensing for an updated variation of SSRS?  Yeah, I'll pass.