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."This is a self-service BI tool, so it doesn't require a huge amount of technical training, knowledge, or a background in BI in order to induct new people into it."
"What I like most is that I can do everything in Power BI that I can do in Excel."
"What Power BI is, is a whole collection of templates of small amounts of data that can be used to do something for a real world project, that can be easily set up and become the business intelligence environment or a data warehouse for a large amount of data, for a real world customer. That's what is remarkable."
"It is a good platform for data analysis, organization, and all of the other interim performances that are necessary."
"Microsoft BI's dashboards are helpful."
"The drill-down capabilities and automatic charts are the best ones. The visualization is also very good. In terms of visualization, no competing product, such as IBM Cognos or any other product, has the same capabilities."
"I have found the best features to be the dashboard creation, graphs, charts, and presentation bar graphs."
"My favorite feature is the power query editor, where it can do the data transformations."
"We can create quality reports in real time."
"I like Microsoft SQL Server Reporting Services' automated reporting feature."
"The initial setup is 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."
"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 SQL Server Reporting Services makes it very easy to get the data whenever we need it."
"We were able to embed the report builder within our internal proprietary systems, improving our reporting capabilities."
"It is a stable solution."
"I think that there should be visuals for financial reporting videos. It should just be a plug and play because there is a lot of coding that goes into it with different clients."
"Most clients have MacBooks. Therefore, they use Tableau as Power BI Desktop is not available for the MacBook right now."
"A lot of people work on Excel, so being able to export an Excel file as part of a subscription would be an improvement."
"here are still better UI designs they can go through. I'm assuming they are focusing more on capabilities rather than look-and-feel designs."
"Its desktop tool is a little bit memory CPU intensive, and it can be improved, but the machines nowadays come with a lot of memory. For the desktop users who are using it on the desktop, we recommend that they do an upgrade. It is a minor issue. We can fix it on the desktop."
"When I create measures, sometimes the error messages aren't clear. It makes me spend more time searching for solutions. I need the error messages to be more specific. So, I would like clearer error messages when creating measures."
"BI is scalable, but there are some problems with limited online storage."
"Automation could be improved and performance enhanced."
"It is not easy to integrate the product with other tools in the market."
"I would like the solution to add the scheduling feature for reports."
"It would be really nice to have better integration between the solution and Power BI."
"Technical support is in minor need of improvement so that they can solve problems in a more timely manner."
"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."
"We have had issues with the refresh interval since we have too many reports scheduled. Microsoft SQL Server Reporting Services is also expensive."
"The setup is difficult because you have to install different servers."
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 14 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.