Microsoft Power BI Features

Microsoft Power BI

BI visualization and reporting for desktop, web or mobile

4.49/5 (876 reviews)

Competitor Feature Comparison

360 Degree Feedback
API
Access Controls/Permissions
Activity Dashboard
Ad hoc Analysis
Ad hoc Query
Ad hoc Reporting
Alerts/Notifications
Application Development
Charting
Collaboration Tools
Customizable Branding
Customizable Dashboard
Customizable Reports
Dashboard
Dashboard Creation
Data Blending
Data Connectors
Data Discovery
Data Extraction
Data Import/Export
Data Management
Data Synchronization
Data Transformation
Data Visualization
Drag & Drop
Financial Reporting
Forecasting
Functions/Calculations
Geographic Maps
Integration into Third Party Applications
Interactive Reports
KPI Monitoring
Key Performance Indicators
Marketing Reports
Mobile Access
Mobile Alerts
Mobile Dashboards
Mobile Reporting
Multi-User Collaboration
Multiple Data Sources
Natural Language Search
Performance Metrics
Predictive Analytics
Private Dashboards
Profitability Analysis
Public Dashboards
Publishing / Sharing
Real Time Analytics
Real Time Reporting
Real-time Updates
Reporting & Statistics
Reporting/Analytics
Sales Reports
Scheduled / Automated Reports
Search/Filter
Self-service Analytics
Single Page View
Single Sign On
Streaming Analytics
Visual Analytics
Visual Discovery
Widgets
Learn moreCompare App
360 Degree Feedback
API
Access Controls/Permissions
Activity Dashboard
Ad hoc Analysis
Ad hoc Query
Ad hoc Reporting
Alerts/Notifications
Application Development
Charting
Collaboration Tools
Customizable Branding
Customizable Dashboard
Customizable Reports
Dashboard
Dashboard Creation
Data Blending
Data Connectors
Data Discovery
Data Extraction
Data Import/Export
Data Management
Data Synchronization
Data Transformation
Data Visualization
Drag & Drop
Financial Reporting
Forecasting
Functions/Calculations
Geographic Maps
Integration into Third Party Applications
Interactive Reports
KPI Monitoring
Key Performance Indicators
Marketing Reports
Mobile Access
Mobile Alerts
Mobile Dashboards
Mobile Reporting
Multi-User Collaboration
Multiple Data Sources
Natural Language Search
Performance Metrics
Predictive Analytics
Private Dashboards
Profitability Analysis
Public Dashboards
Publishing / Sharing
Real Time Analytics
Real Time Reporting
Real-time Updates
Reporting & Statistics
Reporting/Analytics
Sales Reports
Scheduled / Automated Reports
Search/Filter
Self-service Analytics
Single Page View
Single Sign On
Streaming Analytics
Visual Analytics
Visual Discovery
Widgets
Visit WebsiteCompare App
360 Degree Feedback
API
Access Controls/Permissions
Activity Dashboard
Ad hoc Analysis
Ad hoc Query
Ad hoc Reporting
Alerts/Notifications
Application Development
Charting
Collaboration Tools
Customizable Branding
Customizable Dashboard
Customizable Reports
Dashboard
Dashboard Creation
Data Blending
Data Connectors
Data Discovery
Data Extraction
Data Import/Export
Data Management
Data Synchronization
Data Transformation
Data Visualization
Drag & Drop
Financial Reporting
Forecasting
Functions/Calculations
Geographic Maps
Integration into Third Party Applications
Interactive Reports
KPI Monitoring
Key Performance Indicators
Marketing Reports
Mobile Access
Mobile Alerts
Mobile Dashboards
Mobile Reporting
Multi-User Collaboration
Multiple Data Sources
Natural Language Search
Performance Metrics
Predictive Analytics
Private Dashboards
Profitability Analysis
Public Dashboards
Publishing / Sharing
Real Time Analytics
Real Time Reporting
Real-time Updates
Reporting & Statistics
Reporting/Analytics
Sales Reports
Scheduled / Automated Reports
Search/Filter
Self-service Analytics
Single Page View
Single Sign On
Streaming Analytics
Visual Analytics
Visual Discovery
Widgets
Visit WebsiteCompare App

Mobile apps

iOS App


36,245 reviews

