17 years helping British businesses
choose better software

Microsoft Power BI Reviews

4.6 (1,715) 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.5/10

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

Have you used Microsoft Power BI before?

Share your experiences with other software buyers.

Filter reviews (1,715)

Utkarsh
Utkarsh
Power BI Developer in India
Verified LinkedIn User
Computer Software, 501–1,000 Employees
Used the Software for: 1+ year
Reviewer Source

Alternatives Considered:

How Powerful is Power BI ?

5.0 3 years ago

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.

Federico
Federico
CFO in Brazil
Verified LinkedIn User
Banking, 2–10 Employees
Used the Software for: 6-12 months
Reviewer Source

Alternatives Considered:

Great tool for Data Analysis and Dashboards

4.0 2 years ago

Comments: My overall experience is great, using it to compile, perform ETL, prepare reports and create Dashboards is simply powerful.

Pros:

This is a great tool that integrates perfectly with Microsoft Excel (they are from the same family) it really makes life easy. Another great feature is the possibility to connect with a wide variety of sources such as Google Analytics, Facebook, SQL, data files, cloud files, and the list goes on. Free to use and very affordable price. Finally their visualization features are also impressive.

Cons:

Like any other tool, we found a high amount of the time required to train and master it, when you try to go beyond create reports, you would need to learn about additional tools like Gateways and Report Server. In addition, their language DAX is not the easiest language to work with, but nothing some training and research can't solve.

Johan
Application Management in Sweden
Computer Software, 2–10 Employees
Used the Software for: 2+ years
Reviewer Source

Very powerful reporting

4.0 2 months ago New

Comments: It's a great tool for creating reports and diagrams.

Pros:

The possibilities to create very complex reports

Cons:

You need a lot of SQL experience to create complex reports.

Imi
Imi
CIO in Grenada
Verified LinkedIn User
Government Administration, 1,001–5,000 Employees
Used the Software for: 6-12 months
Reviewer Source

Alternatives Considered:

Excellent tool for small offices and datasets but can lead to frustration overtime

3.0 4 years ago

Comments: I am generally satisficed with the product, price and ease of learning with lots of YouTube video and the Power BI community, there is always something new to learn and implemented to improve or help meet your reporting requirements.

Pros:

Easy to get started with Power BI if you are on the Microsoft 365 platform. Power Bi provides an easy to connect and interactive method for pulling data in real time from data collection system such as the SharePoint online, MS Excel and others. The ease of connecting with SharePoint is the strong point for my review. Having the Power Bi connected to the SharePoint system provides the opportunity to have real time dashboards and dynamic reports for any small organization that is wishing to provide real or near to real-time reporting without the heavy upfront implementation cost for software, training and human resource. Microsoft has indeed liberated the Dynamic Reporting with Power BI, and has also allowed for some very elegant web reporting to be created by non technical users. My simple work flow , SharePoint for data collection, PowerBi for reporting.

Cons:

The main issues are around the changes that are made by Microsoft, this will always be a learning curve for the users. The lack of consistency on certain actions will be the biggest issue.

Tair
Associate Director in Australia
Accounting, 10,000+ Employees
Used the Software for: 2+ years
Reviewer Source

Power BI usage report

5.0 4 months ago

Comments: Absolutely loved it and continue to use in the future.

Pros:

Microsoft Power BI became the leader of data visualisation and exploration with wide range of functionality

Cons:

Some "simple" functionality is not yet implemented in Power BI comparing to other tools (e.g. sorting by specific measures)

Seda
Seda
Senior Student Operations Specialist in Türkiye
Verified LinkedIn User
Education Management, 201–500 Employees
Used the Software for: 6-12 months
Reviewer Source

We liberated our data

5.0 last month New

Comments: Reporting processes are difficult for every business. We experienced this difficulty too, but we could easily connect to the database and convert our data into reports and graphs. Easily! All you need to do is know SQL. The rest is easy.

Pros:

We transformed the data into reports by combining IBM Informix options and our database as a database.

Cons:

It would be good if the graphics were more user-friendly during the visualization process.

PRACHI
Cyber Breach Riview Attorney in India
Legal Services, 201–500 Employees
Used the Software for: 6-12 months
Reviewer Source

Best analytics tool for data transformation and informed decision making

5.0 4 weeks ago New

Comments: It has been a good experience using Power BI as it allows me to collect all the scattered data on various other platforms and visualize it at a single place.

