18 years helping British businesses
choose better software

Microsoft Power BI Reviews

4.6 (1,768) Write a Review!

About Microsoft Power BI

Power BI is a unified, scalable platform for self-service and enterprise business intelligence (BI).

Learn more about Microsoft Power BI

Pros:

The biggest positive that Power BI has going for it is that it was included as part of my organization's O365 subscription.

Cons:

The UI is clunky, the data model is not very intuitive to set up, performance is slow, especially compared to other tools. No build in box and whisker plots was a huge downside too.

Microsoft Power BI ratings

Average score

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

Likelihood to recommend

8.6/ 10

Microsoft Power BI has an overall rating of 4.6 out of 5 stars based on 1,768 user reviews on Capterra.

Have you used Microsoft Power BI before?

Share your experiences with other software buyers.

Filter reviews (1,767)

Sai
Sai
Client Project Manager in US
Verified LinkedIn User
Internet, 51–200 Employees
Used the Software for: 1-5 months
Reviewer Source

Strong visualization platform

4.0 2 years ago

Comments: Experience with Microsoft Power BI was really good and their support is a strong plus

Pros:

Microsoft Power BI is very versatile with creating dashboards and reports. Controlling access levels is efficient

Cons:

Microsoft Power BI is not that easy to use when compared to Looker. Looker has stronger features and capabilities.

Pawel
Head of Retail in UK
Retail, 11–50 Employees
Used the Software for: 2+ years
Reviewer Source

Good finance and stick reporting tool

4.0 2 months ago New

Comments: Overall it's a good option to view finance reports

Pros:

Very functional and has plenty of view options

Cons:

Sometimes it can get a bit overwhelming as there's alot of data to view

Nicolas
Data manager in France
Government Administration, Self Employed
Used the Software for: 2+ years
Reviewer Source

Probably the worst dataviz software out there

1.0 11 months ago

Comments: Go Tableau, only one which deserves my attention

Pros:

None, it's really everyday just another bad stuff happening

Cons:

It's slow, buggy, you can't do what you want to do, counter intuitive, no community

Harlan
Data Technician in UK
Marketing & Advertising, 2–10 Employees
Used the Software for: 6-12 months
Reviewer Source

Power Bi is a god send

5.0 3 months ago

Comments: Very positive, we are planning on migrating all of our reports back onto power BI after some issues we have had with the google suite. Learning it was very simple given some basic prior knowledge but more advanced knowledge is required to access the full extent of the application.

Pros:

I love power query and the many options which are available for report customization. I really like how intuitive it all was for me especially merging complex data sets. The DAX code allows complex functions when processing data to divine advanced insights.

Cons:

My least favourite thing about power bi is definitely the formatting options. In terms of making things the same size and auto aligning correctly it can sometimes be quite a hassle.

Davide
Sales Manager in US
Chemicals, 11–50 Employees
Used the Software for: 2+ years
Reviewer Source

My Experience with Microsoft Power BI

5.0 2 months ago New

Pros:

Its an easy to use tool that allows you to analyze data like a pro. The tool has many features and capability such as statistical analysis, data cleaning, reporting and data visualization. It offers seamless integration with Microsoft ecosystem.

Cons:

There is nothing that was so odd with the tool.

Harpreet
Continuous improvement specialist in Canada
Automotive, 501–1,000 Employees
Used the Software for: 2+ years
Reviewer Source

Data Visualization

5.0 last month New

Comments: I am using BI in my current and last company and it is one of the best tool to manage and share visualization

Pros:

Very best tool for visualization and data management

Cons:

One wrong DAX query can mess all the connected tables

Jace
Sr. Project Manager in US
Computer Software, 51–200 Employees
Used the Software for: 1+ year
Reviewer Source

#1 in the industry for a reason

5.0 2 months ago New

Pros:

This is one of the best analytics tools on the market. We can combine multiple data sources into 1 report, create relationships and many other amazing things.

