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 best thing about this solution is that it is very user friendly. It is interactive in terms of visualizations. It is very eye-catching, and it attracts users. There are a lot of options to visualize the data in different drafts and views. I have used different visualization tools, and I found Power BI to be more efficient in terms of performance, user-friendliness, and ease of use."
"The reports are easy to create."
"Most of the clients I am interacting with are looking towards Power BI because of the cost and simplicities. It provides an entire feature set and a complete solution. It has tight integration with Office 365, Dynamics 365, Microsoft Technology Stack, and datatypes like R and Python."
"Management reporting solution that's very stable and scalable."
"When we are introducing Microsoft BI to our clients, if they're familiar with Excel, the transition phase will be much easier for them. They can easily switch from Microsoft Excel to Microsoft BI. The core foundation or the base technology is the same in both tools. There are a few limitations in Microsoft Excel, and this is where Microsoft BI comes in."
"The product is stable."
"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."
"Power BI allows you to create user defined charts which is really useful."
"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."
"We were able to embed the report builder within our internal proprietary systems, improving our reporting capabilities."
"I like Microsoft SQL Server Reporting Services' automated reporting feature."
"I am impressed with the product's seamless integration. It can work with different databases like Oracle."
"In Microsoft SQL Server Reporting Services, the installation and configuration are easy."
"The solution's features are all just wrapped up in one nice easy package. I don't need a lot of toolsets to get everything I need done."
"Areas for improvement would be the construction of reports and the dashboard budget."
"The interface could be improved."
"The upgrade process could be improved."
"Microsoft BI comes under pressure when there is a lot of data to be crunched. It gets slower and slower, and the functionality becomes a bit of a problem. The performance goes down with data being fed into the system. The infrastructure requirement also increases if you have to increase the performance. This is the area that can be improved in my opinion. Initially, the product is good, but over the years, when data gets accumulated, it becomes a problem unless the old data is kind of archived and is no longer shown on the visualization. It has a feature by using which a user can query for a report through simple questions to a bot. So, if I want to look for the customer share of revenue by geography, I just simply state that in the chatbot. If I wanted it in a pie chart, then you say, "Please show it to me in a pie chart." It comes out well for basic charts. This feature should be improvised more so that people can very quickly get customized reports on the go."
"Microsoft has got a very large repository of all change suggestions which have been raised by the BI community. They keep on adding features that are very widely sought after by the community. We don't focus on product features. We focus on business requirements. To use the solution, we find that existing features are good enough and offer us a very effective solution."
"It should be more user-friendly. There are very small or tiny icons that you need to move very carefully. If you go a little bit up and down, some of the values change. Its user interface should be improved. It should be like Tableau. Its performance is also slow and should be improved. I definitely feel some sort of speed issues with Power BI. The integration of Excel with Power BI would also be good."
"The solution could be quicker at rendering data."
"Technical support could be a bit better."
"There is room for improvement in the pricing model."
"Technical support is in minor need of improvement so that they can solve problems in a more timely manner."
"It would be really nice to have better integration between the solution and Power BI."
"We have had issues with the refresh interval since we have too many reports scheduled. Microsoft SQL Server Reporting Services is also expensive."
"I would like the solution to add the scheduling feature for reports."
"The solution's interface is old."
"The product should improve its performance."
"Tableau is more user-friendly because it doesn't need to do any extra programming. It has drag-and-drop functionality."
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 8th in Reporting with 15 reviews. Microsoft Power BI is rated 8.0, while Microsoft SQL Server Reporting Services is rated 7.6. 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.