No more typing reviews! Try our Samantha, our new voice AI agent.

Microsoft Power BI vs OpenText Intelligence comparison

Why PeerSpot?
 

Comparison Buyer's Guide

Executive SummaryUpdated on Mar 29, 2026

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
6.6
Number of Reviews
332
Ranking in other categories
No ranking in other categories
OpenText Intelligence
Ranking in BI (Business Intelligence) Tools
37th
Ranking in Reporting
29th
Average Rating
8.0
Reviews Sentiment
7.7
Number of Reviews
1
Ranking in other categories
Data Visualization (24th)
 

Mindshare comparison

As of September 2026, in the Reporting category, the mindshare of Microsoft Power BI is 12.7%, down from 24.3% compared to the previous year. The mindshare of OpenText Intelligence is 1.5%, up from 0.8% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Reporting Mindshare Distribution
ProductMindshare (%)
Microsoft Power BI12.7%
OpenText Intelligence1.5%
Other85.8%
Reporting
 

Featured Reviews

Hemanthreddy Vakiti - PeerSpot reviewer
Junior Data engineer at a tech vendor with 10,001+ employees
Interactive dashboards have transformed restaurant data into faster daily business decisions
Microsoft Power BI has many features and there is not a lot to improve. However, the licensing can be confusing. When deciding between Pro and Premium, I find it difficult to distinguish what features are offered by Pro and what features are offered by Premium, including the particular differences to choose between both licensing models. Additionally, some features such as DAX, which I mentioned previously, involve DAX calculations and complex data modeling, which are somewhat advanced and not easily understandable. Prior knowledge is required or you need to go through the documentation. If the documentation is made comprehensive so that anyone with no knowledge on DAX can easily use it by going through the documentation, it would be really helpful. Additionally, if the integration with non-Microsoft tools is improved and performance is optimized, then Microsoft Power BI can become a top-ranked visualization tool. The user experience with Microsoft Power BI is quite good. The intuitive user interface makes it easy for both technical and non-technical users to create reports. However, only the advanced features are somewhat complex, and if the documentation is improved, it can be easily accessible.
it_user220707 - PeerSpot reviewer
Director & Lead Consultant at a consultancy with 51-200 employees
The Briefing Book feature enables measures to be filtered and viewed based on different criteria by end users.
This software is targeted at executive users, not the data analysts who want to slice and dice. The software will not replace your BI tools, but it will sit nicely on top of a BI tool if you want management to have quick and easy access to performance data. Initiative Management Metrics Management – Key Interfaces

Quotes from Members

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

Pros

"Microsoft SQL Server BI made data correlation between the agencies so fast, that the simple POCs for the dashboards let the decision-makers to migrate our so-called enterprise architecture."
"My overall experience with Microsoft SQL Server Reporting Services is that it is easy to install and to integrate in an enterprise setting."
"I like how the Query Editor lets me manipulate the data, and the available visuals are good. You can do everything using the UI."
"This is a solution that I would recommend because it is easy to use and they will be able to streamline their business processes."
"We are a consultancy firm, helping our clients with billing and business intelligence solutions, and 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."
"The reports are easy to create."
"It is stable enough. It has a lot of powerful functions. It can also be customized with the DAX language. It is also intuitive enough and incremental. You can start with something simple, and then step-by-step, you can increase the reports and dashboards according to your needs."
"You can integrate Microsoft Power BI with various other solutions like Intune."
"It is a comprehensive solution for performance management, and yet it is easy to setup and easy to use, especially in comparison with Oracle, SAS, Hyperion and SAP."
 

Cons

"Performance can be better; of course, it depends on your hardware but it can also be improved."
"Microsoft BI typically connects to a database, often SQL Server, but it's also capable of connecting to multiple databases, pulling data from them, and allowing for data consolidation. You can then aggregate and generate dashboards and reports from this combined data. Personally, I wouldn't claim to have the expertise to suggest significant changes or additional features, as it functions quite well as is."
"At times, I feel that the system needs improvement in single sign-on, especially for the on-premises side of the tool."
"Creating dashboards could be easier."
"The solution could improve by simplifying the user interface and adding integration or compatibility with APA."
"I would like to be able to use SQL properly within the reports and allow multiple people to work on the same report at the same time. If one person is working on it, then it causes issues for anyone else wanting to make reports."
"The desktop tool is very memory-intensive, and again, this is not documented clearly; it requires heavy CPU and memory use, and it causes your operating systems to become unstable."
"I'm looking for something that can make it much easier to incorporate Power BI visuals or dashboards into, let's say, Power Apps – custom Power Apps or anything like that. The most important thing would be to seamlessly embed reports in applications. For example, to have buttons that can be navigated through multiple solutions – from Power Apps to Power BI to SharePoint – via links or something like that."
"It needs to have better quality built in reports."
 

Pricing and Cost Advice

"The current licensing model that Microsoft BI has is expensive. My customers have told me the cost is approximately $20 per user and this can get expensive fast. There should be a one-time purchase option if the customer has a lot of users."
"In general, Microsoft BI's price is lower compared to Alteryx."
"Remove the cost of a licence to show a dashboard within SharePoint. Why should readers of a dashboard have to pay to view? ​"
"I very much recommend the free trial mode."
"The only other cost, besides the licensing fee, would be to cover support."
"I would rate them 4 out of 5 for their current pricing. There are no additional costs to the standard licensing fees."
"Downloading Power BI Desktop is free."
"They have a free Power BI Desktop version, but it has limitations."
Information not available
report
Use our free recommendation engine to learn which Reporting solutions are best for your needs.
913,806 professionals have used our research since 2012.
 

Comparison Review

it_user79932 - PeerSpot reviewer
Senior Manager - BI Head with 5,001-10,000 employees
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
Financial Services Firm
14%
Construction Company
8%
Manufacturing Company
7%
Government
7%
Construction Company
16%
Outsourcing Company
12%
Comms Service Provider
11%
Insurance Company
9%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business137
Midsize Enterprise59
Large Enterprise171
No data available
 

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 ...
Ask a question
Earn 20 points
 

Also Known As

SSRS, SSAS, MSBI, MS Reporting Services, Microsoft BI Tools, Microsoft Big Data, Power BI Pro, MS BI
OpenText Magellan Analytics Suite, BIRT iHub Visualization Platform, OpenText Actuate Information Hub
 

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
Sasktel, NSBSL
Find out what your peers are saying about Microsoft, Salesforce, Plotly and others in Reporting. Updated: September 2026.
913,806 professionals have used our research since 2012.