TrustRadius

Microsoft Power BI vs. OpenText Lens

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Microsoft Power BI
Score 8.6 out of 10
N/A
Microsoft Power BI is a visualization and data discovery tool from Microsoft. It allows users to convert data into visuals and graphics, visually explore and analyze data, collaborate on interactive dashboards and reports, and scale across their organization with built-in governance and security.N/A
OpenText Lens
Score 2.0 out of 10
N/A
OpenText Lens (replacing the former OpenText Alloy) is a cloud application that offers visibility into the data flows between enterprise applications and connected systems, customers, suppliers and trading partners. Lens gives organizations insights needed to monitor business process health against KPIs, and quickly respond to key business events.N/A
Pricing
Microsoft Power BIOpenText Lens
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
Microsoft Power BIOpenText Lens
Free Trial
YesNo
Free/Freemium Version
YesNo
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details——
More Pricing Information
Community Pulse
Microsoft Power BIOpenText Lens
Considered Both Products
Microsoft Power BI
Verified User
Anonymous
Chose Microsoft Power BI
All others apps are enablers and Microsoft Power BI is the visual that end user sees which often adds more value to the end user to make strategic decisions from this. All are equally great but Microsoft Power BI is the end result
Verified User
Anonymous
Chose Microsoft Power BI
Microsoft Power BI vs. Tableau Power BI cheaper and works well with Microsoft tools. Tableau has better visuals but is costly. Microsoft Power BII vs. Looker Looker is good for big data, but Microsoft Power BI is easier to use. Microsoft Power BI vs. Qlik Qlik is fast for big …
Verified User
Anonymous
Chose Microsoft Power BI
Microsoft Power BI provide a user friendly in many ways to analyse the data and visualization of the data .Stacking makes the works easier easily attach the table ,chart row and column through the various available tool ..it also reduces the work part and manpower mechanically …
Verified User
Anonymous
Chose Microsoft Power BI
Microsoft Power BI is more flexible and it requires less effort in order to create a working environment. The results have an attractive and customizable display. The model is a star schema therefore it do not require specific database adaptation. Excel and csv files could be …
TI
Tanner Ingalls
Data Product Manager & Data Scientist
Chose Microsoft Power BI
Microsoft Power BI is free. If I didn't want to create a custom platform (i.e. my organization insisted on an existing platform that I *had* to use), I'd use Microsoft Power BI. For any start-up or SMB, I'd just use Claude & Grok to build it quickly, also for free. Would …
Verified User
Anonymous
Chose Microsoft Power BI
Same need to be large scale.
Verified User
Anonymous
Chose Microsoft Power BI
Microsoft Power BI is easier to learn, a lot of examples on YouTube, internet documentation books helps to the implementation and personalization of the dashboards easier to use than other platforms.
Verified User
Anonymous
Chose Microsoft Power BI
While excel can be useful for a very quick data dump, Microsoft Power BI is able to bring that data to life, and show trends and the actual story of what is happening. Microsoft Power BI is the ultimate display tool, and allows us to share information quickly to the CORRECT …
Verified User
Anonymous
Chose Microsoft Power BI
Compared to this tool, Microsoft Power BI doesn't involve heavy coding and provides user friendly interface to visualize data. Microsoft Power BI reports can be shared and published without exposing your source code. Also, the reports are interactive providing drill down …
Matt Aldridge | TrustRadius Reviewer
Matt Aldridge
Learning Analytics Lead
Chose Microsoft Power BI
Power BI is much simple to use, and more modern than BusinessObjects, which has now been discontinued. It costs much less to license than Tableau which is perhaps more niche and designed better. It is also much more powerful for data analysis than excel, smartsheet, airtable, …
Verified User
Anonymous
Chose Microsoft Power BI
Some of the strengths are 1. User-Friendliness 2. Self-Service BI (Caters to all levels of the employees 3. Cost-effective. 4. Easy integration with Microsoft Suits. 5. DAX Calculations 6. Familiar Interface like traditional Excel. 7. Easier Self-Service platform for …
TH
Tony Higgins
System operations
Chose Microsoft Power BI
It's got a larger user base and seems better supported. Personally it feels like alot more work getting comparable results from Tableau. Microsoft Power BI will be WAY easier to work with all your various data sources, if you are working in an environment with M365 already. …
Verified User
Anonymous
Chose Microsoft Power BI
After several years using Google Looker Studio and BigQuery, Microsoft Power BI is a step-up in terms of visualizations. It is also much more powerful, leading to less errors and has a more intuitive interface. Looker studio has a focus on google analytics whereas Microsoft …
Verified User
Anonymous
Chose Microsoft Power BI
NA - did not use any other software, yet. Happy with the services and features provided by Microsoft Power BI which helps us navigate through the client requests on a daily basis while also providing actionable insights / solutions with maximum efficiency and that too in a …
Verified User
Anonymous
Chose Microsoft Power BI
It's the most widely used tool in most organizations
Verified User
Anonymous
Chose Microsoft Power BI
Each has a different function. I think Microsoft Power BI is easier to use than Tableau and cheaper but SQL and databricks have so much more versatility
Verified User
Anonymous
Chose Microsoft Power BI
We use Microsoft Power BI in addition to other software.
Verified User
Anonymous
Chose Microsoft Power BI
I prefer Power BI because of its affordability and fewer complicated tools than Tableau. It's easy to use and compatible with other Microsoft products, which are mostly used in the IT industry. It's not limited to only one platform like Looker Studio, which is mostly used in …
Verified User
Anonymous
Chose Microsoft Power BI
Microsoft Power BI is more flexible and can also handle more complex reporting scenarios. While Microsoft Excel is a great tool for analyzing data building visuals is not what it is made for. It is complicated to create Excel reports that will be interactive as a use wants to …
Verified User
Anonymous
Chose Microsoft Power BI
Qlik also builds dashboards upon your data. It's more expensive as Microsoft Power BI and needs as much training as Microsoft Power BI
Verified User
Anonymous
Chose Microsoft Power BI
Being Microsoft environment it is extremely easy to interconnect the application with other Microsoft tools, such as power point or excel. On top of that, also communication through Microsoft teams is enabled which can result in very good collaboration and exchange of feedback …
Megan Baak | TrustRadius Reviewer
Megan Baak
Paralegal
Chose Microsoft Power BI
We actually chose both Power BI and Quantum Metric. We use them for different things, but they are very similar tools. Quantum does a good job of integrating with our website and app traffic, whereas we use Power BI for data analysis and importing data sets for further review. …
Verified User
Anonymous
Chose Microsoft Power BI
We have used Microsoft Power BI for almost seven years. When looking for a reporting platform, remember that you are about to make a long-term choice. Moving reports to another system isn't easy. If you have, for example, more than 100 reports, the move to a different platform …
OpenText Lens

No answer on this topic

Features
Microsoft Power BIOpenText Lens
BI Standard Reporting
Comparison of BI Standard Reporting features of Product A and Product B
Microsoft Power BI
8.8
Ratings
8% above category average
OpenText Lens
-
Ratings
Pixel Perfect reports8.50 Ratings00 Ratings
Customizable dashboards10.00 Ratings00 Ratings
Report Formatting Templates8.00 Ratings00 Ratings
Ad-hoc Reporting
Comparison of Ad-hoc Reporting features of Product A and Product B
Microsoft Power BI
8.2
Ratings
2% above category average
OpenText Lens
-
Ratings
Drill-down analysis7.00 Ratings00 Ratings
Formatting capabilities9.00 Ratings00 Ratings
Integration with R or other statistical packages8.00 Ratings00 Ratings
Report sharing and collaboration9.00 Ratings00 Ratings
Report Output and Scheduling
Comparison of Report Output and Scheduling features of Product A and Product B
Microsoft Power BI
8.6
Ratings
3% above category average
OpenText Lens
-
Ratings
Publish to Web8.00 Ratings00 Ratings
Publish to PDF9.00 Ratings00 Ratings
Report Versioning9.00 Ratings00 Ratings
Report Delivery Scheduling8.00 Ratings00 Ratings
Delivery to Remote Servers9.00 Ratings00 Ratings
Data Discovery and Visualization
Comparison of Data Discovery and Visualization features of Product A and Product B
Microsoft Power BI
8.7
Ratings
9% above category average
OpenText Lens
-
Ratings
Pre-built visualization formats (heatmaps, scatter plots etc.)9.00 Ratings00 Ratings
Location Analytics / Geographic Visualization8.00 Ratings00 Ratings
Predictive Analytics9.00 Ratings00 Ratings
Pattern Recognition and Data Mining9.00 Ratings00 Ratings
Access Control and Security
Comparison of Access Control and Security features of Product A and Product B
Microsoft Power BI
8.6
Ratings
1% above category average
OpenText Lens
-
Ratings
Multi-User Support (named login)9.00 Ratings00 Ratings
Role-Based Security Model9.00 Ratings00 Ratings
Multiple Access Permission Levels (Create, Read, Delete)10.00 Ratings00 Ratings
Report-Level Access Control7.00 Ratings00 Ratings
Single Sign-On (SSO)8.30 Ratings00 Ratings
Mobile Capabilities
Comparison of Mobile Capabilities features of Product A and Product B
Microsoft Power BI
8.0
Ratings
2% above category average
OpenText Lens
-
Ratings
Responsive Design for Web Access8.00 Ratings00 Ratings
Mobile Application7.70 Ratings00 Ratings
Dashboard / Report / Visualization Interactivity on Mobile7.70 Ratings00 Ratings
Application Program Interfaces (APIs) / Embedding
Comparison of Application Program Interfaces (APIs) / Embedding features of Product A and Product B
Microsoft Power BI
8.4
Ratings
7% above category average
OpenText Lens
-
Ratings
REST API8.00 Ratings00 Ratings
Javascript API9.90 Ratings00 Ratings
iFrames8.00 Ratings00 Ratings
Java API8.00 Ratings00 Ratings
Themeable User Interface (UI)8.10 Ratings00 Ratings
Customizable Platform (Open Source)8.40 Ratings00 Ratings
Best Alternatives
Microsoft Power BIOpenText Lens
Small Businesses
BrightGauge
BrightGauge
Score 9.1 out of 10
Supermetrics
Supermetrics
Score 10.0 out of 10
Medium-sized Companies
Reveal
Reveal
Score 10.0 out of 10
Supermetrics
Supermetrics
Score 10.0 out of 10
Enterprises
Kyvos Semantic Intelligence Layer
Kyvos Semantic Intelligence Layer
Score 9.9 out of 10
Dataiku
Dataiku
Score 7.6 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Microsoft Power BIOpenText Lens
Likelihood to Recommend
8.5
(0 ratings)
-
(0 ratings)
Likelihood to Renew
9.0
(0 ratings)
-
(0 ratings)
Usability
7.9
(0 ratings)
-
(0 ratings)
Support Rating
10.0
(0 ratings)
-
(0 ratings)
Implementation Rating
9.0
(0 ratings)
-
(0 ratings)
User Testimonials
Microsoft Power BIOpenText Lens
Likelihood to Recommend
Microsoft Power BI is great for sales tracking, financial reporting, and real-time operations monitoring. It integrates data from multiple sources, creating interactive dashboards for better decision-making. However, it's less ideal for real-time big data processing, offline access, or when deep customization is needed. It works best for structured reporting but struggles with highly complex data models.
Verified User
Anonymous
Read full review
No answers on this topic
Pros
  • It is great at taking in large amounts of data and housing it all.
  • Microsoft Power BI is so user friendly and it's dashboards are very easy on the eye.
  • The ease of sharing dashboards makes it great for use across a large company.
Verified User
Anonymous
Read full review
No answers on this topic
Cons
  • It would be easier for users could Microsoft Power BI and Excel used the same programming languages.
  • Would like to see the online version of Microsoft Power BI be as powerful as the desktop version.
  • Publishing a Microsoft Power BI file online and then having to save the file is somewhat redundant.
  • Would like to export each page or chart as an image.
SM
Sherri MacCheyne
Director, Strategic Operations
Read full review
No answers on this topic
Likelihood to Renew
Microsoft Power BI is an excellent and scalable tool. It has a learning curve, but once you get past that, the sky is the limit and you can build from the most simple to the most complex dashboards. I have built everything from simple reports with only a few data points to complex reports with many pages and advanced filtering.
David Jensen | TrustRadius Reviewer
David Jensen
Operations Manager, Customer Success
Read full review
No answers on this topic
Usability
Takes a little bit to get used to it. Not natively intuitive but fairly straight forward to pick up. Also docking it a few points because you can create a really clean, simple UI in Claude very quickly that's faster than building all of this yourself in Microsoft Power BI.
TI
Tanner Ingalls
Data Product Manager & Data Scientist
Read full review
No answers on this topic
Support Rating
It is a fantastic tool, you can do almost everything related with data and reports, it is a perfect substitutive of Power Point and Excel with a high evolution and flexibility, and also it is very friendly and easy to share. I think all companies should have Power BI (or other BI tool) in their software package and if they are in the MS Suite, for sure Power BI should be the one due to all the benefits of the MS ecosystem.
JM
Jose-Angel Mangas
Global Digital Operations Manager - BA Electrification
Read full review
No answers on this topic
Implementation Rating
It was integrated with our erp easily and was accessible on cloud.
Anuj Sant Technical Supply chain professional | TrustRadius Reviewer
Read full review
No answers on this topic
Alternatives Considered
All others apps are enablers and Microsoft Power BI is the visual that end user sees which often adds more value to the end user to make strategic decisions from this. All are equally great but Microsoft Power BI is the end result
Verified User
Anonymous
Read full review
No answers on this topic
Return on Investment
  • We're still early in the adoption process at this company, but we've illustrated how bad data keeps us from being more productive. ~25% of a team's work week was dedicated to effectively cleaning up entries, but it was always seen as a normal to them.
Verified User
Anonymous
Read full review
No answers on this topic
ScreenShots

Microsoft Power BI Screenshots

Screenshot of Microsoft Power BI - Turns insights into impact for business usersScreenshot of Power BI integrates easily with Microsoft 365Screenshot of Microsoft Power BI - AI-Powered CapabilitiesScreenshot of Microsoft Power BI - Copilot can be used to create reportsScreenshot of Microsoft Power BI - Data HubScreenshot of Microsoft Power BI - Scales as organizational needs grow