Cons:

The licensing and limited capabilities to share to others. Also, it requires a lot of memory to run on a laptop, I recommend buying some additional RAM

Ajoke
Regional Network Analyst in UK
Information Technology & Services, 201–500 Employees
Used the Software for: 1+ year
Reviewer Source

My Power BI Experience

5.0 2 months ago New

Pros:

It is a good visualization tool for creating interactive dashboards

Cons:

It sometimes does not update in real-time

Erika
Data Analyst in Germany
Information Technology & Services, 51–200 Employees
Used the Software for: 1+ year
Reviewer Source

Microsoft Power BI

5.0 2 weeks ago New

Pros:

It provides robust data visualization tools that make it easier to analyze and present complex information

Cons:

Some customization options may feel limited compared to other BI tools

olamide
performance analyst in UK
Automotive, 51–200 Employees
Used the Software for: 1+ year
Reviewer Source

seamless data sharing

5.0 2 months ago

Comments: Its data visualization and the integration between other Microsoft products make its easy to work

Pros:

I really appreciate the seamless integration between all the tools in power and easy to link to excel and power point.

Cons:

What I like least about Microsoft Power BI is for beginners it could be overwhelming.

Bernhard
Business Manager - Data and Analytics in Netherlands
Computer Software, 201–500 Employees
Used the Software for: 2+ years
Reviewer Source

Alternatives Considered:

Power BI - Excel on steroids

5.0 6 months ago

Comments: I learnt Power BI capabilities first through Excel Power Pivot and then rolled out Power BI at my company. I liked it so much that I moved to consultancy and now support companies in rolling out Power BI as a career. I only work with Power BI as I genuinely prefer it over other BI tools.

Pros:

Coming from a business background I found Power Bi easy to access, learn and ultimately master. It combines the best of both worlds: easy access and powerful capabilities.

Cons:

There’s a few (isolated) things where competitive solutions may have a better capabilities : maps are one of them.

Manmadharaj
Assistant Manager in India
Pharmaceuticals, 5,001–10,000 Employees
Used the Software for: 2+ years
Reviewer Source

Alternatives Considered:

MSBI is master of businiess intelligence

5.0 9 months ago

Comments: There is plenty of documentation available online from creating visuals to advance functions using measures and It is easy enough for a non-developer to use and turn a mess of data into an intelligent and understandable story.

Pros:

Microsoft Power BI is a wonderful cloud-based business intelligence tool that helps us to visualize data from multiple sources. As per my view, it turns ugly numbers into amazing reports and visualizations and it doesn't require any prior high programming or technical knowledge.

Cons:

We may experience some performance degrade when we work are working with big dataset. No. of data refresh is limited per day!

Verified Reviewer
Verified LinkedIn User
Information Technology & Services, 11–50 Employees
Used the Software for: 6-12 months
Reviewer Source

Alternatives Considered:

Intuitive interface

5.0 last year

Comments: Has an active community of users who share knowledge, solve problems and contribute to the development of the platform.

Pros:

Allows real time updates and integration with microsoft tools

Cons:

Some users habe note that there ir a learning curve, especially for those who are new to the tool or have no prior data analysis experience.

Fiona
Director of Planning in UK
Higher Education, 1,001–5,000 Employees
Used the Software for: 6-12 months
Reviewer Source

Good tool with some drawbacks

4.0 3 months ago

Comments: I am a fairly new user of Microsoft Power BI. It's certainly easier to use than my organisation's previous system (Oracle BI). However I'm finding it harder to get used to than I expected, as someone who is always keen to try out some new software.

Pros:

Good tool for standardising the presentation of data and simplifying access to it

Cons:

Not particularly intuitive to use. Maybe this is inevitable given the complexity of the package. However I find it confusing at times to use filters and reset them as there seem to be several different ways in which filters can be applied.

Cody
VP Product and Technology in US
Real Estate, 11–50 Employees
Used the Software for: 2+ years
Reviewer Source

