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

Microsoft Power BI vs SAP Analytics Cloud 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
Average Rating
8.0
Reviews Sentiment
7.3
Number of Reviews
319
Ranking in other categories
Reporting (1st)
SAP Analytics Cloud
Ranking in BI (Business Intelligence) Tools
5th
Average Rating
8.0
Reviews Sentiment
7.4
Number of Reviews
69
Ranking in other categories
Predictive Analytics (2nd)
 

Mindshare comparison

As of March 2025, in the BI (Business Intelligence) Tools category, the mindshare of Microsoft Power BI is 21.8%, down from 22.7% compared to the previous year. The mindshare of SAP Analytics Cloud is 4.5%, down from 5.8% compared to the previous year. It is calculated based on PeerSpot user engagement data.
BI (Business Intelligence) Tools
 

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.
RamasamyTelungupalayam - PeerSpot reviewer
Seamless integration, collaborative features, and enhances data exploration
There are several areas for improvement in SAP Analytics Cloud. Firstly, features available in SAP Lumira are missing in SAP Analytics Cloud. Secondly, the predictive analytics functions, although promising, are currently only suitable for Proof of Concepts (POCs) and not for industrial-scale use. Lastly, the pricing model for the planning functionality is quite high and presents an entry barrier.

Quotes from Members

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

Pros

"It gives you an edge if you are on the Microsoft platform. If you have been using Microsoft products for a long time or if you have the Microsoft infrastructure, this is the right tool for you. It has seamless integration with Microsoft SQL Server and other sources, and you get the best of the three things (SSIS, SSAS, and SSRS) in one suite."
"Premium features that used to cost $5,000 per company per month recently became a lot more accessible. Microsoft recently implemented a per user feature in Power BI Premium; it's $20 per month."
"The DAX coding language is good for creating formulae."
"The most valuable feature is integration with Python."
"The interface is very easy to use."
"The most valuable feature is shareability, where we can publish work to the cloud and share it with team members."
"Microsoft BI is easy to use and to design. I found Microsoft BI a lot easier than Tableau."
"Implementation is very quick and the solution is very user-friendly."
"Offers both business intelligence as well as inbuilt AI and machine learning capabilities."
"If 85-90% of your data comes from SAP, then it's the best solution."
"The tool's most valuable features are the BI and planning functionalities. I value being able to integrate smart planning with BI for analysis. The solution is user-friendly."
"In the data warehouse, you're free to make changes. You can make everything text, meaning it's always a string. Even numbers appear as text, giving you the flexibility to work with all columns."
"I like the connectivity the solution provides with other products."
"A robust solution."
"The product is flexible and has features like AI, link analysis, and insights. It has many features. I can search, and it creates automatic charts without selecting anything. For example, I can ask, "What is the gross margin?" the tool builds a chart based on my question."
"The product's most valuable features are reporting and planning, driverless planning, business vertical-wise planning, dashboarding, forecasting tools, and business forecasting."
 

Cons

