We performed a comparison between Microsoft Power BI and Microsoft SQL Server Reporting Services 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."The product is intuitive and user-friendly."
"The solution has a good toggling feature."
"What I have found valuable about Microsoft BI is its performance and ease of use. The interface is very simple and it is accessible to everyone. If someone is new to this type of solution it is straightforward to understand."
"As it was my first time using Power BI, I can say that it was fairly easy to learn, especially if you already know BI-type tools."
"The solution is very intuitive, you do not need to have too much programming knowledge to use it. Advanced Excel users can use it very easily."
"The initial setup is simple to do."
"The most valuable feature of Microsoft Power BI is the drill-through feature that takes you to a details page the users want to see."
"What I like about Power BI is how fast you are able to create dashboards and how fast you are able to fetch the data. You can connect to the database or data source, and then you can design your dashboards very easily."
"The initial setup is easy."
"The tool's valuable features are its drill-down feature, graphs, and charts."
"We were able to embed the report builder within our internal proprietary systems, improving our reporting capabilities."
"I mainly use the solution for the ease of reporting and for executive dashboards."
"I'm very satisfied with the customer service. And usually, whenever we have any issue or details, we get to the person for the support. I'm really satisfied with the service. Within a few minutes or within a few hours, the support person will be available."
"The solution is known for its robust security features."
"The stability of SSRS has been reliable, with minimal issues encountered during our usage."
"It is scalable."
"The solution's documentation needs improvement."
"It would be nice to use other connectors to link with the data."
"Power BI's administration could use some work, and the user experience needs to improve because it is a client-based tool. If you want to generate a model or report, you need to use client tools, but client tools are limited for end-users who don't have enough hardware. For example, maybe a client lacks enough memory or CPU power for report generators. If you use a model that requires a massive amount of data, your client will face several problems."
"In my opinion, the software is a little bit limited in terms of the flexibility it offers, with regard to the design of the visualization."
"Microsoft BI could improve by allowing large-size data sources. We have large data sources, and we have problems loading them in Microsoft BI."
"I'm missing collaborations functionality to operate or to work connected with multiple people on a data source or on virtualization. There should be more collaborations functions, such as in Confluence. We haven't explored the solution sufficiently in this area, but at this time it doesn't look sufficient."
"They asked you to pay if you want to synchronize more than eight times, you would have to go to a Power BI enterprise license, which is much more costly."
"The solution could improve by providing more free visuals. A lot of them are very nice but you have to purchase them."
"Microsoft SQL Server Reporting Services needs to improve performance."
"It doesn't have quite the flexibility of a Tableau or something like that. Many users are more comfortable with Tableau and I'm not quite sure why that is right now, but it seems to be the case."
"In this solution, the cost should be reduced for the enterprise edition."
"Technical support is in minor need of improvement so that they can solve problems in a more timely manner."
"The setup is difficult because you have to install different servers."
"Sometimes, we need to make sure that the configuration stays consistent across the reporting instances. They all connect to the same database. So, it shares that same backend, but the reporting services itself can also be configured. On the application level, for reporting level. And it is, based on my own experience, it is a manual effort to make sure that the reporting servers are configured the same across the environment."
"I would like the solution to add the scheduling feature for reports."
"It is not easy to integrate the product with other tools in the market."
More Microsoft SQL Server Reporting Services Pricing and Cost Advice →
Microsoft Power BI is ranked 1st in Reporting with 297 reviews while Microsoft SQL Server Reporting Services is ranked 7th in Reporting with 16 reviews. Microsoft Power BI is rated 8.0, while Microsoft SQL Server Reporting Services is rated 7.8. 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 Microsoft SQL Server Reporting Services writes "Offers useful templates but needs to improve the connectivity offered". Microsoft Power BI is most compared with Tableau, Amazon QuickSight, KNIME, Domo and Oracle OBIEE, whereas Microsoft SQL Server Reporting Services is most compared with TIBCO Jaspersoft, Tableau, SAP Crystal Reports, Oracle OBIEE and IBM Cognos. See our Microsoft Power BI vs. Microsoft SQL Server Reporting Services 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.