Alternatives Considered:

Robust tool, with a steep learning curve

4.0 6 months ago

Comments: There is a pretty steep learning curve to set up a robust dashboard, but if you stick with it the insights can be very helpful. For the price, it has been worth the effort and our team gets regular use and value from the many dashboard pages we have in place.

Pros:

With the right data backing it, the dashboards can be adjusted and augmented quickly, sometimes right in the browser, to glean new insights.

Cons:

When manipulating data, the language and structures needed are clunky and proprietary. For example, to display a date in a new format conditionally, a new measure needs to be built, written with functions and syntax specific to Power Bi.

Xiang
Director in US
Computer Software, 1,001–5,000 Employees
Used the Software for: 2+ years
Reviewer Source

Microsoft Power BI provides the interactive visualizations and reports which helps the administration to make a better decision.

5.0 last year

Comments: We use Power BI as an excellent tool to analyze the data and create visualization/reports. It helps the business decisions.

Pros:

Ease to creating visualizations; excellent integration with other Microsoft applications and Google sheets. Support document is effective and easy to get.

Cons:

The use of AI in the visualizations and reports need to be improved.

Victor
Pharmacy Manager in US
Pharmaceuticals, 10,000+ Employees
Used the Software for: 2+ years
Reviewer Source

Power BI used at a pharmacy

4.0 8 months ago

Comments: It is simple to use at the pharmacy and gives us a clear picture of how the store is doing. Since we are only looking at data, it is very practical.

Pros:

The ease of use allows for daily access of the stores information. It give us the opportunity to compare numbers to the previous year and see any trends

Cons:

The charts created can be easier to read. The x and y axis aren’t usually labeled so if we are looking at the chart without knowing what info it is charting it can be confusing

Robert
Reporting Specialist in US
Mental Health Care, 51–200 Employees
Used the Software for: 2+ years
Reviewer Source

Microsoft Power BI is a powerful BI tool

5.0 3 months ago

Comments: Overall, my company really loves the reports I've been able to generate for them. I've really enjoyed learning and expanding my capabilities. It is complex enough to keep me learning for years.

Pros:

Power BI Desktop is free to start with, so you can build reports right away. You can pull data from a nearly unlimited list of sources including straight off of websites. The tool has a lot of power, which can be a pro or a con. Tool development is ongoing.

Cons:

The tool is complex. The different functionality at the different Pro and Premier levels can be tricky as well as using the On Premises Gateway.

Verified Reviewer
Verified LinkedIn User
Food Production, 201–500 Employees
Used the Software for: 2+ years
Reviewer Source

Trusted BI Solution for Our Manufacturing Operations

5.0 last year

Comments: Microsoft Power BI has been a trusty business intelligence tool for us. We use it to report on our machines' performance, creating active reports for employee-related data, finance dashboards, and more and more. Considering the scale we're using it, it's pretty impressive how little technical maintenance it requires. All in all, if you're looking for dependability, you can't go wrong with MS Power BI

Pros:

Microsoft Power BI is far more dependable and performs higher over a long period compared to most of the other BI tools out there. It's performed very well in our security tests, and we very very rarely see any issues with it (mainly issues with fetching data from other tools.)

Cons:

There isn't anything that'd lead us to start looking for another tool, but I guess my one concern would be the aging interface. It's a lot easier to use as we all know the familiar design elements, but I think it's starting to lag behind their competitors a bit.

Beth W
Beth W
Digital Creator in Kenya
Verified LinkedIn User
Entertainment, 11–50 Employees
Used the Software for: 2+ years
Reviewer Source

The ultimate best tool for accurate business analytics.

5.0 last year

Comments: Microsoft Power BI helps us to run our business efficiently by giving us insights which allows us to understand which areas that are performing well as well as areas which need much of our attention. Moreso, it helps us understand our performance in the market and thereby develop strategies to help us remain competitive in the gaming market.

