Power BI: Licensing Overview

Many times we get the queries if Power BI is a separate license or comes along with Office 365 E1 or Dynamics 365 CE licenses. Hence thought of explaining the same in this blog.

As we discussed in my earlier blog , Power BI can be deployed in models such has on premise, on cloud or hybrid model. With these types of  deployments, we can go with different types of licenses as mentioned below:

  • Power BI Free
  • Power BI Pro
  • Power BI Premium
  • Power BI Report Server
  • Power BI Embedded

Power BI Free: Surprisingly Power BI comes with free licenses with Power BI desktop. This is absolutely free. We can download Power BI desktop for free. Connect with unlimited data sources, no limits on the number of data sources. We can even publish the reports to Power BI service. We can use your organisation account emailID to sign in Power BI service for free and use the same for publishing the reports.

****Only thing which you can not do with Power BI free is sharing the reports securely.****

Sharing of the reports  is only possible by Publishing to the web and which is not secure method. Entire content would be available publicly, others would be able to see the reports, use all functionalities like slicing, drill down etc. Others do not need any Power BI license , but would not be able to edit the reports. This can be done by using embedded code.

Power BI Pro: Power BI Pro comes as 9.00 USD per user license at the time of writing this blog. It has all features what a user can do with in Power BI such as Power BI authoring and sharing. All types of sharing like sharing dashboards, sharing workspaces, sharing reports, Power BI Apps, embed reports in SharePoint etc is available in Pro licensing.

****We just need to keep in mind that to access the shared content using Power BI Pro license, one needs to have the Pro license.****

Pro licensing also provides the integration features as well.

****Embedding  Power BI content in the Custom application, it can not be done in Power BI Pro. ****

Power BI Premium: Power BI premium licensing is considered for large user base for ex equal to or more than 10000. This license type is not based on user, but based on the nodes. These nodes have dedicated capacity and resources and the pricing is based on the nodes which in turn depend on the number of cores. Power BI provides a Power BI calculator to calculate the number of nodes on how much bigger node we require for our needs. This  license provides the facility to publish reports on premise with Power BI report server. It also provides additional features like, huge data storage – 100 TB instead of 10 GB per user, select the deployment model as on premise or cloud, data refresh 48 times per day instead of 8 times per day in Pro etc.

****To access the content shared using Power BI premium license, we do not need the Power BI Pro license****

Power BI Embedded: If we need to embed the Power BI content to custom web application, and need to manage as per user of the custom application, we can go for Power BI embedded license. This license is not based on the users and are actually based on the number of times the content gets rendered. This means that when user interacts with the content such as slices or drills down, the render counter is hit.

Embedded type of licensing is beneficial when users do not need the data continuously and we can predict the usage. The licensing is purely based on number of hits per hour.

****Power BI embedded always have a dependency on web developer for any changes to be done, hence this cost also should be accounted while estimating for Embedded licensing****

Power BI Report Server: SQL Server Enterprise edition and software assurance would give us Power BI report server. If we already have the SQL server Enterprise edition and want to share the reports through on premise report server, we can go with this type of license

Thank you for reading my blog, if you have any questions please mention in the comments and hit the like button if you like my write up.

Keep Learning !! Happy analyzing and be Powerful 🙂

Continue reading “Power BI: Licensing Overview”

Power BI: IPL Analytics- Visualizations and Design Reports -Part 7

In my previous blog, we have seen how to add card visuals and little bit of  QNA feature of Power BI. Let us see how to add custom visual.

If we refer above image of second report, we can see a fish tank /aquarium visual with heading of Top 10 Extra runs by Bowler where fishes are of different sizes. This visual is not available in the default listed visuals in Power BI. However we can search for the visuals available in the market place. There are different ways to search such visuals.

  1. Either search in Google  as office store Power BI visuals as shown in below snippetCUstom visual1CUstom visual3
  2. Go in AppSource and search with the name if you already know. You can search in the top right search box or the main search box as shown in below snippetscustom visual4
  3. From Power BI desktop itself, just click on the extended menu and select “Import from marketplace”

cusom visual5

Select the Power BI certified visuals. Select the Enlighten Aquarium visual and click on Add button. The selected visual would be added in the in visuals list.

CUstom visual6
CUstom visual7

Let us select this new visual and drag and drop on the Report canvas. As mentioned earlier we want the fishes based on the Top 10 Extra runs by Bowler and size of the fish depends on the number of extra runs. Let us see how to configure this.

Drag the Bowler field from Ball by Ball table to Fish property, so that fish represents the bowler. Drag Extra runs field to Fish size, so that fish size represents the sum of extra runs as shown in below snippet.

cusom visual8

However this configuration would show all the bowlers and we want to show only top 10. To achieve this we need use filters. Under Visual level filters, for bowler field, select filter type as Top N.  Mention the number of records, here we enter 10. Filter criteria is Extra runs as shown in below snippet.

There are different filters available in the Power BI such as Visual level filters, Page level filters and Report level filter as shown in below snippet. Those can be used as required.

filters1

We have seen how to add custom visuals in Power BI reports in this blog. Here we have created two Power BI desktop reports. Let us move to Power BI service. In next blog let us see how to develop Power BI dashboards. I hope you are enjoying developing these reports along with me.

Thank you for reading my blog, if you have any questions please mention in the comments and hit the like button if you like my write up.

Keep Learning !! Happy analyzing and be Powerful 🙂

Continue reading “Power BI: IPL Analytics- Visualizations and Design Reports -Part 7”