Microsoft Power BI

What is Microsoft Power BI?

A suite of business intelligence and analytics with reporting, data preparation, visualization, and analytics tools.

Who Uses Microsoft Power BI?

Power BI is used by developers, analysts, IT, and other businesses to visualize and analyze data on a unified interface.

Where can Microsoft Power BI be deployed?

Cloud, SaaS, Web-based, Windows (Desktop), Android (Mobile)

About the vendor

  • Microsoft
  • Located in Middletown, US
  • Founded in 1975
  • Phone Support
  • 24/7 (Live rep)
  • Chat

Countries available

Australia, Brazil, Canada, China, Germany and 5 others

Languages

Arabic, Chinese, Czech, Danish, Dutch and 21 others

Microsoft Power BI pricing

Starting Price:

US$9.99/month
  • Yes, has free trial
  • No free version

Microsoft Power BI does not have a free version but does offer a free trial. Microsoft Power BI paid version starts at US$9.99/month.

About the vendor

  • Microsoft
  • Located in Middletown, US
  • Founded in 1975
  • Phone Support
  • 24/7 (Live rep)
  • Chat

Countries available

Australia, Brazil, Canada, China, Germany and 5 others

Languages

Arabic, Chinese, Czech, Danish, Dutch and 21 others

Microsoft Power BI videos and images

Microsoft Power BI Software - Microsoft Power BI retail analysis
Microsoft Power BI Software - Microsoft Power BI dashboard sharing
Microsoft Power BI Software - Microsoft Power BI metrics
Microsoft Power BI Software - Microsoft Power BI visual analytics
Microsoft Power BI Software - Microsoft Power BI dashboard
View 6 more
Microsoft Power BI video
Microsoft Power BI Software - Microsoft Power BI retail analysis
Microsoft Power BI Software - Microsoft Power BI dashboard sharing
Microsoft Power BI Software - Microsoft Power BI metrics
Microsoft Power BI Software - Microsoft Power BI visual analytics
Microsoft Power BI Software - Microsoft Power BI dashboard

Compare Microsoft Power BI pricing with similar products

Microsoft Power BI

US$9.99/month
Free Version
Free Trial
N/A
Free Version
Free Trial
US$30.00/month
Free Version
Free Trial
N/A
Free Version
Free Trial

Features of Microsoft Power BI

  • API
  • Activity Dashboard
  • Ad hoc Query
  • Ad hoc Reporting
  • Collaboration Tools
  • Customisable Dashboard
  • Customisable Reports
  • Dashboard
  • Dashboard Creation
  • Data Blending
  • Data Cleansing
  • Data Connectors
  • Data Discovery
  • Data Import/Export
  • Data Management
  • Data Quality Control
  • Data Synchronisation
  • Data Visualisation
  • High Volume Processing
  • Integration into Third Party Applications
  • Interactive Reports
  • Real Time Analytics
  • Reporting & Statistics
  • Reporting/Analytics
  • Self Service Data Preparation
  • Self-service Analytics
  • Visual Analytics

Alternatives to Microsoft Power BI

Enterprise-level analytics platform for marketers, BI staff, and online businesses to gain insights into customer website interactions.
Data analysis solution that helps businesses manage spreadsheets, create graphs/charts, perform calculations, share projects, and more.
SysAid helps IT work smarter, not harder, with service automation based on a decade of AI information. Try IT for free today. Learn more about SysAid
With SAP Crystal Reports 2020, you can create powerful, richly formatted, dynamic reports from virtually any data source. Buy for $495.
Databox is a business analytics platform that pulls all of your data into one place so you can track performance and discover insights.
Grow makes it simple for companies to connect their data and surface insights so everyone can make data-driven decisions.
IBM® Cognos Analytics offers smarter, self-service capabilities so you can quickly and confidently identify and act on insight.
Cloud-based solution that helps businesses manage data collection, create illustrations, track metrics, and monitor KPIs.
Board is the #1 decision-making platform that unifies Planning, Predictive Analytics and Business Intelligence in one solution.
Cloud-based platform that allows businesses to manage WiFi networks and capture visitors' information for marketing processes.
Data transformation for cloud data warehouses. Transform your data into insights and decisions to outpace your competition.
An online reporting and business intelligence service that helps you get new insights from your business data.
Dundas BI is a flexible data analytics platform that was built to be embedded. Everything you need is in one end-to-end platform.

