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."It is a little easier at buildings charts and graphs than Tableau."
"Tech support is very helpful."
"I like the fact that Power BI lets me use Excel data. At least 90% of my state data is in Excel spreadsheets. Having the ability to just attach a spreadsheet as a data source is very, very important. It's also good for training and teaching. Sometimes you don't always have access to a live production database, so having a spreadsheet with sample data is always nice."
"In the process of using data there is the Extract, Transform and Load (ETL). For extracting we are using another software, for transforming we are using our own coding in C#, and then we use Microsoft BI for loading the information. Microsoft BI displays information very well."
"It gives us, the ability to do a lot of analysis quickly, similar to ad hoc analysis."
"Considering that it's Microsoft, it can be integrated with the Power Platform, which is also Microsoft-based, like SharePoint, Power apps, Power Automate, and Power BI, which is the most user-friendly."
"The most valuable feature of this solution is real-time report tracking."
"I like the downloadable visualizations a lot. I think that they give the user a very nice starting point in creating awesome dashboards, with the right way to tell their data story."
"I mainly use the solution for the ease of reporting and for executive dashboards."
"We can create quality reports in real time."
"We get good support from Microsoft."
"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."
"I like Microsoft SQL Server Reporting Services' automated reporting feature."
"In Microsoft SQL Server Reporting Services, the installation and configuration are easy."
"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."
"It is scalable."
"It needs more graphics and overlays."
"I think that they can add more types of charts because the selection on the desktop version is limited."
"It's quite difficult to learn how to use Power BI."
"The DAX features need some improvement. It's not as easy as Excel. They need more DAX formulas."
"It needs an AI which can choose the appropriate connection strings and provide options for connections."
"I'm looking for something that can make it much easier to incorporate Power BI visuals or dashboards into, let's say, Power Apps – custom Power Apps or anything like that. The most important thing would be to seamlessly embed reports in applications. For example, to have buttons that can be navigated through multiple solutions – from Power Apps to Power BI to SharePoint – via links or something like that."
"They can improve it in terms of rule-based security. Currently, it has very limited rules."
"Actionable insights could be 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."
"In this solution, the cost should be reduced for the enterprise edition."
"The product should improve its performance."
"We have had issues with the refresh interval since we have too many reports scheduled. Microsoft SQL Server Reporting Services is also expensive."
"The solution's interface is old."
"I would like the solution to add the scheduling feature for reports."
"The product could be improved by reducing the time it takes to build and deploy reports."
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 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.