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."It works well with SSAS, which we use to generate all different kinds of trending and analytics reports. Sometimes we use Power Query and DAX to build some aggregations on the Power BI side as well."
"My favorite feature is the power query editor, where it can do the data transformations."
"The most valuable features in Microsoft BI are the analysis using the feature drag and drop function. It's very easy to load and use different data sources."
"The best feature of this solution is the way you can plan, communicate, and visualize all the knowledge you extract from the data for the customers. I like the way you can show or visualize the information a client needs to answer a business question."
"In my opinion, Microsoft BI is a low-cost solution, and it could be an interesting solution for a tourism company."
"It gives us, the ability to do a lot of analysis quickly, similar to ad hoc analysis."
"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."
"It's pretty easy to set up the product."
"It integrates well with other platforms."
"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."
"The management studio is probably the thing we use the most for running quick queries and creating quick reports. Quite often, somebody comes and says, "Hey, can you find XYZ?" It is so much easier just to jump in there and run a quick query."
"SQL Server is quite user-friendly. I have experience with Oracle and PostgreSQL, so out of three, I like SQL Server a lot."
"The ease of administration, in general, is the solution's most valuable aspect."
"A valuable feature of the solution is that it is comparatively simpler to manage than Oracle."
"The most valuable features are ease of use and the integration with Single Sign On (SSO), as well as with other Microsoft products."
"It's great that the database engine is always on."
"Microsoft needs to do some more research and development to make it more stable."
"A lot of people work on Excel, so being able to export an Excel file as part of a subscription would be an improvement."
"I find the solution to be 70 percent stable."
"here are some limitations with the data models needed to build the report."
"The handling of the workspaces can be made more granular for user access rights. It can be managed a little bit better in terms of the connection to Active Directory so that we have more granular access rights. I am not sure if this is really possible or if we can solve it differently, but we need a lot of workspaces, and we are not sure how we can deal with it from the access rights perspective."
"The DAX features need some improvement. It's not as easy as Excel. They need more DAX formulas."
"At times, I feel that the system needs improvement in single sign-on, especially for the on-premises side of the tool."
"Its performance and stability can be improved. It takes time to load, and sometimes, it also breaks down for the whole region. Its usability could also be better, and it could also have more connections with different data sources."
"The interface of the tool has certain shortcomings, making it an area where improvements are required."
"Third-party services from Redgate should be built-in to it, like SQL Search."
"The pricing of the product could be better."
"I would like to see better integration between their link server and other platforms, such as IBM."
"It could be more stable."
"From a development perspective, the solution needs to be a lot easier to understand or it needs to be easier to implement API packages for connection pooling so we don't have connection interruptions when, let's say, a hundred people simultaneously access the network on a given system, utilizing a specific or single database."
"The way SQL Server pivots data could be improved. For example, I would like built-in comma-separated pivot and unpivot functions."
"The tool is expensive."
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.