Pros:

It is one of the best analytics tool and the cloud storage enhances its ease of use. Also it is easy to collaborate on reports and other stuff.

Cons:

There is no bottlenecks in the tool but sometimes it slows down a bit when handling very large datasets.

Kyle
IT Director in US
Warehousing, 501–1,000 Employees
Used the Software for: 2+ years
Reviewer Source

Say Bye to spreadsheets say hello to Power BI

5.0 2 months ago

Comments: Awesome for compiling data in one place and filtering it out according to your needs.

Pros:

You can combine data from different data sources, and create beautiful visual charts of all the data, and it's interactive for the end user to click and narrow down which data type they're specifically looking for.

Cons:

There's a pretty big learning curve, but once you get the basics down, the rest will start to make sense.

Bryan
Mgr in US
Hospital & Health Care, 1,001–5,000 Employees
Used the Software for: 1+ year
Reviewer Source

Power BI - Reporting

5.0 3 weeks ago New

Pros:

It is a great tool to use for reporting across multiple locations

Cons:

Performance Power BI can be slow when processing large datasets, and it may crash while doing so.

Verified Reviewer
Verified LinkedIn User
Information Technology & Services, 1,001–5,000 Employees
Used the Software for: 6-12 months
Reviewer Source

Great BI Tool

5.0 2 months ago New

Pros:

Very functional, has power query integrated which is great!

Cons:

Some formulas (like And/Or) do not accept multiple arguments directly (as in excel) but require nested way, which i think is a bit overwhelming.

Jerry
IT System Specialist in US
Nonprofit Organization Management, 201–500 Employees
Used the Software for: 1+ year
Reviewer Source

Very robust, though a little overwhelming

4.0 5 years ago

Comments: We're moving from having staff creating Excel reports or Access database reports to having Power BI do it all for us. We spend some time cleaning up the user's data, streamlining how they enter it (and where - we still use Access, some SQL, some Sharepoint), and Power BI does the rest after that. Our staff loves that they no longer have to manually create reports, and they love the way Power BI looks for them. We are enjoying it overall.

Pros:

The dashboard creation is amazing. Give it a data source, design how you want to see your data, and it shows it to you. I enjoy creating dashboards for our different departments. And once our staff sees the reports and dashboards they get from this, vs how they used to get it in an Excel spreadsheet or an Access Report, they are hooked.

Cons:

Overwhelming in the back end. Sometimes you just cannot get the data to display the way you want. There are so many options, features, methods. It gets overwhelming. My biggest gripe is that the back end is not as user friendly as other programs. And, comparing it to something that one of my users would create in Excel, it's difficult for me to get the exact data reported that they want. I have to figure out how to display it, and because the Power Bi is just so robust, it's a little overwhelming in that respect.

Virgil
Research and Evaluation Manager and Advisor in Hong Kong
Nonprofit Organization Management, 10,000+ Employees
Used the Software for: 6-12 months
Reviewer Source

Alternatives Considered:

Moderate cost for a moderate experience for medium sized enterprises

4.0 4 years ago

Comments: So so. The dashboards and reports are limited in visual design, so they all look the same and quite ugly. Because of the difficulty sharing reports/dashboards to external individuals and the lack of a Google sheets connector I couldn't use PowerBI for most of the solutions we need, but will use it for some since it integrates well with the rest of the MS office ecosystem.

Pros:

The thing that most sets PowerBI apart from comparable business intelligence solutions is the lower cost of multi-user deployment within an organization. PowerBI is part of a Microsoft Office 365 subscription package for businesses and you only need to pay an additional 15USD/month for each additional admin/analyst account you add. This is a stark contrast to similar solutions like Tableau, which charge a monthly fee for each user and has a minimum user count that equates to roughly a 15,000USD/year license cost as minimum. If your organisation is already invested in the Microsoft Office ecosystem this could be the ideal solution for you if you need to keep costs down.

Cons:

It can't connect to google sheets and every other business intelligence platform can. This can be really limiting if your business uses a variety of SaaS solutions since many offer the simplest data integration options via Google sheets. PowerBI also has real issues with external sharing of dashboards/reports. You only have the option of publishing internally (visible to your organization's users) or publishing publically (indexed in search engines). There is no option of sharing dashboards and reports to individuals outside your organization via a login, like what is done with Google Data Studio. PowerBI also has a steep learning curve and uses 3 coding languages (DAX, M, and SQL). It's more complicated than it needs to be but it's relational database modeling has proven a good one and competitors have copied PowerBI's approach in recent years (Tableau).