"The orchestration module for refreshing data flows is something that is missing and we have to do it manually."
"I would like to see Machine Learning for Power Bi Pro users or an intermediate license to enable Machine Learning if you don't have access to a Premium account."
"It's not really complicated, but I didn't find the things I was looking for. The ones I used to work with within Dash are more open, and there are more choices. But with Power BI, there are only limited types of plots that I can use. For example, when I wanted to put the plots in Power BI, there was no extendable space. You have a limited page where you can place a maximum of three plots in that, and you can't do more than that on a single page. You have to create a new page, a different page for that. That made it a bit annoying, and the filtering part is limited, with basic functions. If you want to make custom filtering or custom functions, you can't do that."
"One thing I would like to have is the scripting language, as they already have within Excel. It's already within a Microsoft business product, because Excel is the number one business product out there. So it would be nice to have the scripting capability in order to automate certain processes."
"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."
"We would like it if they added more Python libraries in the Power BI service. For Power BI service right now, you can use Python, but it is limited to a few libraries or a few packages from Python."
"I find the solution to be 70 percent stable."
"I would prefer that the solution not be shared. I'm concerned that if we make a mistake we could reveal information to people who shouldn't see it. I would like to have my own on-prem server, to buy my own server and have my own infrastructure for Microsoft BI, with only with my data."
"Live Data Models are very slow and the setup can be improved, with tools such as Cloud Connector being inbuilt into SAP Analytics Cloud. Likewise, we need to write application code from scratch, rather than tweaking existing code, as we might with Excel macros. Moreover, when using responsive pages, the widgets get adjusted according to the mobile screen. As a result, when I place two or three KPI tiles, they can only be viewed tile-by-tile. We want to see the full dashboard on the mobile screen and zoom in to click on a particular section of the dashboard and go further into that. But displaying tile-by-tile makes it very annoying and the upper management using this dashboard might not be aware there are any more tiles to view."
"What could be improved in SAP Analytics Cloud is integration, particularly in terms of extracting data from the source system. Currently, its data extraction mechanism doesn't have good integration and needs improvement."
"There should be more features for the time series charts."
"All the features are there, maybe except for the one-gauge visualization."
"The predictive analytics functions, although promising, are currently only suitable for Proof of Concepts (POCs) and not for industrial-scale use."
"We need to know that we are using the latest and greatest, and SAP appears as if it has lost some credit in the market.​"
"AI doesn't work as well with SAP live connections."
"One potential improvement is how we can transpose data. With SAP, if you have data from one system with a declared data type and a different system with another data type, the transfer is tricky."
 

Pricing and Cost Advice

"It is free."
"The only other cost, besides the licensing fee, would be to cover support."
"Price is the best feature of Power BI! You get a lot of value for the price. If you know how to use it, it's a great BI solution for your money."
"As far as I am aware you do not need a license for the solution."
"The price of Microsoft BI is reasonable. Other solutions such as SAP Cloud are more expensive."
"I think it's a good price, from what I've heard. I know it's competitive with other Power BI tools."
"It is somewhere in the middle in terms of price. Licensing is quite clear."
"Paid for itself in the first month."
"SAP Analytics can be very costly to license, which can make it difficult for organizations to implement."
"Its licensing is on a monthly basis."
"The tool's pricing is medium, and licensing costs are yearly."
"Its pricing is okay as compared to its competitors."
"It's quite expensive and costs a lot to maintain, especially with licensing."
"It is a bit expensive, but really worth it, especially if you are already using other SAP tools."
"The premium option is very expensive at five thousand dollars. I use the nine hundred and ninety-nine dollar option."
"Its price is slightly on the higher side."
report
Use our free recommendation engine to learn which BI (Business Intelligence) Tools solutions are best for your needs.
842,296 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…
 

Top Industries

By visitors reading reviews
Educational Organization
43%
Financial Services Firm
8%
Computer Software Company
6%
Government
5%
Educational Organization
21%
Manufacturing Company
15%
Computer Software Company
8%
Financial Services Firm
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 ...
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 ...
What do you like most about SAP Analytics Cloud?
In the data warehouse, you're free to make changes. You can make everything text, meaning it's always a string. Even numbers appear as text, giving you the flexibility to work with all columns.
What is your experience regarding pricing and costs for SAP Analytics Cloud?
The pricing model for SAP Analytics Cloud is quite competitive, but the cost for the planning functionality is high and can be a barrier to entry. The overall cost can be managed with better billin...
 

Also Known As

SSRS, SSAS, MSBI, MS Reporting Services, Microsoft BI Tools, Microsoft Big Data, Power BI Pro, MS BI
SAP BusinessObjects Cloud
 

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
Live Oak Bank
Find out what your peers are saying about Microsoft Power BI vs. SAP Analytics Cloud and other solutions. Updated: March 2025.
842,296 professionals have used our research since 2012.