Pros:

With Microsoft Power BI, we are able to run full analysis on our entire business and this keeps us on the light about how every part and department of the company is performing. The reports we get are easy to read and understand and with the visualization options available like graphs, we get to capture insights easily from them. It has well defined and dynamic security functions which guarantee the security of all our business data by making sure thag we are the only ones with the access to these confidential information.

Cons:

Am yet to experience the downside of Microsoft Power BI and there has been nothing that has ever gone wrong with it.

Issac
Senior Engineer in India
Automotive, 10,000+ Employees
Used the Software for: 1+ year
Reviewer Source

A professional business intelligence tool

4.0 3 months ago

Comments: I use it primarily for developing dasboards and the whole experience is great from creating the dashboard to publishing it in workspaces everything is seamless

Pros:

Very easy to connect to a wide variety of datasources such as sharepoint List,SQL Databses and excel files . The data transform option supports a wide variety of data manipulation and data cleaning options which makes data modelling very easy It supports a lot of inbuilt visualization graphs and figures with an easy drag and drop functionality.

Cons:

Only the data loading while working on large datasets takes a lot of time if that can be improved a really great tool

Angela
Angela
SharePoint Developer in South Africa
Verified LinkedIn User
Information Technology & Services, 1,001–5,000 Employees
Used the Software for: 1+ year
Reviewer Source

Microsoft Power BI from a SharePoint Dev

5.0 last year

Comments: The steepest slope to climb was formula syntax. It was a lot of testing in excel and trying to convert to Power BI. Luckily the forums are helpful, and most formulas are already available to copy and paste from the forums too.

Pros:

I enjoyed the natural availability of Microsoft Power BI within SharePoint lists. It made quick dashboards and quick visuals easy, without having to navigate between different programs, I could just do it all in the same browser window.

Cons:

The licensing and sharing was confusing and frustrating to begin with, but I guess any product has to make money somehow. We can't get everything for free.

Graeme
Head of Operations in UK
Marketing & Advertising, 1,001–5,000 Employees
Used the Software for: 1+ year
Reviewer Source

Use Power BI to transform your complex data into a clear dashboard

4.0 7 months ago

Comments: My overall experience with Power BI is very positive. Before I used it it was extremely hard to see that data I needed in such a clear way. It's generally very easy to use.

Pros:

It is a clear way of visualizing complicated and complex data.

Cons:

It can be a little clunky at times when loading the data into the system.

Njoki
Njoki
Press Machine Operator in Kenya
Verified LinkedIn User
Printing, 201–500 Employees
Used the Software for: 2+ years
Reviewer Source

Insights you can trust.

5.0 last year

Comments: Microsoft Power BI always shows prowess in business data analytics and this has enabled us to achieve a better understanding of our business operations. With the insights we get from Microsoft Power BI, we are able to make informed decisions, plan and do forecasts to prepare ourselves for situations deemed to happen before they do.

Pros:

In data analytics, the insights are only important if one can understand them and for that i like how Microsoft Power BI offers easy to understand data visualization tools which makes it easy to read and understand the insights about the business. It allows easy creation of reports which we use to demonstrate how our business is performing as well as understanding areas in our business which needs improvement. The data analysis tools uses AI and drag and drop technology which makes it easy for anyone to use it for the analysis.

Cons:

Nothing at all from me. Using Microsoft Power BI has been so simple and it has very responsive features.

Eric
Eric
Data Analyst in Kenya
Verified LinkedIn User
Information Technology & Services, 51–200 Employees
Used the Software for: 2+ years
Reviewer Source

Microsoft powerbi review

5.0 last year

Comments: I love using Powerbi in my day-to-day analysis, I find it easy to use and would highly recommend it to other users.

Pros:

PowerBI integrates seamlessly with other Microsoft products which are widely used such as Microsoft Excel and also is very user-friendly which is a huge plus.

Cons:

Powerbi is great but I think the visuals could look a little better.