Nikhil
Business Analyst in US
Education Management, 5,001–10,000 Employees
Used the Software for: 1+ year
Reviewer Source

Power BI - A platform above the rest

4.0 2 years ago

Pros:

Power BI is a valuable tool for data modeling in addition to being a visualization tool. Here, two or more tables must be joined while taking into account their cardinality. Power Bi gives us the ability to link a variety of sources, including live data warehouses and massive data lakes, to import our data. It also provides us with the option to export the dashboards through PowerPoint. Ad hoc reporting within the user hierarchy is essential to a business analyst's role in order to deliver findings to C-suite executives and decision-makers. The platform speeds up execution compared to other visualization tools because of how simple it is to use. The way everything is set out in Power BI makes it easy for the users to understand which data type fits which visualization and how it will affect the way it is perceived. The formatting available is also simple to understand and locate. KPI monitoring is extremely important and directly proportional to the setup in Power BI. Compared to Tableau I feel Power BI has a big edge.

Cons:

I have switched to this product from another one and prefer this. I believe this is the best visualization tool in the market right now.

Md. Tanvir Bin
IT officer in US
Education Management, 501–1,000 Employees
Used the Software for: Free Trial
Reviewer Source

Alternatives Considered:

Powerful analytics with an intuitive user interface (UI) and outstanding data visualization features

5.0 11 months ago

Comments: In one convenient spot, Power BI gives me excellent access to all the data sources and data sets I generate when creating the reports. I have various devices at my disposal to access the data at any time, anyplace. By using easy clicks, users may highlight features, apply filters, and interact with the dashboards.

Pros:

Power BI enables users to work together and share dashboards and data with other people. Reports and dashboards can be shared by email, social media, and web publishing, among other methods available to users. To ensure that sensitive data is protected, Power BI contains robust security features. In addition to controlling access to data, reports, and dashboards, users can create rules for preventing data loss.

Cons:

Data that Power BI can ingest is limited in size. The free version must be extended to the paid version if I want to import data bigger than 2GB. It can also crash while processing huge datasets with complicated measurements, which makes using Power BI stressful at times.

Verified Reviewer
Verified LinkedIn User
Banking, 5,001–10,000 Employees
Used the Software for: 2+ years
Reviewer Source

Alternatives Considered:

Overall the best Dashboard software at this moment

5.0 5 years ago

Comments: Part of our dashboards were developped using Power BI. Although the UI is not as perfect as Tableau, Basically it can achieve all Tableau can do, (maybe not as quick or few steps as Tableau).the modelling, the strong ETL support, the Power Query and integration with office can offset the drawbacks.

Pros:

1. The wide and deep design and full support for upstream and downstream systems; 2. Excellent query engine with well design data modelling principals (which is better than Tableau); 3. Seamless integration with other Microsoft data integration products such as SSIS, SSRS, SSAS; 4. Excellent knowledgebase community and support; 5. Quick update to the Azure cloud support

Cons:

1. UI design is a little bit inconvenient comparing to Tableau. 2. DAX is a bit complicated for power users.

Verified Reviewer
Verified LinkedIn User
Design, 10,000+ Employees
Used the Software for: 6-12 months
Reviewer Source

Alternatives Considered:

New to Power BI but love it

5.0 5 years ago

Comments: Overall I love the software and would highly recommend it. Not only does it help visualize data but also helps to keep it updated in real time with the ability to connect to a server. The automation of pulling the data on a schedule and importing it directly into the visualizations solved a huge problem for our company.

Pros:

I love how easy it is to make really powerful visualizations. The ease of use in order to basic visualizations is similar to Pivot tables in Excel. If you have a basic understanding of Pivot tables you will be able to open the software and get straight to visualizing. Once you take a deeper dive into the queries and data transformations you will uncover an entirely new world of analysis.

Cons:

The software is easy to use for basic functions but when you get into more detail it can be difficult. It is also really hard to share your work with someone that does not pay for the service. Without paying for a Power Bi Pro account it is basically impossible to share the visualizations that you have created. Also, the Arc GIS feature only works within the software. If you try to post a map visualization to a website through an embed it doesn't work.