Requires iOS 12.2 or later. Compatible with iPhone, iPad, and iPod touch.

Android App


29,131 reviews

Microsoft Power BI Feature Reviews

25 reviewers had the following to say about Microsoft Power BI's features:

Ruwan D.

Best software for analyze data

2021-02-28

Power BI is a data and analytics reporting platform that allows companies to integrate diverse data sets into reports, as well as provide interactive visualizations and business intelligence applications via an interface that is easy enough for end users.

Pros

You can import data from a number of data sources and also we can use custom visualizations to our reports and dashboards.

Cons

It needs some knowledge on formulas and DAX language. It has updates frequently and lots are changed with the update. It will be somewhat expensive when we need to share it with more users

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 2+ years

Frequency of use: Weekly

Likelihood to recommend

9/10
Source: Capterra
Helpful?   Yes   No
Read more
Michael S.

Good Analytics

2019-05-03

Powerful analytics tool that is also easy for end users to utilize the reporting.

Pros

PowerBI allows the freedom to pull data in from multiple sources in the same dashboard. Editing tool allows for manipulation of data after it has been loaded which gives you great flexibility in your reporting.

Cons

While the software is intuitive, it sometimes makes assumptions with the data it shouldn't.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

9/10
Source: Capterra
Helpful?   Yes   No
Read more
Anonymous
(Internet company, 51-200 employees)

Just switched to Power BI from Pentaho

2019-01-23

My company has integrated Power BI among our Development, Sales, Analytics, Prouduct, and Marketing teams to share real-time data reports.

Pros

Our team made the switch 6 months ago and our ability to get real-time business intelligence has been vastly improved.

Cons

Power BI reports only seem to be able to source data from a single sheet.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 6-12 months

Frequency of use: Daily

Likelihood to recommend

9/10
Source: Capterra
Helpful?   Yes   No
Read more
Krishna Y.

Easy way to provide Business Intelligence

2019-12-12

It has power to perform all the business analytics in a breeze.

Pros

In a breeze you can create, reports, pull out analytics in real time.

Cons

Power bi have rigid formulas which make the back end complex. Dashboards are great but too crowded.

Rating breakdown

Ease of use
Features

Time used: 6-12 months

Frequency of use: Weekly

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
Nick S.

Data visualization at its finest

2021-02-22

Power BI has been a great tool for presenting these numbers in a way that is easy to read and understand with very little effort. Our dashboard allows us to track trends in data, understand relationships between different data, make estimates for future months, and demonstrate the needs we have for additional resources.

Pros

I love the visual platforms available for presenting data in Power BI.

Cons

There are limited design options for data visualization overall.

Rating breakdown

Ease of use
Features

Time used: 6-12 months

Frequency of use: Monthly

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
Anonymous
A verified reviewer

Great Analytics Platform!

2018-05-21

Create internal/operational efficiencies Enhance decision making Improve business process agility

Pros

It's a great tool to rapidly configure dynamic reports and dashboards from variety of data sources.

Cons

The connectivity / integrations for real time data updates are limited and should be enhanced to support real time APIs

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 6-12 months

Frequency of use: Weekly

Likelihood to recommend

8/10
Source: Capterra
Helpful?   Yes   No
Read more
Anonymous
(Mining & Metals company, 501-1000 employees)

A powerfull tool to manage and share your reports

2020-09-12

Power Bi is a useful tool for every professional related with data analytics, KPI reports and so on.

Pros

In my experience, Power Bi has a lot of positive aspects, and the best for me are the way the software handle a lot of format files and how intuitive it is to create dashboards and automatics reports.

Cons

At this momment, I dont have any Con yet. I have been using Power BI for 4 months and it has been so useful for me.

Rating breakdown

Value for money
Ease of use
Features

Time used: Less than 6 months

Frequency of use: Monthly

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
Anonymous
(Environmental Services company, 10001+ employees)

This platform helps user to magic with excel sheets

2019-05-16

We understand and retain information better when we can visualize our data so that is a great help when you use this platform.

Pros

You can visualize the raw data in dashboards using different visuals, so that clients can draw some conclusions from the reports.​Clients can access/interact with dashboards and reports from anywhere using Power BI mobile apps, which update automatically.​Information can be collaborated across different Business Units.A Power BI report is one or more pages of visualizations (charts and graphs)

