Microsoft Power BI vs. SAP Crystal

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
SAP Crystal
Score 7.5 out of 10
N/A
SAP Crystal is an analytics and reporting software solution for SMBs. SAP Crystal comprises Crystal Reports for pixel-perfect reporting, and SAP Crystal Server for automated distribution and self-service access to reports, dashboards and data exploration.
$295
per single user license
Pricing
Microsoft Power BISAP Crystal
Editions & Modules
No answers on this topic
Upgrade Version to SAP Crystal Reports 2020
$295
per single user license
SAP Crystal Reports 2020 64-Bit
$495
per single user license
SAP Crystal Reports 2016 32-Bit
$495
per single user license
SAP Crystal Server 2020 1 NUL
$869
per user license + first year maintenance to be added
SAP Crystal Server 2020 5 CAL
$8,744
5 concurrent users + first year maintenance to be added
Offerings
Pricing Offerings
Microsoft Power BISAP Crystal
Free Trial
YesYes
Free/Freemium Version
YesYes
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeOptional
Additional Details* SAP Crystal Reports 2020 Viewer allows you to view static data within a SAP Crystal Reports file. * SAP Crystal Reports 2020 - Full version allows you to create powerful, richly formatted, and dynamic reports from virtually any data source, delivered in dozens of formats, in up to 28 languages. If you already have an older version of Crystal Reports, buy a license for SAP Crystal Reports 2020 - Upgrade at a discounted, upgrade price. * SAP Crystal Server 2020, 1 NUL includes 1 license of: SAP Crystal Reports 2020 - SAP Crystal Server 2020. * As an add-on to SAP Crystal Server 2020 1 NUL, SAP Crystal Server 2020 5 CAL allows you to support a wider, intermittent audience of end users, up to five logged on at the same time.
More Pricing Information
Community Pulse
Microsoft Power BISAP Crystal
Features
Microsoft Power BISAP Crystal
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
SAP Crystal
9.3
Ratings
13% above category average
Pixel Perfect reports8.50 Ratings8.00 Ratings
Customizable dashboards10.00 Ratings10.00 Ratings
Report Formatting Templates8.00 Ratings10.00 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
SAP Crystal
9.6
Ratings
18% above category average
Drill-down analysis7.00 Ratings10.00 Ratings
Formatting capabilities9.00 Ratings10.00 Ratings
Integration with R or other statistical packages8.00 Ratings8.60 Ratings
Report sharing and collaboration9.00 Ratings10.00 Ratings
Report Output and Scheduling
Comparison of Report Output and Scheduling features of Product A and Product B
Microsoft Power BI
8.6
Ratings
4% above category average
SAP Crystal
9.4
Ratings
12% above category average
Publish to Web8.00 Ratings9.20 Ratings
Publish to PDF9.00 Ratings10.00 Ratings
Report Versioning9.00 Ratings9.00 Ratings
Report Delivery Scheduling8.00 Ratings9.00 Ratings
Delivery to Remote Servers9.00 Ratings10.00 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
SAP Crystal
8.0
Ratings
0% above category average
Pre-built visualization formats (heatmaps, scatter plots etc.)9.00 Ratings7.60 Ratings
Location Analytics / Geographic Visualization8.00 Ratings8.50 Ratings
Predictive Analytics9.00 Ratings7.80 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
SAP Crystal
8.6
Ratings
1% above category average
Multi-User Support (named login)9.00 Ratings7.80 Ratings
Role-Based Security Model9.00 Ratings7.70 Ratings
Multiple Access Permission Levels (Create, Read, Delete)10.00 Ratings8.40 Ratings
Report-Level Access Control7.00 Ratings10.00 Ratings
Single Sign-On (SSO)8.30 Ratings9.00 Ratings
Mobile Capabilities
Comparison of Mobile Capabilities features of Product A and Product B
Microsoft Power BI
8.0
Ratings
2% above category average
SAP Crystal
8.4
Ratings
6% above category average
Responsive Design for Web Access8.00 Ratings8.70 Ratings
Mobile Application7.70 Ratings7.60 Ratings
Dashboard / Report / Visualization Interactivity on Mobile7.70 Ratings9.00 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
SAP Crystal
6.9
Ratings
12% below category average
REST API8.00 Ratings7.40 Ratings
Javascript API9.90 Ratings6.00 Ratings
iFrames8.00 Ratings7.10 Ratings
Java API8.00 Ratings6.00 Ratings
Themeable User Interface (UI)8.10 Ratings8.30 Ratings
Customizable Platform (Open Source)8.40 Ratings7.00 Ratings
User Ratings
Microsoft Power BISAP Crystal
Likelihood to Recommend
8.5
(0 ratings)
10.0
(0 ratings)
Likelihood to Renew
9.0
(0 ratings)
10.0
(0 ratings)
Usability
8.0
(0 ratings)
9.5
(0 ratings)
Availability
-
(0 ratings)
8.0
(0 ratings)
Performance
-
(0 ratings)
8.0
(0 ratings)
Support Rating
10.0
(0 ratings)
8.6
(0 ratings)
In-Person Training
-
(0 ratings)
10.0
(0 ratings)
Implementation Rating
9.0
(0 ratings)
8.8
(0 ratings)
Configurability
-
(0 ratings)
8.0
(0 ratings)
Ease of integration
-
(0 ratings)
7.0
(0 ratings)
Product Scalability
-
(0 ratings)
7.0
(0 ratings)
Vendor post-sale
-
(0 ratings)
8.0
(0 ratings)
Vendor pre-sale
-
(0 ratings)
7.0
(0 ratings)
User Testimonials
Microsoft Power BISAP Crystal
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.
Read full review
Generation of templated reports is the strong suit of SAP Crystal. Allows users to change formats in templates bases on requirement with minimal effort. Automated report delivery requires the user to be aware of sql which cannot be expected from all users. Should support more document export formats and improve the UI for SAP B1 Users
Read full review
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.
Read full review
  • Great visualization for static format & precise tasks: For presentation to senior management /ex-co/vendors where concise decisions need to be made, Crystal is a nice choice to slide data into presentable views.
  • Diverse data source connect: We have used it to write reports using data from DB2, SQL, Progress, Excel spreadsheets, XML data, Access, and Lotus Notes databases. It can also be used to join different database types together in one report.
  • It uses the "recurring bands" structure for page layout which is efficient and fungible for generating different types of reports. Crystal doesn't require that we set up a metadata layer before creating reports and provides direct access to tables and dimensions.