Katerina
Manager in Türkiye
Retail, 11–50 Employees
Used the Software for: 2+ years
Reviewer Source

Alternatives Considered:

Intuitive and very customizable. An all-round fantastic visualisation solution

5.0 11 months ago

Comments: Excel and Power BI have been in my software toolkit almost since day one. I think the best thing about it is that it opens the door for in-depth data analysis without using code or SQL, which means that SMBs like ours can drive insights from data as well. Other than that, there are a lot of chart types available, and you can easily add custom elements. All in all, would definitely recommend.

Pros:

I think it's great that the interface takes most of its elements from Excel. As a person who has used Excel for pretty much the whole of the last two decades, it was much much easier to pick Power BI up for me in the beginning because I was used to most of the visual elements anyway.

Cons:

Not a huge issue but it would make my work so much easier to have the live support option as they offer in some of the other BI tools.

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

Alternatives Considered:

Outstanding Report Tool

5.0 3 years ago

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.

Merve
Business analyst in Türkiye
Education Management, 201–500 Employees
Used the Software for: 2+ years
Reviewer Source

Alternatives Considered:

Enhancing University IT Systems with Microsoft Power BI

5.0 last year

Comments: Microsoft Power BI is widely regarded as a powerful and versatile tool for data visualization and business intelligence. Its capabilities in transforming complex datasets into interactive visualizations and reports are highly appreciated by professionals across various industries.

Pros:

Power BI allows for easy sharing of reports and dashboards with colleagues and stakeholders. This promotes collaboration, as everyone can access and interact with the same data. The interactive features of Power BI dashboards enable users to drill down into data, apply filters, and explore different aspects of the dataset. This interactivity enhances data exploration and analysis.

Cons:

Data Refresh Limitations, Limited Offline Access, Advanced Analytics Requires Expertise. Power BI heavily relies on online connectivity for data retrieval and sharing. Offline access to reports and dashboards is somewhat limited, which can be a concern in certain scenarios.

Caroline
SAP B1 Consultant in Canada
Accounting, 201–500 Employees
Used the Software for: 1+ year
Reviewer Source

Microsoft Power BI is an descent alternative tool for Data Analysis by Microsoft

5.0 last year

Comments: Overall, Power BI is a great tool for data analysis and visualization helping provide you with the necessary insights for faster and informed decision making.

Pros:

The awesome attribute about Microsoft Power BI is it allows you to import data from various sources including Microsoft Excel, SQL server, Oracle Database, IBM database, etc. This shows the level of compatibility that was built on to the application to ensure it can be used diversely. In addition to this, you can also do a data merge of data from the various sources that are supported. Power BI has a variety of data visualization tools column charts, funnels, pi charts, donut charts, KPI visuals etc. Any possible data visualization you can think is included in Power BI. The interface is also quite user friendly with a few drag and drop functionality enabled.Another awesome feature about power BI is the fact that it can also be accessed via Android and IOS. You can access your data and make decisions from anywhere.You can also use natural language query to 'Ask Questions' to your data in Power BI. It can understand natural language.As expected, Power BI works well within he Microsoft Ecosystem, so if you company is already intensively on Microsoft Products, this is a seamless transition.

Cons:

There is a bit of a learning curve involved to be able to use Power BI effectively. Your organization needs to employ the services of someone who understands how to use the tool properly.

Viveka
Associate in India
Information Technology & Services, 10,000+ Employees
Used the Software for: 1+ year
Reviewer Source

Microsoft Power BI

5.0 2 years ago

Comments: Overall, Power BI is an excellent tool for data analysis and visualization, and its ease of use and integration with other tools makes more meaningful insights and informed decisions.

Pros:

Microsoft Power BI is a powerful cloud-based business intelligence tool that helps us to visualize data from multiple sources. And it is a user-friendly tool that offers drag-and-drop features and self-service capabilities. The most appealing aspect is it provides a wide range of visualizations, including charts, graphs, and maps that helps the users to understand and explore the data easily. In addition, we can also use DAX and Power Query in Power BI to perform complex calculations and analysis of the data to create insightful reports. Along with that integration is fantastic in Power BI with Microsoft products including Excel, Sharepoint, and Teams, as well as other third-party applications. And the best part is it allows users to share the created reports and dashboards with others, either within an organization or with external stakeholders. The most useful feature of Power BI is we can deploy it on both on-cloud and on-premise platforms.

