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.5
Number of Reviews
296
Ranking in other categories
Data Visualization (1st), Embedded BI (1st)
 

Mindshare comparison

As of April 2025, in the BI (Business Intelligence) Tools category, the mindshare of Microsoft Power BI is 21.6%, down from 22.4% compared to the previous year. The mindshare of Tableau is 17.5%, down from 19.1% 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

"Power BI's integration with other tools is very good."
"The dashboards of Microsoft BI are easy to use."
"You don't need much support with Microsoft Power BI because it has such a large base of users who can answer your questions on their forums. There are also many video tutorials and webinars available online that offer solutions to whatever problems you may have."
"The solution is very intuitive, you do not need to have too much programming knowledge to use it. Advanced Excel users can use it very easily."
"The most valuable feature is that it's easy to use. It's very useful for non-engineers and it is the ultimate solution for providing information and insights. Power BI is the best visualization tool I have ever worked with."
"The most valuable feature is integration with Python."
"I like Microsoft BI's drill-down feature and its overall ease of use."
"The solution is very easy to use."
"It has made the reporting stage simple and enabled us to focus mainly on the ETL part"
"Tableau will automatically show charts for the related data that I choose making it very easy to use."
"All features are valuable. It is very user-friendly, and it is mostly drag-and-drop. If we have the dataset available, then we can develop any dashboard very quickly."
"Compared to other products, visualization features are really good."
"I have found Tableau easy to use and the features are superb."
"It most valuable feature is its ease of developing visualizations, not just charts and graphs."
"It is very easy to implement and to use."
"It provides business users with a tool, so they are not dependent on IT."
 

Cons

"It should be more user-friendly. There are very small or tiny icons that you need to move very carefully. If you go a little bit up and down, some of the values change. Its user interface should be improved. It should be like Tableau. Its performance is also slow and should be improved. I definitely feel some sort of speed issues with Power BI. The integration of Excel with Power BI would also be good."
"The reporting could be a bit better."
"Power BI's drillthrough feature could be improved. I didn't like drillthrough and those options much, but I did like it in MicroStrategy."
"Sometimes while developing, the front end is not easily customizable and it has limitations. We cannot go and do any UI we want. We have to stick to the limitations of the product."
"If you are having millions of rows of data or you have a large database, Microsoft BI's performance depends upon how powerful your hardware is. When I am handling large amounts of data I do not use Microsoft BI or Tableau because of this, I use D3."
"Power BI doesn't support some open-source data sources that are new, such as SnowSQL, Iceberg, or ClickHouse."
"I have a little problem with Synapse Analytics because it's very new. It's a product that has many capabilities, but it is not very well developed. I have to see the list of permissions from one object. I can't do this in Synapse. I have to search on the web for a solution because I don't have the tool for it."
"We found out that you can't share a report with others unless you have an additional package. That caught us off guard. It came as a program that somebody could go in, build a report, and show it, but you can't share it without having additional licenses."
"Tableau has so many functions, so sometimes it's hard to find the right solution quickly. I have to search multiple menu bars to find the right command."
"It needs a little bit more advanced modeling. I would like to see functionality like Cognos has in the Framework Manager."
"The forecasting feature in Tableau in my view is too limited because it must have dates but I should be able to predict the outcome of an event without having a date as part of the input."
"The data processing in Tableau is pathetic compared to Qlik."
"The charts in Tableau are quite limited."
"I would like the solution to have certain features allowing the delivery of reports to the email."
"I am a BI consultant. I have worked on different reporting tools, such as Power BI and MicroStrategy. As compared to other tools, Tableau lags behind in handling huge enterprise-level data in terms of robust security and the single integrated metadata concept. When we connect to large or very big databases, then performance-wise, I sometimes found Tableau a little bit slow. It can have the single metadata concept like other tools for the reusability of the objects in multiple reports."
"We have products like Tableau, Power BI, Cognos, and QlikView in the data visualization segment. Compared to those, Tableau is quite costly."
 

Pricing and Cost Advice

"Its price is very low. It is like $10 per user, per month. The clients pay for their own licenses. It is not on us. There are no costs in addition to the standard licensing fees. That's the beauty. With other systems, you need to spend a couple of thousand dollars just to get started, and then you need to spend $500 per year for the license, which becomes much more costly. You have a system here where for $120 to $140 a year, you can start with two people and start developing and deploying. You can see why the cost difference is huge, especially when you are on a low scale, like us, and you're not building something very huge."
"The solution's costs are quite reasonable given the range of features provided."
"We pay for users who are publishing on the cloud. The desktop version is free. Its licensing is on a yearly basis."
"Once the trial period for the BI service is over, the cost is approximately $10 USD per user, per month, so it's quite reasonable."
"The Report Server is pretty expensive on-premise. But as long companies are happy to use the cloud version, that's very cost effective."
"Licensing fees are paid on a yearly basis."
"I would advise that Microsoft BI products are rightly priced and the licensing is easy to follow and to fulfill."
"I used a two months free trial to see if it had what I needed."
"I recommend that you discuss your needs with the salesperson and try to negotiate the price."
"Buy 50 at a time. Project your use base every three months, and project your requirements forward."
"I'm using Tableau Public, which is free."
"Its price is reasonable. Everything is included in the license."
"For data extraction and analysis, Tableau is better than any other tool I have used with the same pricing model."
"It is a bit difficult for some people when they hear $70.00 per month, as some solutions are available for less than $10.00 or for free."
"The product's price is relatively inexpensive and manageable for enterprise-level companies."
"It is fairly expensive. I have no idea what they paid. We were on an enterprise license, so whatever it is they licensed at the enterprise level is what we paid."
report
Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.
845,040 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
43%
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: March 2025.
845,040 professionals have used our research since 2012.