We performed a comparison between Microsoft Power BI and SQL Server based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Tableau, Oracle and others in BI (Business Intelligence) Tools."Reporting is the best thing about Power BI. And it could help improve decision-making in many ways. Power BI is flexible and easier to use compared to tools."
"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."
"It is in the cloud, which makes it easy for mobile access of reports and data."
"Many of my customers already use Microsoft products like Office 365, so I often propose Microsoft Power BI because it integrates well with all the standard Microsoft business tools. And it's the quickest tool to implement and start using daily."
"I have found the most valuable feature of this solution is the Natural Language tool."
"The user experience is easy. Users get familiar with it quickly."
"Microsoft BI's initial setup is very straightforward."
"I like data modeling. You can connect with your database, which is quite useful for me. It is a good tool if you have a large amount of data and you want to gather different data and interconnect it. The Power Query functionality is quite an interesting feature. If you have a query in Excel, you can also copy your query and run it in Power BI. Its dashboard is also very nice and not complicated. You don't need to be a developer to be able to use it. I am not an IT guy, and it is quite easy to use for somebody who is not an IT person."
"The support from Microsoft has been good."
"The most valuable aspect is the ability to utilize jobs and various functions to accomplish specific tasks, which cannot be achieved with standard procedures alone. This allows for a combination of features and functionalities to be employed."
"The documentation and manuals are very good."
"SQL Server's most valuable features are that it is a large number of community resources to help you out. that's one, and then it is quite powerful."
"It is a very user-friendly solution. It is easy to manage the databases and troubleshoot any issue. It is a perfect solution for the volume or transactions that we need to manage."
"The solution can be used for a host of applications."
"SQL Server is definitely easy to use, and with the volume that we have, it's also stable."
"Its speed and the ease of server management are valuable. If I compare Microsoft SQL Server to MySQL, what I like in Microsoft SQL Server is the speed. We are using Microsoft Management Studio for managing our Microsoft SQL Server, and the user interface that I get to work with is also better."
"Trend data and dashboards need improvement."
"It is not yet ready for enterprises. For a big enterprise data model, it is not so stable, and it also doesn't scale so well."
"Some kind of expression wizard, where the user can build a complex expression without any knowledge of DAX, can be a good addition to the product."
"Microsoft BI lacks integration capabilities, so it needs to consider increasing its integration capabilities."
"This solution is resource-heavy."
"The default parameters of the prompt could be improved by including a dynamic option."
"Sluggish performance when handling large amounts of data."
"There is room for improvement in terms of pricing for the solution."
"Scalability is an area that needs improvement, and the deployment is difficult, which why I'm looking for an appliance to deploy it in a much more scalable way."
"The interface of the tool has certain shortcomings, making it an area where improvements are required."
"As SQL server could not support the number of connections we desired, we were forced to go with Oracle."
"Sometimes we experience issues with its stability."
"We need it to support Linux for better troubleshooting flexibility."
"It would be nice if they can reduce its price."
"For a big amount of data, when we are speaking about IoT Segments, and Big Data projects, there are performance issues."
"The licensing costs are very high."
Microsoft Power BI is ranked 1st in BI (Business Intelligence) Tools with 297 reviews while SQL Server is ranked 1st in Relational Databases Tools with 260 reviews. Microsoft Power BI is rated 8.0, while SQL Server 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 SQL Server writes "Easy to use and provides good speed and data recovery". Microsoft Power BI is most compared with Tableau, Amazon QuickSight, KNIME, Domo and Oracle OBIEE, whereas SQL Server is most compared with MariaDB, SAP HANA, Oracle Database, LocalDB and IBM Db2 Database.
We monitor all BI (Business Intelligence) Tools 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.