Ways to work with Power BI licenses

2021-09-27 | Toni Pohl

I recently wanted to share a Microsoft Power BI report with other users who only have the "Power BI (Free)" license. Well, with a "Power BI Pro" license, a report can be shared with other users. But I noticed that there are stumbling blocks when it comes to licensing. Here are my findings.

First of all, I'm not a licensing expert (and don't want to be one). However, I would like to ensure that as many users as possible can consume Power BI reports. With this goal in mind, I would like to share my experiences here.

Get and assign a Power BI (free) license

In many M365 tenants, the "Power BI (free)" license is available. Depending on the tenant type, the license can be added (purchased for free) at Microsoft 365 admin center - Purchase services.

image

Then, this license can be assigned to users if needed. Check it out in your tenant at https://portal.office.com/AdminPortal/Home#/licenses.

image

What you can do with a Power BI Free license

The following table shows the comparison of characteristics between the Power BI (free) and the Power BI Pro version.

image

So, with the Power BI (free) license, users can connect to cloud and on-premises data, export to PowerPoint, Excel, CSV, and publish their own reports to the Power BI service and public websites. On the other hand, users with that free license cannot use App workspaces and cannot share reports with other users. Unfortunately, the users with the free license cannot consume shared reports, respectively see the options below.

Which license is for whom

As always, it depends on the usage. In concrete terms this means, a user gets access depending on the type of license and subscription, where content is stored, and of course, the assigned roles and permissions.

See more at the Microsoft documentation pages at Power BI service features by license type and Licenses and subscriptions for business users. The license prices can be found at Power BI pricing.

Ways to work with a Power BI license

Now I wanted to find out how to use reports with a Power BI Free license. Fortunately, I got help from my MVP colleague Markus Ehrenmueller-Jensen from savorydata.com. Markus sent me a list of licensing options, which I am summarizing here. Many thanks for helping me out Markus! So here are the basic licensing rules for working with Power BI:

So, Power BI report consumers have these options to view reports:

  1. Every consumer needs a Pro license to access a shared report (included in the M365 E5 license) - recommended for smaller organizations.
  2. Purchase a Premium Capacity and share reports from there. This is not cheap: for the P-SKU the price is about $4,995 per capacity/month. Note, if your organization is eligible: Premium Capacity for the A SKU´s and EM SKU´s is much cheaper: as far as I see, the capacity for the smallest A SKU starts at $1/hour - recommended for larger organizations.
  3. Publish a report as PDF: The report can be cut off, this creates a more or less a screenshot and the report is no longer interactive - not recommended.
  4. Store the PBIX file in a central location like SharePoint and let the users use a local installed (and cost free) Power BI desktop app to access the report: Note: This is just a workaround and this could create a file version hell - not recommended.
  5. Publish to web from Power BI: Keep in mind that anyone on the Internet can view your published report or visual then - not recommended for organizational data.
  6. Alternative ways without using Power BI to save costs. Integrate visuals in an (web) app, or use other mechanisms to present the data.

Recommendations to view reports from a licensing perspective

My conclusion: The best way to share Power BI reports for small organizations is 1) to assign a Pro license to each user who shall be able to see a shared report.

If an organization has a lot of reports, and many users shall have access to view, my recommendation is 2) to purchase a Premium capacity license (see here). For me, the relevant part follows here: "With Premium capacity, anyone with permissions, whether they're inside or outside your organization, can view content stored in this Premium capacity, without purchasing individual Power BI Pro or Premium per-user licenses.". To make it clear, users with the Free licenses then can view reports that are stored in the Premium capacity. Also, since Power BI will be used more and more for most M365 clients in the future, it makes sense, especially for larger organizations, to save money here instead of licensing each user individually (depending on the other M365 licenses they have).

The options 3), 4) and 5) are just workarounds and not really good methods. It may be a good idea 6) to speak to your software experts to find an alternative way to get raw data or to visualize it in another app or simply in Microsoft Excel if you need to save money through licenses.

Finally, you can find a cool summary for Power BI licensing options in the Microsoft Power BI Community Blog at  Power BI Licensing in Pictures - Updated! I borrowed the graphics for the Premium service (my option 2) here:

4.png

I hope this article helps you through your considerations for using Power BI in your organization.

Categories: App, English, Microsoft, Power Platform, Cloud, Microsoft365, Office365, Power BI

Source: https://blog.atwork.at/post/Power-BI-licensing