Cons

It takes times to online load data . At times cannot sync data .

Rating breakdown

Ease of use
Features

Time used: 6-12 months

Frequency of use: Daily

Likelihood to recommend

9/10
Source: Capterra
Helpful?   Yes   No
Read more
Anonymous
(Logistics and Supply Chain company, 1001-5000 employees)

Custom Built Analytics

2021-06-29

I love power bi and everything that it offers and I think it's a great option for users and companies to build out reports and analytics.

Pros

One of my favorite features about this product is the ability to import and integrate power bi with multiple data sources.

Cons

This is not a tool you just start up and can jump right into it without getting a little bit of training and understanding how the product works.

Rating breakdown

Ease of use
Features

Time used: 1-2 years

Frequency of use: Monthly

Likelihood to recommend

8/10
Source: Capterra
Helpful?   Yes   No
Read more
Caspah L.

Power BI review

2021-02-22

I have been using Power Bi for over 2 years now in creating Dashboard for several items including Finance, data, Students and school data and recently I have used it in documenting poll results and Covid-19 cases.

Pros

In addition Power BI delivers real-time reports especially when linked with production of the data.

Cons

Since its mainly used for Dashboards and visualizations, the presentations can be crowded considering a lot of information is supposed to be squeezed on one page.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
Darren S S.

Makes your data come to life with dashboards

2019-12-27

Great solution to analyze and visualize your data into an dashboard, especially if you primarily have a Microsoft based system

Pros

Powerful analytic and dashboarding tools Integration into existing Microsoft and non-microsoft products Visualisation/presentation capabilities

Cons

Pricing could be improved Difficult learning curve Compatibility with non-Microsoft products are limited / not as full featured as Microsoft Product

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 1-2 years

Frequency of use: Weekly

Likelihood to recommend

8/10
Source: Capterra
Helpful?   Yes   No
Read more
Jayanth V.

The Power of Power BI

2021-02-04

The capability is based on how creative that we can get and use the functionality available.

Pros

The extent of customization and capability as a database, curating data, analytics, reporting and dashboarding is amazing

Cons

I wont call this a Cons...Setting up the whole BI environment may not be that user friendly but i'm thinking that may not be that easy to simplify further and there is a large element of expertise required to use this optimally.

Rating breakdown

Value for money
Ease of use
Features

Time used: Free Trial

Frequency of use: Occasionally

Likelihood to recommend

9/10
Source: Capterra
Helpful?   Yes   No
Read more
Sayali N.

Reviewing Power BI

2019-08-30

Overall I feel its a great tool for analytics and visualization. Value for money

Pros

Also it has the built in data analytics features with interactive visuals to visualize the data effectively and efficiently

Cons

Like if you need to import high volume data into Power BI then its gets slow and he data is not loaded efficiently.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 6-12 months

Frequency of use: Daily

Likelihood to recommend

9/10
Source: Capterra
Helpful?   Yes   No
Read more
Michael G.

Power BI power to spare

2017-10-10

The ability to leverage scheduled and near real-time data updates is quite powerful for pro users.

Pros

Being able to connect various data sources to Power BI visuals is beneficial and allows compelling reports and dashboards to be created.

Cons

The features that are available to free and pro customers seems to be an evolving, moving target that has proven frustrating for some end users.

Rating breakdown

Ease of use
Features

Time used: 6-12 months

Frequency of use: Daily

Likelihood to recommend

10/10
Source: Software Advice
Helpful?   Yes   No
Read more
Anonymous
(Computer Software company, 10001+ employees)

Great integration to O365

2021-04-29

Can create dashboards and publish using O365 tools.

Pros

Easy to build dashboards using multiple data source.

Cons

Some on the visualization tools are not straight forward and it might take some time to understand how to use them.

Rating breakdown

Ease of use
Features

Time used: Less than 6 months

Frequency of use: Daily

Likelihood to recommend

8/10
Source: Capterra
Helpful?   Yes   No
Read more
Raj P.

Power BI for more flexibility

2020-02-06

Overall a good product when the likes of MS Excel reach the limits of file (data) size

Pros

You can import and manipulate large volumes of data, create custom reports and filters which enable other users to more easily slice and dice and view the data they are interested in.

Cons

