close

Power BI Embedded features and pricing guide

Posted by Errin O'Connor on Aug, 21, 2020 02:08

Microsoft Power BI is a self-service cloud-based advanced data analytics & visualization service that enables all technical and non-technical users with an organization the power to aggregate, analyze, visualize and share data with their respective stakeholders or clients. Let’s understand Power BI embedded pricing and how it works for business.

Apart from all the features available in the competitor data visualization tools like Tableau or QlikView, you can also use the power of data analytics by customizing/embed/integrate the Power BI dashboards and reports in any business applications.

Microsoft Power BI is the market leader and most used data analytics tools of 2020. The opportunities and possibilities with Power BI are endless, and companies nowadays are leveraging Power BI to increase revenue directly.

The first thing you must understand after planning to buy a Power BI license is the features and the different Power BI embedded pricing offered. We have covered everything about all the available options and the elements. By the time you end up reading this article, you will be equipped with all the knowledge to make an informed decision for your company.

Talking about all the Power BI licensing options

There are many licensing options in Power BI starting from the basic free plan. Microsoft has thoughtfully created many Power BI divisions according to the needs ranging from small businesses, startups to large corporations. 

These are the licensing plans offered by Power BI – 

  • Power BI Free
  • Power BI Pro
  • Power BI Embedded
  • Power BI Premium
  • Power BI Report Server Only licensing
Licensing Plans in BI

Power BI Free

The first thing that new users check is the free version. Like other Microsoft products, Power BI embedded pricing free’s version includes most of the features that small businesses need. You can do a lot with the available features and create reports with business insights to make decisions.

Let’s discover and discuss the primary functions.

Creating a report in Power BI Desktop

Power BI Desktop is free to use for everyone and does not require any license. You can quickly start by importing all types of data and preparing reports. There is no limit in the size of data that you can import, and there are hundreds of options to customize your reports. 

Power BI reports

All the features with which you can convert your data into visualization are available in the free version.

Some of the exciting and useful features are –

  • Customizable dashboards
  • Datasets
  • Reports
  • Ad Hoc Reporting
  • Complete Reporting & Data Visualization Tools
  • Trend Indicators
  • Ad Hoc Analysis
  • Online Analytical Processing (OLAP)
  • Interactive Reports Authoring

Publishing and using the reports to analyze in the web version of Power BI is also offered in the free version. After analyzing your reports and getting insights, you can simply click on publish, and the reports will be saved in the Microsoft server.

Difference between sharing and publishing Power BI Reports

Publishing a Power BI report to the web is sharing it publicly on the website. Anyone in the world can view your reports, which is not a secure option. Sharing reports securely with team members and brainstorming on ideas is vital for your company.

Every sharing option in Power BI is paid, and we will discuss everything about it in the other versions. 

Power BI Pro

Power BI Pro consists of several extra features on top of all the features that you get in the free version of Power BI. Along with these features, you also get the options to share your reports and insights with team members. 

The best part of the pro plan, like other Microsoft solutions, is the per-user subscription model. You don’t have to pay a standard fee which becomes unfair for companies with a lesser number of employees. 

Currently, Power BI Pro costs $9.99 per user per month. You can quickly pay for a small team according to the number of people. Let’s discuss what is included in the Pro version.

Understanding the sharing guide

Sharing is the most used and essential feature for everyone buying the license for the Pro plan. All the options for sharing that you get along with the license are – 

  • Simple sharing
  • Sharing in workspaces
  • Sharing via Power BI apps
  • Embedding in SharePoint Online

An important point to note is that only the paid subscribers are allowed to view the content you share. If you are sharing the reports with a free account, that particular account will not be able to see the reports.

  • The only restricted option of sharing in the pro plan is the Power BI embedded sharing which has a different plan whole together discussed in this article

Another important and exciting feature in the pro plan is the analysis in excel. The pro plan offers many integrations with software, and excel is one of them. You can integrate your reports and combine excel data with visualization to improve analysis.

Power BI For Custom application

Analytics in embedded
Embedding analytics into application

Many businesses have custom applications which they use to manage their business. In case you are looking to integrate Power BI with your custom or any other software, you will need a Power BI embedded pricing and license. 