Cons:

Power Bi has a limit of importing data at a time which is approximately 2 GB of data. To import greater volumes of data we need to extend our free version to a paid version of Power BI. This might be a limitation for users who can't afford to invest in a paid subscription.

Mohammed
Tech. Manager and Software Arch in Jordan
Information Technology & Services, 201–500 Employees
Used the Software for: 2+ years
Reviewer Source

A really useful tool for us in our quest for the best analysis to find the best solutions.

5.0 3 years ago

Comments: When you use Microsoft Power BI, you can automate most periodic reports and reduce the amount of time it takes to prepare those reports. As a result, we have been able to rely on it at all times and use it for a variety of different analysis procedures and duties. It's a great aid in our search for the most accurate solutions.

Pros:

Because of its multiple options and tools for analyzing and organizing data, Microsoft Power BI is software that empowers businesses. Business teams may use it to produce all aspects of business intelligence projects, from the initial concept to the final representation. The platform is user-friendly and can import and export data from a wide range of other apps, making it ideal for people of all skill levels. Data exploration, discovery, and visualization are made easier for non-technical managers with Microsoft Power BI, which allows them to access reports and dashboards without any training. To acquire the best outcomes, everyone involved can work together more closely because the data is saved on the cloud. All Microsoft Office programs, including Excel, can be used to build an interactive data dashboard. Microsoft Power BI may be used to turn an Excel spreadsheet into a database, and PowerPoint can be used to display, store, and share the data.

Cons:

Power BI requires extensive training for all members of the team, but if you have the appropriate skills, it is a superb tool for extracting the most accurate data.

Verified Reviewer
Verified LinkedIn User
Management Consulting, 10,000+ Employees
Used the Software for: 1+ year
Reviewer Source

Alternatives Considered:

One of the best BI softwares out there

5.0 5 years ago

Comments: I have created dashboards on project progress, business cases and at times, a personal dashboard of my own assets and savings just to keep track of certain things. I love that PowerBI is easy to use, and has been designed with the end user in mind. However, I would like to have a wider variety of templates to choose from, especially if I am a beginner to the whole business intelligence idea.

Pros:

Having been a user of the full range of Microsoft Office, it was only natural that PowerBI comes to mind when trying to create a live update dashboard. It is extremely easy to use - a plug and play approach comes to mind - and if you had worked with Microsoft Office before, some of the features are very intuitive to use. If the organisation that you are working with uses Microsoft Office, access issues are sorted and it becomes incredibly easy to drive adoption of this dashboard on a day to day basis

Cons:

The design of the dashboard created with PowerBI can be found to be lacking at points, compared to some of the other BI softwares. The templates available seem great, but there aren't as many options as I would like when I am creating a specific type of dashboard.

Marco
Marketing Manager in Portugal
Food & Beverages, 51–200 Employees
Used the Software for: 2+ years
Reviewer Source

Alternatives Considered:

Best analytics software in market

5.0 3 years ago

Comments: Nowadays we use PowerBI to work with all data from our companies.

Pros:

It is the best analytics software to work with large volume of data. It allows to connect to many data fonts.

Cons:

It is not easy to bring others to work with the software mostly to use DAX.

Akshika
Akshika
Senior Java Developer in India
Verified LinkedIn User
Computer Software, 10,000+ Employees
Used the Software for: 2+ years
Reviewer Source

User-friendly and with a relatively quick dataset load time, data-driven business insights

5.0 2 years ago

Pros:

The greatest business intelligence and data analytics software is Microsoft Power Bi Desktop, which guarantees that accurate data-driven insights are retrieved for corporate decision-making and smooth implementation. We can analyze, analyze, and even build dashboards using data in a variety of formats that have greater processing capability for rows and columns than Excel. Additionally, the visuals are considerably more exquisite and diversified. When I get stuck with DAX code, Power BI community articles and the DAX language's simplicity come in handy. Power BI is far more user-friendly and intuitive, in my opinion. I would strongly advise any organization seeking a BI solution to use this.

Cons:

Power BI's inability to produce bespoke infographics as quickly as Tableau is its main drawback. Direct connections may be made between Power BI Desktop and PostgreSQL DB. However, we are unable to directly link PostgreSQL DB with the Power BI service. Additionally, the cost of the program has to be drastically reduced so that more small and underutilized enterprises may benefit from it and use its features to their best potential.