You need to be reasonably proficient in data analytics to create reports

Rating breakdown

Ease of use
Features

Time used: Less than 6 months

Frequency of use: Monthly

Likelihood to recommend

6/10
Source: Capterra
Helpful?   Yes   No
Read more
Saurabh G.

Power BI review

2019-11-26

creating finance dashboards and reports daily

Pros

Affordability, Excel Integration, data connectivity, personal gateway.

Cons

crowded user Interface, handling large data volumes, complex to understand and master

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: Free Trial

Frequency of use: Weekly

Likelihood to recommend

7/10
Source: Capterra
Helpful?   Yes   No
Read more
Rahul S.

Great Product for Analystics

2021-05-19

great for analytics - data mining - data transformation -

Pros

Ease of use - can use excel to just get familiarized. great analytics - can use different data sources.

Cons

need to purchase individual licenses for folks who need to tweak it. Does not support subscriptions unless you have a premium license.

Rating breakdown

Ease of use
Features

Time used: 1-2 years

Frequency of use: Weekly

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
ANurag K.

Intuitive and easy to use

2016-12-02

Customization level for each visual is really detailed.

Pros

Slicing and drill down features are really good. Predictive line and dashboard insights is really cool feature.

Cons

We cannot publish direct query data set without installing a gateway in the server.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: Less than 6 months

Frequency of use: Daily

Likelihood to recommend

10/10

Recommendations to others considering Microsoft Power BI

If you want to dazzle your audience and at the same time show meaningful insights, this is the best tool.

Source: Software Advice
Helpful?   Yes   No
Read more
Daniel Q.

Powerful analytics tool

2020-08-21

It is great for dashboards!

Pros

Has a lot of interactive chart options, which you can visualize specific data on it.

Cons

The license is typically pretty expensive, so not everyone on my team has the possibility to have one of it.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

7/10
Source: Capterra
Helpful?   Yes   No
Read more
Rob S.

Incredible analytics solution!

2018-11-02

We have tried several analytics solutions in the past and Power BI gives us the most freedom and flexibility to report on our data.

Pros

The ability to completely customise the look and feel of reports and dashboards, the product is updated on a regular basis and our end users are very happy with the results.

Cons

Setting up the data gateways was a little bit fiddly to start off with but any issues were easily resolved.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 6-12 months

Frequency of use: Daily

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
Mohammad Usman Ali K.

Data Visualizations

2021-07-05

Pros

It has easy to use interface and exceptional data visualization capabilities.PowerBI became the standard Business Intelligence visualization tool for our organization.

Cons

Sometimes you need to pay a large chunk of money to share the report and dashboard which creates many complications regarding the publication of the dashboard.

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: Less than 6 months

Frequency of use: Weekly

Likelihood to recommend

10/10
Source: Capterra
Helpful?   Yes   No
Read more
Patrick L.

PowerBI Features

2019-11-14

desgin dashboard for KPI performance monitoring on daily basis Gateway administration Plateforme administration

Pros

Conditionally format button formatting New performance analyser features Transformation tools and connector with SAP HANA data source

Cons

Memory consumption Stockage management Push a report by mail many time per day Cost of the premium License

Rating breakdown

Value for money
Ease of use
Features
Customer support

Time used: 2+ years

Frequency of use: Daily

Likelihood to recommend

9/10
Source: Capterra
Helpful?   Yes   No
Read more
Adebayo O.

The best data visualisation tool

2021-06-16

Overall PowerBi made it easy for us to have a visual overview of our data and also see likely results based on future projections.

Pros

The ability to have a visual representation of your data both in real-time and for static data.

Cons

The learning curve is a bit steep as you have to be well-grounded in basic data analytics software such as Microsoft Excel.

Rating breakdown

Value for money
Ease of use
Features

Time used: Free Trial

Frequency of use: Occasionally

Likelihood to recommend

8/10
Source: Capterra
Helpful?   Yes   No
Read more
Tony L.

Simple, powerful visualisation solution

2017-07-12

Pros

Great data connectors. Filters at visual, page and report level.

Cons

Limited (but growing) number of visualization types.

Rating breakdown

Ease of use
Features

Time used: 1-2 years

Frequency of use: Weekly

Likelihood to recommend

7/10
Source: Software Advice
Helpful?   Yes   No
Read more