Unlike the pro plan, the costing for the embedding plan is not based on the per-user model but rather is based on page renders. 

Let’s understand page renders

However, before you plan on selecting the embedding license, you need to understand the concept of renders. Renders are basically defined as every refresh on the page, which is integrated with Microsoft Power BI. A few examples for you to understand this is – 

  • If you click on a column in a chart to highlight data respective to it, it is considered as a page render in your plan
  • If you select a slicer to divide data, it is also a render
  • Making any changes to the screen or the visualization is considered a render

Power BI embedded pricing chart

This is the pricing chart for Power BI embedded services in accordance with the central US region and the United States dollar. We have taken the details from Microsoft’s website.

Node TypeDedicated InfrastructureVirtual CoresMemoryFrontend / Backend CoresPrice
A1No13 GB RAM0.5/0.5$1.0081/hour
A2No25 GB RAM1/1$2.0081/hour
A3Yes410 GB RAM2/2$4.0242/hour
A4Yes825 GB RAM4/4$8.0565/hour
A5Yes1650 GB RAM8/8$16.121/hour
A6Yes32100 GB RAM16/16$32.2506/hour
Power BI Embedded Analytics Consulting

Now, this might seem complicated and expensive on the first look. However, we would like to enlighten you that this license is beneficial in many cases. It depends on case to case and would be the best choice for some businesses. You will be able to understand with an example. 

Let’s suppose you have 230 employees in your company who have to access different features of Power BI. If you buy the pro plan of Power BI, total costing per month will be $2300. It is evident that all of your employees will not be using Power BI equally, and usage will also depend from time to time.

Moreover, If the maximum usage of your organization is 600 page renders per hour, which is a common scenario with most companies, your total billing for the month will be around $1400. 

If you calculate the yearly savings, in this case, they will be more than $10,000. Therefore, Power BI embedded pricing is a favorable choice for large corporations. 

Pro tip – Businesses are often unaware of the costs that they have to spend to integrate Power BI in your customized software. Microsoft provides you with the software but does not incorporate it into your organization. You will have to pay a software developer or hire an agency to do the job for you. But overall, it is a cost-effective option in particular cases. 

If you are looking for Microsoft Power BI experts who can help you integrate the software and train you with the best features to leverage the software in your company, Contact Us NOW!

We have been helping numerous companies ranging from startups to large corporations in integrating Power BI to their business operations, which has directly resulted in increased revenue and business. 

Power BI Premium

Next in line of the licenses is the Power BI premium. This license is specially designed for large corporations with multiple thousand employees. A fair estimate would be 10,000 users. 

The calculation of cost in the premium model is done per nodes. Let’s understand the system of nodes and how prices are calculated in this model. Following is the chart we have created by getting the information from Microsoft’s website.

Capacity Nodes Total v-cores Backend v-cores RAM (GB) Frontend v-cores DirectQuery/Live Connection (per sec) Model Refresh Parallelism 
EM1/A1 10.530.53.751
EM2/A2 21517.52
EM3/A3 42102153
P1/A4 84254306
P2/A5 1685086012
P3/A6 32161001612024
P4/A7 1 64322003224048
P5/A8 1 128644006448096

Understanding and calculating your costing based on these models is quite complex, so Microsoft provides a premium calculator. You can use it to calculate the exact numbers, but to get an idea, we did the calculations based on average figures for 10,000 employees in a company.

Power BI Premium Calculator
Power BI Premium Calculator

The price that we calculated was $33,000 compared to $100,000, which would be paid in the case of Pro. 

Premium also comes with several additional features including – 

  • Dedicated Power BI Resources
  • Extra storage, i.e., 100TB
  • Report server
  • Geographical distribution
  • More dataset refreshes
  • And many other benefits

Power BI report server

If you are looking for an on-premise sharing of reports and data, you can opt for the Power BI report server license. This license is used for companies with specific requirements, and the pricing is also custom and depends on a variety of factors.

If you are looking to adopt Microsoft Power BI in your company and are unaware of the best way to do it, Contact Us. We are certified Microsoft partners and have helped numerous companies align their business processes using Microsoft Power BI!