Reviews of Microsoft Power BI

Average score

Overall
4.5
Ease of Use
4.0
Customer Service
4.1
Features
4.4
Value for Money
4.5

Reviews by company size (employees)

  • <50
  • 51-200
  • 201-1,000
  • >1,001
Marlyn G.
Marlyn G.
Marketing Operations Manager in US
Verified LinkedIn User
Computer Software, 1,001-5,000 Employees
Used the Software for: 2+ years
Reviewer Source

A comprehensive data visualization platform

5 2 weeks ago New

Comments: With Microsoft Power BI we can create more profound and useful insights, enhance the publishing efficacy and precision of BI content, and it has a powerful in-stream real-time analytics

Pros:

Microsoft Power BI is one of the most comprehensive data visualization platforms you've ever used. Power BI allows me to collect data from various sources, such as azure and SharePoint databases, it is a platform with enormous potential since it can transform data and give a better perspective, what I like about Power Bi is that it has an easy-to-use user interface without long learning curves, which makes it easy to use for new users, you can see the tables in an orderly way this facilitates data analysis, in Power BI it is safe to use, since it allows only authorized users can access, this is vital since the information that is stored is very sensitive.

Cons:

What I don't like is that the desktop version consumes a lot of RAM and is sometimes slow, a computer with good specifications is required for it to run smoothly.

Ck P.
Software Architect in US
Computer Software, 10,000+ Employees
Used the Software for: 2+ years
Reviewer Source

Alternatives Considered:

Powerful BI tool

5 last month New

Pros:

If you have worked with Office tools, you would grasp the basic functionality very quickly. It's very user-friendly. The power comes from a plethora of data source connectors that it provides out of the box. I am also impressed by its data visualization capabilities. It also integrates well with other Microsoft products. Best of all - it's free for most use cases. The cloud version offers a lot more options for storage and collaboration at a modest price. It's also easy to switch between the desktop and cloud versions.

Cons:

The desktop app can be sluggish at times, especially if you are dealing with large and varied data sets. Also, to utilize its more powerful features, you need to have a greater learning curve than competing products. Cloud integrations are also not very easy to configure and connections to on-prem and SaaS data sources can be challenging.

Verified Reviewer
Head of Application Services (System Administrator & Controlling Function) in Switzerland
Verified LinkedIn User
Management Consulting, 201-500 Employees
Used the Software for: 6-12 months
Reviewer Source
Source: GetApp

A pretty reporting tool for some (!) Microsoft Products, but pretty much useless outside of the Microsoft Landscape

2 5 years ago

