Try our new research platform with insights from 80,000+ expert users

Pros & Cons summary

Buyer's Guide

Get pricing advice, tips, use cases and valuable features from real users of this product.
Get the report

Prominent pros & cons

PROS

Microsoft Power BI's integration with Python and R enhances data analysis capabilities.
Its seamless integration with Microsoft products, such as SQL Server and Excel, adds significant value.
The ability for non-technical users to easily create reports and dashboards is highly appreciated.
Automated data updates and real-time report tracking streamline decision-making processes.
DAX and Power Query M languages make Power BI exceptionally powerful for data analytics.

CONS

Microsoft Power BI lacks integration with certain machine learning platforms and third-party solutions, hindering more advanced data processing and analytics capabilities.
Documentation and support for Microsoft Power BI need improvement, specifically in providing detailed, clear information on updates and problem-solving approaches.
Real-time data processing and integration in Microsoft Power BI are often unreliable, causing delays and issues when handling large datasets.
Microsoft Power BI's pricing structure, including licensing options, is complex and costly, which could deter users seeking more affordable alternatives.
The performance of Microsoft Power BI tends to degrade with large datasets due to limitations in scalability and processing speed.
 

Microsoft Power BI Pros review quotes

it_user232830 - PeerSpot reviewer
Head of Information Systems Department at a government
Jun 15, 2017
It provides easy integration with Office tools.
it_user217881 - PeerSpot reviewer
Consultant MOA BI at a manufacturing company with 1,001-5,000 employees
Jun 15, 2017
MS SQL & SQL Server Analysis Services.
GG
Presales Architect at a tech services company with 10,001+ employees
Jun 28, 2017
With the out-of-the-box Data Platform and Business Intelligence ecosystem, you get the entire platform with a single license.
Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: December 2025.
879,711 professionals have used our research since 2012.
it_user553431 - PeerSpot reviewer
Chief Tecnical Officer at a tech services company with 51-200 employees
Jun 28, 2017
PowerBI – Self-service BI.
KC
Business Intelligence Architect at a tech services company
Jul 10, 2017
Data integration enabled my organization to easily pool data from our varied system into one data warehouse.
it_user206340 - PeerSpot reviewer
Principal Business Intelligence Analyst at a logistics company with 1,001-5,000 employees
Sep 13, 2017
SSRS and the Tabular server/Vertipaq engine/DAX are probably the two most valuable components.
PH
Partner at a consultancy with 11-50 employees
Sep 26, 2017
We can see that it's really improved the way end users can do their own graphs and pick their own fields of information and present that in a nice way.
DD
Database Expert & BI Developer at a outsourcing company with 10,001+ employees
Oct 18, 2017
Provides a full platform (database, ETL, reporting, analysis, and so on)
it_user825090 - PeerSpot reviewer
Project Manager with 51-200 employees
Feb 22, 2018
Helped identify bad data, enabling the corrections needed to the data for management.
it_user825114 - PeerSpot reviewer
Senior Manager with 10,001+ employees
Feb 22, 2018
Ease of development and maintenance.
 

Microsoft Power BI Cons review quotes

it_user232830 - PeerSpot reviewer
Head of Information Systems Department at a government
Jun 15, 2017
Our expectation is putting BI to work in real-time data collection systems in the maritime environment.
it_user217881 - PeerSpot reviewer
Consultant MOA BI at a manufacturing company with 1,001-5,000 employees
Jun 15, 2017
SQL Server Reporting Services (SSRS) is not user friendly.
GG
Presales Architect at a tech services company with 10,001+ employees
Jun 28, 2017
It is getting better but still, there are opportunity areas in some aspects, especially the Windows OS dependency.
Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: December 2025.
879,711 professionals have used our research since 2012.
it_user553431 - PeerSpot reviewer
Chief Tecnical Officer at a tech services company with 51-200 employees
Jun 28, 2017
People without private emails cannot publish and, frankly, this doesn't allow for easy training.
KC
Business Intelligence Architect at a tech services company
Jul 10, 2017
SSMS & SSRS.
it_user206340 - PeerSpot reviewer
Principal Business Intelligence Analyst at a logistics company with 1,001-5,000 employees
Sep 13, 2017
The visualization aspect, while being the most visible to business users, also happens the be the weakest point in the entire Microsoft BI stack.
PH
Partner at a consultancy with 11-50 employees
Sep 26, 2017
The way you navigate the product, compared to other products in this industry, that could be improved a bit.
DD
Database Expert & BI Developer at a outsourcing company with 10,001+ employees
Oct 18, 2017
I have to write scripts to query data for analyzing performance.
it_user825090 - PeerSpot reviewer
Project Manager with 51-200 employees
Feb 22, 2018
​It needs more graphics and overlays.
it_user825114 - PeerSpot reviewer
Senior Manager with 10,001+ employees
Feb 22, 2018
Needs single sign-on.