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

Microsoft Power BI vs Tableau comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Jan 12, 2025

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

Microsoft Power BI
Ranking in BI (Business Intelligence) Tools
1st
Ranking in Reporting
1st
Average Rating
8.0
Reviews Sentiment
7.3
Number of Reviews
319
Ranking in other categories
No ranking in other categories
Tableau
Ranking in BI (Business Intelligence) Tools
2nd
Ranking in Reporting
2nd
Average Rating
8.4
Reviews Sentiment
6.4
Number of Reviews
295
Ranking in other categories
Data Visualization (1st), Embedded BI (1st)
 

Mindshare comparison

As of February 2025, in the BI (Business Intelligence) Tools category, the mindshare of Microsoft Power BI is 21.4%, down from 22.6% compared to the previous year. The mindshare of Tableau is 18.2%, down from 18.7% compared to the previous year. It is calculated based on PeerSpot user engagement data.
BI (Business Intelligence) Tools
 

Q&A Highlights

it_user83559 - PeerSpot reviewer
May 15, 2014
 

Featured Reviews

James Balbach - PeerSpot reviewer
Robust system consistently elevates data visualization and seamlessly updates with user-driven advancements
Power BI is a general-use visualization system. I can express the performance of our network through high-level key performance indicators. It allows me to show detailed improvements in quality and safety and patient experience. I create improvement dashboards for task forces and work teams. I have built analytic dashboards that guide analytics, enabling research and dataset manipulation.
ROMIL SHAH - PeerSpot reviewer
Provides fast data access with in-memory extracts, makes it easy to create visualizations, and saves time
When it comes to visualizations, Tableau has a limitation as compared to Power BI. It has a limited set of visualizations. Power BI has the entire marketplace, so you can connect and import many visualizations and use them, whereas Tableau has only 10 or 15 visualizations. There should be more visualizations, and there should also be data integration with more cloud providers. Tableau has recently launched a paid version for the documentation. So, documentation has become a little bit challenging when it comes to Tableau development because we do not have any tool to export the data out of it. It is a license-based feature that you need to purchase to prepare documentation. So, on the documentation front, for preparing clear documentation for any dashboard, it would help if we get an embedded option, rather than buying a license for each user for the documentation. To document anything, if I have to connect to each workbook and see what has been written as a formula and then document in the Word document, it is pretty time-consuming. We have the Microsoft stack, and we are currently evaluating Power BI because Tableau has a limitation of 50 columns for a drill-down report. If we want more than 50 columns, we have found a hack, but there is no ready-made option for doing it. So, we have to use another tool in case we need a drilled report with more than 50 columns. There are many instances where users need 80 or 90 columns for their analysis, and switching between two technologies becomes a challenge. It is not a cost-effective approach for us. Their support should be improved. We are not happy with their support. Whenever we raised queries, we were pointed to a few blogs, and we didn't get a proper solution from them. Their licensing should also be improved. They want us to purchase a Tableau Creator license for business users, whereas Power BI Desktop is free for business users. They should come up with a basic license with one or two connectors that our business users can use for preparing their visualizations. Tableau also charges us per user for users who want the data only through email.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The various different ETL tools within it and the ability to have different data refreshes and scheduled refreshes [real-time data refresh capabilities] have most significantly improved the data analysis processes."
"The flexibility of the program is valuable. We are able to add other information to the reporting information and expand upon it."
"Power BI is a complete ecosystem. It has an integrated ETL tool and good connectivity with applications such as Office 365 and SQL. There are also solutions for RPA, such as Microsoft Power Automate and Microsoft Power Apps. Power BI now has integration with Power Query, which has an AI feature for text analytics. Text analytics is a very good feature. This feature is also there in Tableau, but I like it in Power BI because you can write something like, "What is the total sale in the Eastern region?", and it will give you the answer. For example, when you have different types of user opinions, you just run one algorithm and you will have the output that provides the number of positive and negative responses. You can even have a dashboard with positive remarks. This feature has been introduced recently. Power BI supports the DAX and Power Query M languages. These languages are making Power BI very strong in data analytics, and you can do many types of analysis."
"We have plans to use the AI mechanisms and algorithms that Power BI uses to publish more easy-to-understand reports for our customers."
"There is continual improvement year-over-year."
"The product can go easily go and extract data and it can put it into any format."
"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."
"MS SQL & SQL Server Analysis Services."
"The solution is configurable and flexible. We can customize the dashboards and configure the interface the way that we want. The data can be manipulated and arranged in different ways, such as columns."
"Its dashboarding is the most valuable. It is easy to create visualizations and dashboards and import Excel sheets and ESP files in Tableau as compared to other tools."
"Tableau has greatly enhanced our organization's data-driven decision-making processes by enabling us to create visually compelling reports and dashboards."
"The Web Editing capabilities allow us to grant end users enough capabilities for them to do self-serve discovery without the added cost of needing to get everyone desktop licenses."
"I like Tableau's heat maps and the storyboard. You can create data stories and tons of visuals with it, and it goes together really well. Tableau lets you manipulate the data in various ways."
"The stability seems to be very reliable."
"It's easy to use."
"A valuable feature of Tableau is that it is a useful tool for small setups. I shuffle between Tableau and MicroStrategy, so I use Tableau for personal purposes more than enterprise. I like the light version of Tableau for personal usage and doing some use cases on my own. When it comes to something small, I use Tableau for setups, rather than any other tool."
 

