SQL Server EE + SA - Power BI reporting server

[sajidmansoorali]

Power BI reporting server is free with SQL Server EE +SA. I would like to know if i need 20 PRO User, 100 Occasional Users and 400 Frequent User. will i be able to create these user. I don't want to subscribed power bi premium due to its monthly cost.

[jcollinson2001 · Accepted solution]

Just to confirm as well, in the purely on-premise solution you definately won't need a pro license for every user. Only those which intend to author/publish reports.

[jcollinson2001]

The amount of pro-license you need will be dictated by how many users you want to be able to publish reports to the Report Server (which requires a pro license).

Once you have installed your on-premise Report Server, you will be able to allow access to as many users as you wish, but those users will need a PBI Pro license if they intend to author and publish reports.

[v-qiuyu-msft]

Hi @sajidmansoorali,

Not sure what PRO, Occasional, Frequent you mean? If you want to grant these users permission to access Power BI report server, it's possible, see: https://docs.microsoft.com/en-us/sql/reporting-services/security/grant-user-access-to-a-report-serve...

Best Regards,
Qiuyun Yu 

[sajidmansoorali]

thanks for reply,

https://powerbi.microsoft.com/en-us/calculator/

if you go the above link, you will see PRO, Occasional, Frequent Users. 

can you confirm that same pricing / licensing is available in "SQL Server EE + SA - Power BI reporting server" or i will have to purchase PRO license for every individual even if he is not a developer.

[jcollinson2001 · Accepted solution]

Just to confirm as well, in the purely on-premise solution you definately won't need a pro license for every user. Only those which intend to author/publish reports.

[sajidmansoorali]

Thanks, this is the answer i exactly want to know. 

can you please provide any documentation. 

What are the limitations regarding #s of user i can create without PRO licenens.

[jcollinson2001 · Accepted solution]

Glad it's helped.

With regard to number of users, the limitations will be your hardware. There are no limitations in the context of your AD domain (you could allow every user on your domain access to the Report Server if you wish).

Here's an extract from the licensing terms which I think partly confirms your situation:

4.6 Use of Power BI Report Server – SQL Server Enterprise Edition

Customer may run Power BI Report Server software on the Licensed Server. Customer may run the software on a maximum numbers of cores equal to the number of SQL Server Enterprise Edition Core Licenses with active SA assigned to that Server, subject to a minimum of four cores per OSE. Use is additionally subject to the applicable terms of Customer’s volume license agreement. A Power BI Pro User SL is required to publish shared Power BI reports using the Power BI Report Server. This right expires upon expiration of Customer’s SA coverage. 

[sajidmansoorali]

Great! 

THANKS A LOT.

just share official link of above documentation # 4.6.

[jcollinson2001]

No probs.

The term was taken from the Volume Licensing Product Terms (official Microsoft document). You can download a copy here:

https://www.microsoft.com/en-us/licensing/product-licensing/products.aspx

Download the doc and search for section 4.6.

Thanks

[jcollinson2001]

I think the calculator you've posted a link for is for "Power BI Premium" tier licensing only - Report Server licensed through SQL EE + SA is different to this.

My understanding is PBI Premium gives you both access to the cloud service, and the ability to install on on-premise Report Server. I believe the question about occasional/frequent users is asked so Microsoft can give you advice on how many nodes you'll need in the cloud (which for on-premise is up to you to figure out as it's your internal hardware).

FYI if you do need to do capacity planning for a purely on-premise solution, check this guide: https://docs.microsoft.com/en-us/power-bi/report-server/capacity-planning.

Hope this helps.