Hey guys!
In this article, I will share with you more information about Premium Capacity Licensing (SKU EM) of Power BI, which costs from R$4,070.65 on the Microsoft website and which allows you to insert reports into internal applications.
In this article, we will discover the characteristics of this type of licensing, when it is interesting and when it is not.
Summary of all Power BI license types:
| Free | PRO | PPU | Report Server | Premium by Capacity (SKU P) | Premium by Capacity (EM) | Embedded | Microsoft Fabric | |
|---|---|---|---|---|---|---|---|---|
| License Type | By User | By User | By User | Location | By Capacity | By Capacity | By Capacity | By Capacity |
| Value | R$ 0.00 | R$54.90 per user/month | R$ 109.80 per user/month | Included with Power BI Premium or SQL Server Enterprise + SA | From R$31,960.00 per month | From R$4,070.65 per month | From R$5.63 per hour on | From R$1.06 per hour on |
| Can share reports | No | Only with PRO accounts | Only with PPU or PRO accounts* | Yes, with any user on the local network | Yes, even with Free account users. | Yes, with any user on the local network | Yes, with any user. You don't even need to have a Power BI account. | Yes, with any user. You don't even need to have a Power BI account. |
| Pro account required to view reports | No (Does not allow sharing) | Yes | Yes | No | No | No | No | No |
| Form of hiring | Office 365 | Office 365 | Office 365 | Office 365 | Office 365 | Office 365 | Azure Portal | Azure Portal |
| How to access reports | powerbi.com | powerbi.com | powerbi.com | Local server | powerbi.com | Web portal created by the company | Web portal created by the company | Web portal created by the company |
| Maximum data model size | 1GB | 1GB | 100GB | Unlimited | 400GB (P5) | 10GB (EM3) | 400GB (A8) | 400GB (F1024+) |
| Daily updates | 1 | 8 | 48 | 1.440 | 48 | 48 | 48 | 48 |
| Allows you to embed reports | No | Yes (limited quantity for testing only) | Yes (limited quantity for testing only) | Yes (intranet and sharepoint only) | Yes | Yes (intranet and sharepoint only) | Yes | Yes |
Power BI Premium by Capacity (EM SKU)
Summary
The Premium Capacity License (EM SKU) is aimed at large companies, with a large number of users, and with the need to insert reports into internal corporate applications, such as Intranet and Sharepoint, where users do not need to pay a license fee to view the reports.
In this type of licensing, users can even use a Free account to view the reports, but viewing users do not access the Power BI portal (powerbi.com) but rather a web portal that the company will need to hire or develop internally. This is how users without a PRO license can view reports without needing a license.
The process of creating and publishing reports continues exactly the same way: User who is going to publish reports needs a PRO account, develops the report in Power BI Desktop, publishes it in a workspace, configures updates, gateways and access credentials. The permission and RLS part will be different, as viewer users no longer exist in Power BI, permissions and RLS control is implemented in the application code and no longer in the Power BI service.
The form of contracting for this license is through Office 365. The EM1 and EM2 SKUs are only available through volume licensing plans. It is not possible to purchase them directly.
Capacity table
| Power BI SKU | Power BI virtual cores | Maximum model size | Fabric Equivalent SKU | Equivalent Embedded SKU | Price (Excluding Taxes) | Price (With Taxes) |
|---|---|---|---|---|---|---|
| EM1 | 1 | 3GB | F8 | A1 | BRL 4,070.65 | BRL 4,789.23 |
| EM2 | 2 | 5GB | F16 | A2 | R$ 8,131.30 | R$ 9,578.45 |
| EM3 | 4 | 10GB | F32 | A3 | R$ 16,283.60 | R$ 19,156.90 |
Features and Limitations
What you can do with this license:
- Download Power BI Desktop (always free, even without an account)
- Create reports, connecting to any data source
- Publish reports to your personal workspace and shared workspaces
- Share reports with users without needing a Pro account
- Use data streaming
- Configure personal and enterprise data gateway to update local data up to 48x per day (for each dataset)
- Use tokens and API to embed unlimited reports in internal corporate applications and Sharepoint
- Use the feature Publish to the web (CAUTION: Use ONLY with PUBLIC data. NEVER, EVER use this feature with private data)
- Subscription to report by email (Anyone receiving it needs a PRO or PPU account)
- Use the generate secure link feature to Insert report on Website or Portal
- Use Dataflows
- Access or create applications
- Use paginated reports
- Use incremental update
- Use datasets sizes up to 10 GB
- Have workspaces with sizes up to 100 TB
- Update datasets up to 48 times per day
- Use Incremental update of Dataflows
- Use hybrid tables (Import + DirectQuery)
- Use Datamarts
- Use XLMA Endpoint
- Use deployment pipelines (DevOps)
- Use integration with GIT
What you CANNOT do with this license:
- Users who will view the data DO NOT access the Power BI reporting portal. You will have to create or hire a portal to access the reports.
- Share reports with users with a free Power BI license
- Share reports that use Premium features with Power BI PRO licensed users
- Subscription to report by email WITHOUT PRO or PPU account (Whoever is going to receive it needs a PRO or PPU account)
So that's it, folks!
I hope you enjoyed this post and follow the series where I will explore all types of Power BI licensing!
Comentários (0)
Carregando comentários…