Comments: In light of the hype around this "Tableau destroyer" in recent months, I want to highlight some fundamental flaws in data connectivity and reports maintenance of Power BI, which the Product Team so far has turned down as "not in scope". In practice, though, this renders Power BI pretty useless for getting dara from any 3rd party products, in the cloud in particular. This review reflects Power BI as of mid March 2017. I have gathered my knowledge from testing, community interaction and a dozen tickets with Power BI Pro Support. The focus lies on getting data via Web Services, much aligned with Microsoft’s «Cloud First» Strategy. 1) Power BI Online is in the cloud, but does not allow for HTTP calls. Power BI Desktop allows for HTTP calls, but only with static authentication parameters.
First of all, a distinction needs to be made between Power BI Online and Power BI Desktop. While Power BI Online is the "master" that ultimately allows you to share and publish your reports, user experience in design is diminished by HTML limitations (you may know from Word or Excel Online) and more importantly, data connectivity (Get Data) is limited to SQL Servers on Azure and about 20 to 30 plugins from 3rd party solutions at present. Take note that on Power BI Online, you cannot select or manage your Gateways, either.
This brings the attention to the Power BI Desktop client. Updated every one to two months, the Desktop client brings data connectors necessary to connect to a larger number of data sources.
With the Web connector, HTTP calls been configured, although with just static headers and parameters and Basic and Windows authentication only. Importantly, though, Power BI Desktop includes Microsoft Power Query, which you may know from Excel 2016 already. With M Scripts, you can script and customise in many ways and most interestingly, convert it into table form quickly. This is where Power Query shines. However, Power Query does not seem to call on methods for nonces and timestamps required in token based authentication (OAuth for example). (Should this be incorrect, please please let me know. I have been browsing the fora and nagging Support too long already.)
What’s really amusing here is that Microsoft Azure uses OAuth 2.0 themselves. So, you cannot run any reporting on Microsoft’s Azure AD or Resource Manager database for example, a notorious blackbox. Back to Powershell. (Power BI does not accept Powershell feeds.)
In short, while Power BI Online does not allow to get any data out of the web (except for those 20 to 30 plugins, mostly Microsoft Products), Power BI Desktop allows for Web calls, but only with static parameters and thus, basically with your user credentials.
That’s a big limitation in Data Connectivity.
2) With Power BI Online being the master, the HTTP calls cannot be scheduled or refreshed in the cloud. Now that you have configured your HTTP call (with risky user credentials), you want to publish your report and have it refreshed on a scheduled basis, say every day.
Tough luck.
While you can publish your Report to Power BI Online and subsequently a broader audience, it’s a static image of your Desktop data. You cannot schedule a data refresh in Power BI Online (because there is no Web feature anyway) and you cannot even refresh the data manually as this requires republishing the Report anew.
You risk your management looking at outdated data whenever you forgot to republish your report and sneak the new URL into your dashboards and iframes.
3) The On-Premises Data Gateway is pretty useless for Web Services.
Yes, there is the On-Premises Data Gateway. Yes, you can configure Web Services in the gateway, although it’s pretty ironic to route web calls via on-premises infrastructure.
But did you ever try it? That is, you cannot specify any HTTP headers fort he calls at all, lest writing a Power Query script. And thus, we are back at authentication via Basic and Windows only and writing REST scripts in the data source for every single HTTP call because with no Headers and Body, all parameters need to be coded in the URI.
Will you do that?
At the end of the day, Power BI is Microsoft's long overdue acknowledgement that Excel and some Dynamics Reports do not cut it for Reporting purposes. Indeed, for reporting on SQL Server, Dynamics 365 (if you want to afford it), and Excel and Access databases stored in your OneDrive, Microsoft Power BI does a neat job. However, as soon as you want to integrate with 3rd party systems or via web services in particular, Power BI presents so many limitations in authentication, Header and Body configuration, scripting, and scheduling that you need to configure an entire SQL Server environment (on Azure or On-Premises via feature poor Gateway) and write a SQL CRL interface or buy Azure Data Factory to get that data in. For some pretty reports, do you really want to buy and customise all that BI infrastructure on Azure? My advice to Microsoft: Work on Data Connectivity, especially in Power BI Online, rather than more visuals for those limited data sources. Your Microsoft clients will consider Power BI a given for the utter lack of reporting in Office 365, Azure, or Dynamics 365 (yes, pushing it there).
My advice to Users: If the connectors are not listed, look somewhere else. (And make sure it’s your use case that is listed. Power BI announced an Azure AD connector, but rather than reporting on Users, Groups, or Enterprise Apps, you can only see on a nice map where the last logins happened.)
Is it a Tableau destroyer? No. It’s a long overdue acknowledgement for necessary reporting with the potential of being a solid Business Intelligence solution ONCE focus comes to lie more on data.

Pros:

pretty visuals Power Query On-premises Data Gateway responsible Pro Support

Cons:

lack of data sources pretty useless for 3rd Party Web Sources

John R.
John R.
Database Administrator in Costa Rica
Verified LinkedIn User
Information Technology & Services, 51-200 Employees
Used the Software for: 2+ years
Reviewer Source

Alternatives Considered:

Reporting with Power BI

5 3 months ago

Comments: I have been working with this tool for a couple of years now, daily. It is great for the reporting, and we have created amazing reports for Management and the team in general. Very easy to explain metrics, with the reports created.

Pros:

It's free version is very powerful. We can create any report we need, has a lot of data sources and even can create subscription for sending the reports automatically.

Cons:

So far, the only issue I have found is when there are relation on different conditons for the same visual. It can separate and is hard to achive the result.

Rajiv S.
Software Engineer in US
Information Technology & Services, 5,001-10,000 Employees
Used the Software for: 6-12 months
Reviewer Source

Alternatives Considered:

PowerBI review for creating Dashboard

5 last month New

Comments: It provides a good option to create a dashboard and streamline data

Pros:

The ease of managing data flows and creating a dashboard is the top feature.

Cons:

Less availability of demos for new features.