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."You can learn a lot of things quickly using resources like ChatGPT or Microsoft's own solutions, which are very helpful within the Microsoft ecosystem."
"My primary use is for view of the dashboard."
"Microsoft BI's most valuable features are the user interface, which is easy to use and light."
"My favorite feature is the power query editor, where it can do the data transformations."
"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."
"There is a lot of help and documentation on the Internet, so no special training is needed to use the source code."
"I have found the quick reporting and the conductivity with all the data sources valuable."
"The querying capabilities are the most valuable because they allow me to build many automations. We have many workflows and many databases that we work on a daily basis. They need to be updated quite quickly. In order to not to take much of our time doing these updates manually, I have set up these automations using the systems. The process is just to ingest the data and reprocess it. Every time I click a button, everything is updated in almost real time. It is by far the easiest system not only for querying but also for data modeling, data visualization, and deployment. It is light years ahead of Tableau and even Microsoft Excel to do these kinds of things. It is very easy to use and set up, and it has a lot of videos on the internet."
"The solution is user-friendly, is a robust tool and is always reliable to users."
"It is easy to use and easy to perform a backup."
"Very good security features."
"It is a simple query language. It is consistent across all versions. If you start with an older version, move to the newer version. The same code will still work."
"Having everything in one centralized set of databases is the most valuable feature."
"The most valuable aspect of the solution is that it's integrated with the Visual Studio and also with Microsoft SQL Server Management Studio. It's a tool they have and it's quite easy to use and understand. It's the interface for programming for SQL Services."
"From a security perspective, we have no complaints."
"The solution can be used for a host of applications."
"There is no column-level security in Microsoft BI, and this is a feature that most of our customers are looking for. That is something that should be implemented."
"The UI looks awkward once the graphs have been generated in the console. This is what Microsoft can work on."
"Microsoft needs to provide more drivers to connect other data sources in a native way."
"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."
"here are some limitations with the data models needed to build the report."
"Sluggish performance when handling large amounts of data."
"I think that the product would benefit by increasing the range of visuals and graphics readily available, as opposed to using a third party included as part of the product."
"When there are large amounts of data being processed there are additional tools needed to handle it."
"Only one CPU core can be used. Can’t move a database between servers easily. Can’t use triggers."
"It may be a licensing issue, but sometimes its operating speed becomes slow if we have multiple users. It's lacking some performance, but it's acceptable because we have a heavy load."
"Due to the fact that I'm dealing with the product more as a data analyst, the SQL Server management studio is really relatively primitive compared to other more advanced tools."
"Improvement in SQL Server should focus on lowering the high cost, especially for environments requiring extensive CPU and memory usage like data warehousing"
"The Task Scheduler has a lot of shortcomings. This could be improved quite a bit."
"Debugging from the debugger tool functionality should be enhanced."
"Security is an issue."
"Something that could be improved is the cost because it's very high. That's the only thing I'm concerned about but the technology is good."
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.