Cons

"Microsoft has got a very large repository of all change suggestions which have been raised by the BI community. They keep on adding features that are very widely sought after by the community. We don't focus on product features. We focus on business requirements. To use the solution, we find that existing features are good enough and offer us a very effective solution."
"I'm not overly technical, and so I can't really speak to any shortcomings from a technical standpoint."
"The interface could be improved."
"Whenever you work on the same dashboard or on the same code, Microsoft Power BI doesn't have a good architecture that allows multiple people to work on the same project."
"Microsoft needs to provide more drivers to connect other data sources in a native way."
"The challenge of this product is in truncating the table data."
"I think that the solution is harder to use for people who are not experts in data."
"If you have to pull multiple data sources performance is somewhat lacking."
"With Tableau, there is a gap in its ability to handle very large-scale data."
"The charts in Tableau are quite limited."
"It should have more integration with different tools and technologies. Its licensing cost should also be improved."
"There should be stronger data modules for the platform."
"The only issue with the solution is with its prices at a regional level."
"Formatting controls could use some improvement."
"There should be more GIS features, such as location analysis, which is quite limited. There are very few location-based functionalities."
"There are not enough language options. It needs to be offered in more than just English."
 

Pricing and Cost Advice

"The costs are small and the benefits are high."
"The cost of the solution is more flexible for us because the desktop is free and we pay as we use it in the cloud."
"Regarding cost, the initial investment wasn't too high, but ongoing licensing could add up."
"I'm unsure about the exact cost, but the Pro license comes out to around $10 per user. There are also additional costs for custom visuals that you can pay for."
"For my primary use case, i.e. teaching students, the free version of Power BI is adequate."
"While Power BI is generally a paid product, particularly for enterprise features and scalability, you can start with the free version and still achieve significant functionality."
"We view it as an expensive product."
"The pricing is very reasonable compared to any other tool."
"Tableau's licensing is pretty straightforward and simple."
"The license is very expensive."
"Pricing could be better. I believe they should offer better pricing for deployment in small to mid-sized companies."
"Its price is a concern. It is more expensive than Power BI. My guess would be that it is $1000 or less per year. We might go for Power BI in the future because of its umbrella with Microsoft licensing. It is much cheaper for us to use Power BI, and some folks will go in that direction because they don't want to pay the higher license."
"Its price is reasonable. Everything is included in the license."
"This license is on a yearly basis."
"We pay for the enterprise license for Tableau. The licensing could be cheaper and more flexible."
"For our organization, the cost hasn't been an issue."
report
Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.
838,533 professionals have used our research since 2012.
 

Comparison Review

it_user79932 - PeerSpot reviewer
Feb 4, 2015
Comparison of SAP BO, Tableau, QlikView, Cognos, Microsoft, OBIEE and Pentaho
1. SAP BO/BI Enterprise scalability Security Ease of use Semantic layer 2. Tableau Visualization Data discovery Turnaround time 3. IBM Cognos Enterprise scalability Security In-memory feature 4. MS BI - Flexibility 5. Pentaho - Open source but still enterprise grade 6. QlikView Data…
 

Answers from the Community

