We performed a comparison between Microsoft Power BI and SAP Crystal Reports based on real PeerSpot user reviews.
Find out in this report how the two Reporting solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."It is a pretty straightforward and flexible solution for data integration and modeling. It is a low-code solution. When you are doing data integration, you can use the GUI, which is very simple and straightforward. You can also do very intricate custom queries and model it at different levels. It is very easy to use and scalable."
"Microsoft BI's most valuable feature is flexibility."
"The querying capabilities are the most valuable because they allow me to build many automations. We have many workflows and many databases that we work on a daily basis. They need to be updated quite quickly. In order to not to take much of our time doing these updates manually, I have set up these automations using the systems. The process is just to ingest the data and reprocess it. Every time I click a button, everything is updated in almost real time. It is by far the easiest system not only for querying but also for data modeling, data visualization, and deployment. It is light years ahead of Tableau and even Microsoft Excel to do these kinds of things. It is very easy to use and set up, and it has a lot of videos on the internet."
"Power BI is a complete ecosystem. It has an integrated ETL tool and good connectivity with applications such as Office 365 and SQL. There are also solutions for RPA, such as Microsoft Power Automate and Microsoft Power Apps. Power BI now has integration with Power Query, which has an AI feature for text analytics. Text analytics is a very good feature. This feature is also there in Tableau, but I like it in Power BI because you can write something like, "What is the total sale in the Eastern region?", and it will give you the answer. For example, when you have different types of user opinions, you just run one algorithm and you will have the output that provides the number of positive and negative responses. You can even have a dashboard with positive remarks. This feature has been introduced recently. Power BI supports the DAX and Power Query M languages. These languages are making Power BI very strong in data analytics, and you can do many types of analysis."
"Ease of development and maintenance."
"It's the analytic engine in terms of the interface on the Power BI environment, as opposed to pivot tables, and it's a mobile solution."
"The Microsoft Power BI app is very good. It's also very flexible."
"Our setup is very straight forward and can be done in a matter of hours."
"I find Crystal Reports very easy to use, even for a non-technical person."
"SAP Crystal Reports offers a plethora of features, many of which were available much earlier than in the Crystal Reports we previously used. We extensively use its capabilities for generating general reports, working with Kaspersky data, and even incorporating images into our reports. The range of functions available in SAP Crystal Reports is diverse, and we leverage them across various systems for our needs."
"The initial setup of the solution is pretty easy."
"The most valuable feature of the solution is that it is a fantastic way of generating reports."
"We use SAP Crystal Reports for operational reporting."
"It is an user-friendly solution."
"The most valuable feature is that from a user's point of view, it is easy to use and requires just a simple click to generate a report."
"I would like to see more visualization options."
"It is getting better but still, there are opportunity areas in some aspects, especially the Windows OS dependency."
"The solution could be more customizable and you do not have too much freedom on the code."
"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."
"I would like to see integration with Excel."
"Its price could be better. Its licensing cost is very high."
"A lot of people work on Excel, so being able to export an Excel file as part of a subscription would be an improvement."
"Microsoft has made a lot of progress with Power BI in the past couple of years, but there is still some room for improvement. For example, Integration is one area they could work on. They are adding more integration with other Microsoft tools, but I would like it if they sped up the process."
"SAP Crystal Reports has some compatibility issues with third-party products."
"The financing part needs improvement."
"If at all possible, a little bit of improvement on the analytical side is needed."
"It has significantly enhanced security features, especially when compared to the standard security features of the earlier PeerSpot version I purchased. I've observed improvements in security, and overall, it's quite commendable. Regarding potential enhancements for the next release of this solution, I haven't closely examined SAP Crystal Reports 53. I've only encountered it briefly, perhaps once or twice. However, I anticipate that it likely offers advanced features distinct from its predecessor. I believe there may be notable improvements and additions in the latest version, and I look forward to exploring them further."
"There could be improvements made to the analytics capabilities."
"A real improvement would be a simpler system that allows users to play with the visualization without needing specialized skills and code."
"SAP Crystal Reports should provide better support for dynamic connectors."
Microsoft Power BI is ranked 1st in Reporting with 297 reviews while SAP Crystal Reports is ranked 9th in Reporting with 48 reviews. Microsoft Power BI is rated 8.0, while SAP Crystal Reports is rated 8.4. The top reviewer of Microsoft Power BI writes "A complete ecosystem with an builtin ETL tool, good integrations with python and R, and support of DAX and Power Query (M languages)". On the other hand, the top reviewer of SAP Crystal Reports writes "Helps analyze your data by creating richly formatted, pixel-perfect, and multiple reports from virtually any data source, delivered in over a dozen formats". Microsoft Power BI is most compared with Tableau, Amazon QuickSight, KNIME, Domo and Oracle OBIEE, whereas SAP Crystal Reports is most compared with TIBCO Jaspersoft, Microsoft SQL Server Reporting Services, IBM Cognos, Tableau and Oracle OBIEE. See our Microsoft Power BI vs. SAP Crystal Reports report.
See our list of best Reporting vendors.
We monitor all Reporting reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.