Read full review
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.
Read full review
  • Crystal Reports charting engine is ok but compared to some other visualization products available it is behind the times.
  • Crystal Reports uses a proprietary format for its data storage, using an open format (like XML) would be much better
  • You cannot add add a structured table object to the page layout, you can only use lines and boxes
Read full review
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.
Read full review
We have been using this product for so many years and it has truly become a cornerstone to our business processes when it comes to developing and distributing information via reports. We currently have over 500 reports developed to date over about 30 systems and that will continue to grow as user needs change.
Read full review
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.
Read full review
Being able to get up and running quickly is a key asset. There's plenty of advanced features to master that are surprisingly difficult in others tools (or just missing from other tools altogether). The UI can feel a bit dated at times but its usability isn't affected. Any issue you have can usually be resolved by searching in the user community
Read full review
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.
Read full review
SAP Crystal report is very supportive in daily need of reports or any organization. Basic functionality of operational reports detailing the Sales Order details or PO in a manner which can be used very easily. A readily available solution for delivering any customized need in terms of pixelated reporting can be met easily with the tool
Read full review
In-Person Training
No answers on this topic
Trainer was patient and thorough in going through the basics and willing to answer questions by email after the initial training
Read full review
Implementation Rating
It was integrated with our erp easily and was accessible on cloud.
Read full review
Just like any other implementation: When designing the differing reports, get end users' input, make sure to design the reports so that they display the information that the company requires, in the best and clearest way possible.
Test, test, test, revise when needed, and, particularly, do sufficient training so users are comfortable using Crystal Reports!
Read full review
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
Read full review
For standard pixel perfect reporting, our company still uses Crystal Reports. It allows us to continually provide standard reporting to our clients. For dashboards, we are moving towards Microsoft Power BI. Power BI allows similar collaboration, but generally has better features for dashboards. Power BI also allows us to publish multiple reports and dashboards into a single app for our end users.
Read full review
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.
Read full review
  • Time and cost savings achieved by automation of report creating across many data sources we maintain.
  • The ability to drill down into granular details of the data leads to a better understanding of the business procedures.
  • Well-presented reports are invaluable for getting new clients on board.
Read full review
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

SAP Crystal Screenshots

Screenshot of Pixel-perfect reporting solutionScreenshot of Refresh with a clickScreenshot of Build pixel-perfect documentsScreenshot of Connect to all data sourcesScreenshot of Use drag and dropScreenshot of Build interactive reports