Microsoft Power BI

Who Uses Microsoft Power BI?

Power BI is used by developers, analysts, IT, and other business users.

What Is Microsoft Power BI?

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

Microsoft Power BI Details

Microsoft

http://www.microsoft.com

Founded 1975

Compare Microsoft Power BI with similar products

Starting price

US$9.99/month
US$15.00/month
N/A
N/A

Free Version

Free Version Yes
Free Version Yes
Free Version No
Free Version Yes

Free Trial

Free Trial Yes
Free Trial Yes
Free Trial Yes
Free Trial Yes

Microsoft Power BI deployment and support

Support

  • Email/Help Desk
  • FAQs/Forum
  • Knowledge Base Software
  • Chat

Deployment

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

Training Software

  • Webinars
  • Documentation
  • Videos

Microsoft Power BI Features

  • API
  • Access Controls/Permissions
  • Activity Dashboard
  • Activity Tracking
  • Ad hoc Analysis
  • Ad hoc Query
  • Ad hoc Reporting
  • Alerts / Escalation
  • Alerts/Notifications
  • Benchmarking
  • Charting
  • Collaboration Tools
  • Customizable Branding
  • Customizable Reports
  • Customizable Templates
  • Dashboard Creation
  • Dashboard Software
  • Data Connectors
  • Data Extraction Software
  • Data Import/Export
  • Data Mapping
  • Data Synchronization
  • Data Transformation
  • Data Visualization Software
  • Drag & Drop
  • Forecasting
  • Key Performance Indicators
  • Metadata Management
  • Monitoring
  • Multiple Data Sources
  • Performance Management
  • Performance Metrics
  • Predictive Analytics Software
  • Profitability Analysis
  • Publishing / Sharing
  • Real Time Analytics
  • Real Time Data
  • Real Time Monitoring
  • Real Time Reporting
  • Reporting & Statistics
  • Reporting/Analytics
  • Sales Trend Analysis
  • Scorecards
  • Search/Filter
  • Self Service Data Preparation
  • Strategic Planning Software
  • Third Party Integrations
  • Trend / Problem Indicators
  • Trend Analysis
  • Visual Analytics

View full list of Business Intelligence Software

  • API
  • Access Controls/Permissions
  • Activity Dashboard
  • Ad hoc Analysis
  • Ad hoc Query
  • Ad hoc Reporting
  • Alerts/Notifications
  • Charting
  • Customizable Branding
  • Customizable Reports
  • Dashboard Creation
  • Dashboard Software
  • Data Capture and Transfer
  • Data Connectors
  • Data Discovery Software
  • Data Extraction Software
  • Data Import/Export
  • Data Mapping
  • Data Migration
  • Data Storage Management
  • Data Visualization Software
  • Database Support
  • Drag & Drop
  • Forecasting
  • Metadata Management
  • Monitoring
  • Multiple Data Sources
  • Natural Language Search
  • Performance Metrics
  • Predictive Analytics Software
  • Query Builder
  • Real Time Analytics
  • Real Time Data
  • Real Time Reporting
  • Reporting & Statistics
  • Reporting/Analytics
  • Role-Based Permissions
  • Sales Trend Analysis
  • Search/Filter
  • Secure Data Storage
  • Self Service Data Preparation
  • Self-service Analytics
  • Sentiment Analysis
  • Storytelling
  • Third Party Integrations
  • Trend Analysis
  • User Management
  • Visual Analytics
  • Visual Discovery
  • Widgets

View full list of Data Analysis Software

  • API
  • Access Controls/Permissions
  • Activity Dashboard
  • Ad hoc Analysis
  • Ad hoc Query
  • Ad hoc Reporting
  • Charting
  • Collaboration Tools
  • Content Management System (CMS) Software
  • Customizable Branding
  • Customizable Dashboard
  • Customizable Reports
  • Customizable Templates
  • Customization
  • Dashboard Creation
  • Data Capture and Transfer
  • Data Connectors
  • Data Extraction Software
  • Data Import/Export
  • Data Management Software
  • Data Mapping
  • Data Synchronization
  • Data Visualization Software
  • Drag & Drop
  • Forecasting
  • Geographic Maps
  • Monitoring
  • Multiple Data Sources
  • OLAP
  • Performance Metrics
  • Predictive Analytics Software
  • Real Time Analytics
  • Real Time Data
  • Real Time Reporting
  • Real-time Updates
  • Relational Display
  • Reporting & Statistics
  • Reporting/Analytics
  • Sales Trend Analysis
  • Scheduled / Automated Reports
  • Search/Filter
  • Simulation Software
  • Single Sign On Software
  • Third Party Integrations
  • Trend Analysis
  • Visual Analytics
  • Visual Discovery
  • Website Analytics
  • Widgets
  • Workflow Management Software

View full list of Data Visualization Software

  • API
  • Access Controls/Permissions
  • Activity Dashboard
  • Ad hoc Analysis
  • Ad hoc Query
  • Ad hoc Reporting
  • Alerts/Notifications
  • Application Development Software
  • Benchmarking
  • Charting
  • Collaboration Tools
  • Customizable Branding
  • Customizable Reports
  • Customization
  • Dashboard Creation
  • Dashboard Software
  • Data Blending
  • Data Capture and Transfer
  • Data Connectors
  • Data Extraction Software
  • Data Mapping
  • Data Synchronization
  • Data Visualization Software
  • Drag & Drop
  • Forecasting
  • Geographic Maps
  • Integration into Third Party Applications
  • Interactive Reports
  • Mobile Access
  • Mobile Reporting
  • Multi-User Collaboration
  • Multiple Data Sources
  • Predictive Analytics Software
  • Real Time Analytics
  • Real Time Data
  • Real Time Reporting
  • Reporting & Statistics
  • Reporting/Analytics
  • Role-Based Permissions
  • SSL Security
  • Self-service Analytics
  • Single Sign On Software
  • Streaming Analytics
  • Third Party Integrations
  • Trend Analysis
  • Visual Analytics
  • Visual Discovery
  • Visual Workflow Management
  • Widgets
  • Workflow Management Software