it_user83559 - PeerSpot reviewer
May 15, 2014
May 15, 2014
Rich- What is it that current leadership perceives as lacking in the current reporting tool set? Why change if the only benefit is features or a products capabilities? Can the products features and capabilities be exploited? By who and when? How does that make money for the company? Increased profit? Cost reduction? Increased resource utilization? Fewer days for order to cash? Reduced colle...
2 out of 21 answers
Feb 4, 2014
What might be “easy” for some is often “difficult” for others. Some users might find their experience with Tableau can be applied to quickly getting up to speed with Report Builder; others might find their mastery of Tableau gets in the way of learning the new software. I’m sure if asked, some colleague’s would say they find Tableau hard to use. Even so, I think what you really need to know is how much training would be needed after converting over to MS BI. I would suggest that to find the answer, you should ask the organization’s best Tableau users to try out a few typical daily tasks in Report Builder and let them evaluate how difficult or easy they are to complete. Their responses can be used to develop a training program for the other users. I would also suggest this link http://technet.microsoft.com/en-us/library/dd239338.aspx. It provides tutorials for various tasks in Report Builder, which may be able to give you a feel for how simple or complex it is to build a dashboard, chart or report in Report Builder.
it_user79746 - PeerSpot reviewer
Feb 4, 2014
I am still early in my Tableau experience. I do know that MS has a thing called PowerPivot which is part of the MS answer to Tableau, interesting that so many other BI providers are having to adapt to the competition provided by Tableau, but that also requires enterprise Sharepoint. Where I work they are just coming out of what we might call BI 1.0 and trying to get to BI 2.0, which is why I am there.
 

Top Industries

By visitors reading reviews
Educational Organization
44%
Financial Services Firm
8%
Computer Software Company
6%
Government
5%
Educational Organization
44%
Financial Services Firm
10%
Computer Software Company
6%
Manufacturing Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

Seeking lightweight open source BI software
There are many...It would rather depend what System BI architecture or Enterprise legacy you have at your end...I would recommend as follows: 1) If you have legacies of SAP, Oracle - look for SAP...
Is Power BI a complete platform or only a visualization tool?
Power BI is an advanced visualization tool oriented to big data with a very complete set of widgets to visualize information, control users accessing information, the configuration of governance po...
How does Oracle OBIEE compare with Microsoft BI?
Oracle OBIEE is great in allowing design and creativity per the individual needs of the organization. Dashboards are fully customizable and very user-friendly. This solution is very stable. Oracle ...
Seeking lightweight open source BI software
It depends on the Data architecture and the complexity of your requirement. Some great tools in the market are Qlik Sense, Power BI, OBIEE, Tableau, etc. I have recently started using Cognos Enter...
Tableau vs. Business Objects - Which is a better solution for visualization and analysis?
Both tools have their positives and negatives. First, I should mention that I am relatively new to Tableau. I have been working on and off Tableau for about a year, but getting to work on it consta...
Which would you choose - Tableau or SAP Analytics Cloud?
Tableau is easy to set up and maintain. In about a day it is possible for the entire platform to be deployed for use. This relatively short amount of time can make all the difference for companies ...
 

Comparisons

 

Also Known As

SSRS, SSAS, MSBI, MS Reporting Services, Microsoft BI Tools, Microsoft Big Data, Power BI Pro, MS BI
Tableau Desktop, Tableau Server, Tableau Online
 

Overview

 

Sample Customers

Accenture Adidas Aetna AIG Airbus Alibaba Allstate Amazon American Express Aon AT&T Audi Bank of America BASF Bayer Berkshire Hathaway Boeing Coca-Cola Comcast Cisco Coca-Cola Dell Disney Emirates Equinix FedEx Ford GE Google H&M Home Depot Honda IBM Intel JPMorgan Chase Kellogg's Kroger L'Oréal McDonald's Merck MetLife Microsoft Nike Oracle P&G PepsiCo Procter & Gamble Prudential Financial SAP Siemens Snapchat Spotify Starbucks Target Toyota T-Mobile Unilever Visa Walmart WeWork World Bank Xerox
Accenture, Adobe, Amazon.com, Bank of America, Charles Schwab Corp, Citigroup, Coca-Cola Company, Cornell University, Dell, Deloitte, Duke University, eBay, Exxon Mobil, Fannie Mae, Ferrari, French Red Cross, Goldman Sachs, Google, Government of Canada, HP, Intel, Johns Hopkins Hospital, Macy's, Merck, The New York Times, PayPal, Pfizer, US Army, US Air Force, Skype, and Walmart.
Find out what your peers are saying about Microsoft Power BI vs. Tableau and other solutions. Updated: February 2025.
838,533 professionals have used our research since 2012.