March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
We are working on a website with a subscription-based plan to display analytical reports to our subscribers only.
I wanted to understand the best Power BI subscription path for this.
On one hand, I was advised to purchase a PPU license with embedded capacity where I can create and deploy my reports. PPU license is because datasets are bulky in size ( +10GB ) and then embed these reports in our website. every website subscriber would need a PPU subscription additionally to access those reports.
What I understand about, why our every website-subscriber need PPU, is because, per my understanding, only PPU or premium capacity users can access PPU workspace and not the Pro user.
On the other hand, I am thinking to purchase a Power BI Pro license with the embedded capacity to store large datasets and then embed reports (developed using a prod license in the workspace) on our website. All our website subscribers should be able to access reports through our website.
Please also advise:
- What is the role of Power BI Embedded here, I am not very clear.
- When we publish the PBI report on the web then It means it is available for everyone to access. In this case, do we really need a PPU license for all our website-susbcribers to view those reports that we have deployed on PPU workspace and embedded on our website?
Your valuable Inputs would really help in a great manner, so please advise.
Solved! Go to Solution.
[Edited]
Hi @amitesh_data ,
For the user access situation that you are describing, it seems like embedded is the way to go. You will also need a Pro license to publish the report, but users will not need a license to view the report.
However, 10GB datasets will not work well with embedded. Any chance you can use Direct Query mode?
Here is some additional information on user access with embedded.
https://learn.microsoft.com/en-us/power-bi/developer/embedded/embedded-analytics-power-bi
Here is additional information on performance and max dataset sizes for embedded and premium:
Please consideraccepting as solution if this has answered your question.
Hi @amitesh_data - the answer to your question is "it depends". Please use the following advice to discuss with Microsoft Sales Rep.
Power BI Embedded is a feature that allows you to insert a Power BI report within your application/website within an iFrame or with a SharePoint site. Essentially, the user can access the report without visiting "app.powerbi.com".
When you publish to web, you need to either "Licence the app" and "Licence the user or Capacity". This is descibed in the "Sharing capabilities" in the following blog post. Understanding the Power BI Capacity Based SKUs – The White Pages (tygraph.com)
If you "License the App", you are buying premium capacity through an A SKU. This SKU is pay by the hour. So if you are running the app 24/7 365 days the costs will rack up. But there is an advantage if your users only need access for 8 hours for 5 days a week. You can pause and start the service so it only on when required.
If you "Licence the Users or Capacity", there are two options. Premium Per User (PPU) and Premium Per Capacity (PPC). If you use this approach please note that you cannot use the "EM" SKU (FYI @djurecicK2). The EM SKU are designed for sharing within your organisation when everyone has Power BI Pro licence. So, to share with your subscription users, they will need (1) a Microsoft Guest account and (2) a Power BI Pro licence. I am not sure if you going to be using Microsoft account for your subscription service.
Okay you need Premium Capacity, so it is PPU or PPC. This is where you need to get the calculator out. Large organisation will opt for PPC. The reason is that annual cost of the incurred once for all users, and there is the option to switch report consumers from Power BI Pro to Power BI Free licences. If you are in a smaller organisation, say between 1 - 250 ish employees, there is an arguement to buy PPU for everyone. Why? The annual cost for 250 users is much less than annual cost of P1, and you actually get access P3 resources.
The caveat to the above is that paying for EM3 and Power BI Pro licences could be more cost effective.
So it depends on
I hope this helps.
[Edited]
Hi @amitesh_data ,
For the user access situation that you are describing, it seems like embedded is the way to go. You will also need a Pro license to publish the report, but users will not need a license to view the report.
However, 10GB datasets will not work well with embedded. Any chance you can use Direct Query mode?
Here is some additional information on user access with embedded.
https://learn.microsoft.com/en-us/power-bi/developer/embedded/embedded-analytics-power-bi
Here is additional information on performance and max dataset sizes for embedded and premium:
Please consideraccepting as solution if this has answered your question.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
36 | |
28 | |
19 | |
10 | |
8 |
User | Count |
---|---|
54 | |
42 | |
28 | |
11 | |
11 |