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."My favorite feature is the power query editor, where it can do the data transformations."
"The solution is very intuitive, you do not need to have too much programming knowledge to use it. Advanced Excel users can use it very easily."
"I like that I can use Power BI to upload data. That is very important for me. The visualization is also convenient and easy to use."
"The good part of it is that you can do whatever you want with it when it comes to building BI. In terms of languages, it supports Python, and it also natively supports R."
"The user interface is easy to work with."
"There is a lot of variety in Power BI. In particular, the visuals are quite rich and the feature set has been growing rapidly in the last two years. Possibly the best part for me is that there are a lot of ways to connect with data sources."
"The flexibility of the program is valuable. We are able to add other information to the reporting information and expand upon it."
"We have found the product to be scalable."
"It's a good option for those that have a lot of Microsoft solutions in use."
"Scalability, cluster ability, ease of use, ease of implementation — these are all great."
"SQL Server is very scalable because we use it across a couple of different types of applications, such as micro-infrastructure setup and server farm."
"The solution has a user-friendly environment and supporting functionalities. It also has great memory and processing databases."
"The backup capabilities are extremely good."
"The solution is very common. It's easy to use."
"The solution is user-friendly, is a robust tool and is always reliable to users."
"For my business requirements, the performance is good."
"People without private emails cannot publish and, frankly, this doesn't allow for easy training."
"Trend data and dashboards need improvement."
"More connections with other systems should be added, which would allow for other integrations."
"I would like to see some AI incorporated into this solution in the future."
"It needs more analytic tools."
"It is too slow. I hope in future it will be a comparable big data tool, such as, for example, Data Lake."
"I think that the solution is harder to use for people who are not experts in data."
"I find the solution to be 70 percent stable."
"Price could be cheaper, and access to reporting tools should be better."
"They can build more performance-tuning tools in it. They can also make the stuff a little more user-friendly and provide the ability to schedule jobs. They can perhaps also streamline it a little bit so that it is not so resource-intensive, which would be helpful. SQL Server has a tendency to consume all the memory you allow it to. If you are not careful, you can basically break your server. I would like to see it having a smaller footprint in terms of system resource consumption. They might want to consider re-evaluating their pricing. It is expensive."
"The stability of the solution should be improved in the next release. Sometimes it is great, sometimes it is troublesome. I would also like data conversion and the code pages to be a bit more straightforward."
"The interface integration could be better."
"The solution could use better governance on the management side, especially around data governance."
"Database support could be improved."
"The reporting services of the solution (SSRS and now Power BI) are the less valuable items of the SQL Server suite."
"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."
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.