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."I like having the ability to connect Excel files as data inputs."
"I have found the most valuable feature of this solution is the Natural Language tool."
"Users already using Excel can generate new reports and dashboards within minutes."
"It provides easy integration with Office tools."
"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."
"One of the most valuable aspects of this tool is its ease of use and the ability to easily share information with others."
"There was a lot of manual work involved with Excel, whereas once we moved on to Microsoft Power BI, it was a cleaner dashboard and it was faster too."
"The most valuable feature is definitely the visual aspect and the DAX capabilities to virtually do anything."
"It's a good learning environment, it's easy enough to learn and understand. Anybody that picks up the language early on will be able to develop in it."
"SQL Server is similar to other Microsoft products, such as BI, they are easy to use. You do not need to have an expensive BD to maintain them. All the useful intuitive features you find in Microsoft solutions you will find in SQL Server."
"Having everything in one centralized set of databases is the most valuable feature."
"It's a very stable solution."
"The main feature of this solution is ease of use."
"Enables us to convert to bigger DBs and more easily move or upgrade between branches."
"SQL is very easy to manage."
"I have seen that this is a very stable product."
"The reporting could be a bit better."
"The product could have better analytics capabilities."
"Adding paginated reports to this tool could be of great help for users who want to move away from SSRS."
"It is definitely a wonderful analytics tool. However, database ETL, data integration functionality would be absolutely perfect in many cases. Currently, it doesn't get the job done and we need to extract, transform, and load the data from faulty data sets into something more suitable for the deployment of the analytics tool."
"The UI is the main improvement that could be made. Specifically, there is something called DAX, in Power BI, which is complicated compared to calculated fields used in Tableau."
"It needs a wizard that covers all its options."
"I have to write scripts to query data for analyzing performance."
"I would like for there to be some type of user manual that shows steps on how to navigate the solution."
"We want to move to Azure, and the solution could be made better to make the process easier for the migration from on-premise to the cloud."
"The solution could be better when it comes to security."
"As SQL server could not support the number of connections we desired, we were forced to go with Oracle."
"Performance could be improved. There could be more support to PHP-based websites and to providing direct plugins for connections, and the related services or application services could be improved."
"There should be more security updates for the product."
"From a DB administrator perspective, I would like to see more space requirements and space capacity history, so that we are able to see which DBs are growing, and by how much per day or week."
"We have had problems implementing a data warehouse using SQL Server."
"With so much data, things can get slow, which is why I would like to be able to understand how to better optimize queries."
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.