View full list of Embedded Analytics Software

Microsoft Power BI Alternatives

More Microsoft Power BI alternatives

Microsoft Power BI Reviews

Read all reviews

Overall rating

4.5/5

Average score

Ease of Use 4
Customer Service Software 4.1
Features 4.4
Value for Money 4.5

Review software

Share your experiences with other software buyers.

Write a Review!
Utkarsh B.
Power BI Developer
Computer Software, 501-1,000 Employees
Used the Software for: 1+ year
  • Overall Rating
    5 /5
  • Ease of Use
    5 /5
  • Features & Functionality
    5 /5
  • Customer Support Software
    4 /5
  • Value for Money
    5 /5
  • Likelihood to Recommend
    10/10
  • Reviewer Source 
  • Reviewed on 2021-06-03

"How Powerful is Power BI ?"

Comments: I am a Power BI Developer and have delivered many dashboards to the client in Power BI. Its Better than other Products. Its Save my lot of time by using Power BI various features. From Importing the Data to Publishing ,Its a easier platform I would suggest you to use. It contains the most trending Visuals in the market that a every developer wants.

Pros: 1)Its Easy to use, Provides a Reliable user interface .
2)Its Time efficient as most of the work Power BI does it even before you know.
3)Integration to the third party visuals and creating its own market place have already took it way further than other products.
4)A User can customize its design and can easily give the dashboard access to the public.
5)It contains the most trending Visuals in the market.

Cons: 1)Software is reliable on Latest Machines.
2)Old machines then need to be upgraded(OS, RAM) to use this software smoothly.
3) Multiple Dashboards can hang the entire system.

  • Reviewer Source 
  • Reviewed on 2021-06-03
Marco D.
Project Manager
Management Consulting, 11-50 Employees
Used the Software for: 2+ years
  • Overall Rating
    5 /5
  • Ease of Use
    5 /5
  • Features & Functionality
    5 /5
  • Customer Support Software
    4 /5
  • Value for Money
    5 /5
  • Likelihood to Recommend
    10/10
  • Reviewer Source 
  • Reviewed on 2021-04-06

"Power BI like the "self service" BI system"

Comments: it is very convenient and simple, we also have a certified person in the company and I did the course myself. it has many completely free features.
Gartner describe it like the best instrument about BI

Pros: Easy to use, cheaper then others, lots of functions and services.
We use it in our team and promote it also to our clients

Cons: power bi service layout... microsoft recently changed with an improved update but could still be improved further

  • Reviewer Source 
  • Reviewed on 2021-04-06
Verified Reviewer
Head of Application Services (System Administrator & Controlling Function)
Management Consulting, 201-500 Employees
Used the Software for: 6-12 months
  • Overall Rating
    2 /5
  • Ease of Use
    3 /5
  • Features & Functionality
    2 /5
  • Customer Support Software
    4 /5
  • Value for Money
    1 /5
  • Likelihood to Recommend
    2/10
  • Reviewer Source 
  • Source: GetApp
  • Reviewed on 2017-03-18

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

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

  • Reviewer Source 
  • Source: GetApp
  • Reviewed on 2017-03-18
Verified Reviewer
Managing Director
Information Technology & Services, 2-10 Employees
Used the Software for: 6-12 months
  • Overall Rating
    5 /5
  • Ease of Use
    5 /5
  • Features & Functionality
    4 /5
  • Customer Support Software
    5 /5
  • Value for Money
    5 /5
  • Likelihood to Recommend
    9/10
  • Reviewer Source 
  • Reviewed on 2021-06-09

"Outstanding Report Tool"

Comments: Having switched from excel recently, Microsoft Power BI has been of great help. Having good visuals for data is a plus to us as an organization for they help do comparisons at a glance.

Pros: The ability to do data linking from different data sources and doing relations and end up developing organized and analyzed data for easy decision making. It provides the ability to break down data to a level that is easy to understand. The creation of dashboard in Power BI makes the reports appealing and data presented friendly to interact with.

Cons: Loading Microsoft power BI takes quite some time especially the desktop version. I don't the reason behind it but it could be better if it is looked into and a solution found will be of great help.

  • Reviewer Source 
  • Reviewed on 2021-06-09
Milind D.
Project Manager
Information Technology & Services, 11-50 Employees
Used the Software for: Free Trial
  • Overall Rating
    5 /5
  • Ease of Use
    4 /5
  • Features & Functionality
    5 /5
  • Customer Support Software
    4 /5
  • Value for Money
    5 /5
  • Likelihood to Recommend
    10/10
  • Reviewer Source 
  • Reviewed on 2021-04-30

"Appalling numbers to pretty pictures"

Comments: Power BI has been a distinct advantage for us with regards to how we see and separate the examination of our business. Its a stage that incorporates all gatherings to one sheet and permits us to separate the information outwardly and logically. Just disadvantage is the point at which you need to make an update it could require some investment to refresh.

Pros: It's an incredible programming for examination. I love the perception highlights since it transform drilling information into fun outlines or diagrams. Phenomenal instrument, beforehand we utilized Microsoft Excel for all work, with the appearance of Power BI, all the help was modified and a superior examination came, an addition of more than 20 hours of work.

Cons: It takes some information around recipes and dominate. In the event that you don't have an insightful information group that can make these reports for you on Power BI then it will require some investment to see the examination from it.

  • Reviewer Source 
  • Reviewed on 2021-04-30