Microsoft Power BI vs Microsoft SQL Server Comparison

La curva de aprendizaje rápida para usuarios que ya trabajaban con el entorno Microsoft ( MS Excel, SQL Server, Azufre, etc.)

Para trabajar de manera enterprise y con Big Data, es necesario tener conocimientos sólidos de otros lenguajes por fuera de los propios de la herramienta ( C #, JS, Python, R) por lo cual se necesita un equipo de desarrollo con más seniority

Nice job Microsoft. This easily integrated data from a SQL server. Great alternative to other more clunky data tools such as QlikView. Easy to share with coworkers through AD authentication.

Requires a gateway to keep data refreshed real time.

For any executive it is always important to have the information in the moment when it is needed. Power BI helps you to achieve this and easily connects to the data repository, the system already includes a variety of informative graphics that help to present the information of a very visual way In addition the system allows you to delve into the data to see the detail of the origin.

This tool is so powerful that I can not think of any disadvantage in its use, but if I had to say something it is that you have to be very careful in the base of the information so that the reports that the system transmits are reliable, if the information has problems that is reflected in the reports that the system gives you.

Power BI is the best reporting service to populate any data in multiple types of graphs, tables, charts.

Power BI is sometime difficult for live reporting via SQL Server.

Easy to use, get Desktop designer tool and cloud-based server. You also can choice on-premised Power BI server for your local deployment needs.

Because Power BI Report Server(On-Premises) must use SQL Server Report Services and SQL DB, you must understand how to manage SQL SSRS. At right now, this license model is strange for understanding. I think Power BI Services's license model(Cloud based) is very easy to understand.

The graphics are attractive and easy for any viewer to make sense of. The features allow you to display information in a variety of ways and quickly analyze trends. We used it in conjunction with Microsoft SQL Server and it worked fine.

It will take some time to learn how to use the software and explore its functions. When I first started working with Power BI two years ago, the documentation provided by Microsoft was not very helpful and there didn't seem to be a large user community. Hopefully, this has changed for the better.

It's easy to use, better than biggest alternatives (I've tested Qlik and TableAu) and I've chosen Power BI

There need some expertise with other Microsoft Office products, and a little programming skills / SQL

What I love about Microsoft's Power BI is that it makes data visualization easy as it has many templates and functionalities from creating a pie chart to showing data on a map. It does all of this while working with many apps such as Microsoft SQL Server, Visual Studio, Etc.

What I like least about this software is that it's "Tooltips" is not as easily editable as other softwares like Tableau.

The tool takes a little to get used to but fairly straightforward. It is tightly integrated to SQL Server and has excellent security functionality. Availability and cost of Power BI make the product very attractive. It supports the complete Microsoft stack. Supports third party developers for analytics and image tools.

Microsoft manages the certified training programs which are terrible. Power BI does not bring anything new and interesting graphical to the market - bar charts, pie charts, line graphs . . . Microsoft is way behind other comparable products.

1.Good tool to create Business Intelligence reports 2.Dashboard visualizations are best 3.Easy to integrate with various data sources like clouse,sql server ,oracle,xml,csv ,OData feed etc

1.Scope i very big the so if you want to achieve small functionality it is becomes very difficult

Microsoft has integrated Power BI very well with Excel, making it easy for advanced Excel users to analyze data without having to write SQL queries

Databases with large amounts of data experience much slower performance than smaller datasets

No pros were added to this review

No cons were added to this review

It has tons of connectors and it is really well connected with the most common databases both in the strict sense of the word, like SQL Server, MySQL, etc and in a broader sense, like JIRA or SAP

It is very complex to master and it has a very perverse way to manage data. It is impossible to use it out of the box, and you need to learn how to code it to do what you need

Its feature to connect multiple data sources like a csv file, SQL Server database, cloud services like Azure is pretty awesome. Also it has the built in data analytics features with interactive visuals to visualize the data effectively and efficiently

Power BI is not capable on high data. Like if you need to import high volume data into Power BI then its gets slow and he data is not loaded efficiently.

Cost. This is definitely great value for the money and beats most of its competitors. Data visualization capabilities are very strong and it integrates to a lot of databases. Microsoft regularly add new features and functionality and since it is a Microsoft product, the integrations are seamless into Excel, etc. No need to know SQL.

I'd imagine this would be difficult for a non-Excel user to figure out. Not great at handling huge data sets (or data sets that aren't completely cleaned up or checked for accuracy) - I'd recommend Sisense over PowerBI for that. Not a lot of capability to customize/personalize the tool.

You can manage data and alter data easily. User interface is very familiar to anyone who uses office applications. UX is a kind of weird. Some graphics are useful.

I can not say it's very easy to use. You can not customize virtualization items that show data related to tables or other data sources. For example, if you want to use "gauge" item from virtualization windows, you will see percentage of number on it. If you know pivot tables on Office Excel, you do not need Power BI.

To start it is important to tell that Power BI, as is part of Microsoft business suite, is linked to other tools as Excel and SQL Server. Therefore the integration of the data of the company in one place is very easy. Power BI has a very good capabilities for report visualization, having more than 10 different kinds of charts you are able to represent the data of the company in a huge variety of formats making analysis pretty fast and easy. Let me tell you the database connectivity capabilities are outstanding with excellent cloud based connections as well.

Using Power BI will be challenging if you are not a powerful Excel user. It has no way to clean up wrong data. The system assumes the data you are pulling in has good quality. Power BI sometimes is too complex to use because has many options to handle data and setting it for the first time becomes hard.

This program is great for for when you have an Excel file as a data source, it is quick to interpret and provide suggestions of data visualizations which is impressive.

It would be helpful if SQL could be used as far as writing selections.

Ease of use. Regular feature updates. Custom visuals. Slicing and drill down features are really good. Predictive line and dashboard insights is really cool feature.

To share reports, we need to publish to MS Cloud. We cannot publish direct query data set without installing a gateway in the server.

How incredibly powerful this software is. It allows you to manipulate data in any imaginable way, and let the user transform it and visualize it in many different ways, along with the huge amount of external integrations, custom visuals, and a nice community.

Being honest, it's incredibly hard to learn how to use it at its full potential. For new users, besides the initial setup, it's not intuitive at all, and even for experienced users in tableau or alike, it might be challenging, but those are due to the incredible functionality it offers.

It is able to take in multiple data sources and churn out reports in a visually pleasant form for ease of viewing. It greatly improves efficiency when we do not have to resort to using Excel to generate the exact data model we want. The ability to utilize SQL Server Analysis Services for our needs is very welcomed. I especially like the user-friendly interface that Power BI provides.

There are some segments and features of Power BI that requires a good amount of time to figure out. To utilize Power Bi effectively, the data has to be cleaned beforehand as Power Bi does not provide such tools.

very important tool to use when you are on a project or you deployed new tool/project to show how successful/unsuccessful your project is doing

it is hard at the start to learn it, especially when it comes to the sql data

Speed of development and integration with different sources as (T)SQL, webservices and flat-files.

It is a bit difficult to see which pricing plan is needed.

Der schnelle Start mit SQL Management und die Erstellung und Administration der Berichte für verschiedene Empfänger.

Die Visualisierung der Dashboards könnte verbessert werden.

The visualizations you can make with minimal experience or effort are astounding. Like with many Microsoft products, the sky is the limit and you can definitely get by without formal training. But if you decide to learn more about it, there is very little you can't do visualization-wise. We can even connect our on-prem SQL database with ease.

While it is easy to get started, really mastering the program can take some time and trial-and-error. It can be frustrating at times to get it to do exactly what you want it to do.

I really enjoy using SQL as it is very widely used and there is a large user community.

I wish that Microsoft would make a clearer roadmap on the furture of SSRS verse Power BI.

Intuitive Interface and great catalog support

It is not very compatible with Power BI

Microsoft SQL Server best tool for manage the database. SQL Server has good interface and easy to use. It can easily handle large database and can process the queries very fast. The best thing is it also offer a comprehensive database diagram to understand the relations between the tables. You can easily connect the SQL database to another BI tool like Tableau, Power BI, etc.

Sometimes SQL Server showing the error when refresh the database. It's also costly product if we compare to others.

Microsoft SQL Server BI offers a full set of tools and functionalities for different phases of a BI solution. Since it is a very popular and widely being used, there are a lot of resources available. Moreover, Microsoft provides tools and services that serves both the upper stream and lower stream of BI services, making the adoption of Microsoft SQL Server BI seamless on existing Microsoft infrastructures.

A lot of tools are not smart enough and requires intense manual work. For example, SSMS can't recognize and auto-pop newly-created tables/views without restarting; SSIS is not able to refresh the metadata on its own when there is underlying table changes; SSRS offers very limited format control for Excel/PDF export.

I would prescribe this product. It is somewhat costly, yet in the event that you have the money to so do, put resources into this. It is anything but difficult to utilize and completes a remarkable activity of examining information.

Except if your information demonstrate depends on an association server, displaying in SSAS won't help with significantly more than uniting different sources into a solitary connection...in which case you either need to keep up a live association or load into memory. So either keep your framework running every minute of every day triple your RAM.

MDX queries are really useful in SSAs queries. Interesting to work with said, ssrs and power bi. Easy analytics tool.

Configuration is not good. It's express version contains limitations. Also database size is limited in express version

Comprehensive functionality - you get database engine, analysis services, integration services and reporting services. All pieces play very nicely with one another. You can easily set up SQL server on premises or in Azure. Very large user community with tons of documentation, tutorials and walkthroughs.

Enterprise edition is very pricey. Anything that you choose to set up in Azure tends to be pricey as well. Overall decent value for the money as long as you stay away from the Azure world. Storage in Azure (even premium storage) is less powerful than even middle-of-the-road SANs.

This software is very easy to configure on single server as a multi-server environment for high availability, performance and so on. It has great integration capability with other Microsoft BI Space like SSRS, SSIS, SSAS, Azure and Power BI. It can handle huge datasets. The Software is available for the general public in different versions like Developer, Enterprise. It is a great database for small and medium-sized companies.

The resource used by the SQL Server requires large memory. It doesn't support unstructured data as well as big data technologies. SQL backups require to be stored on the external storage devices other than the local machine where the software is installed.

1. Much larger dataset processing capability; 2. Much improved performance; 3. Robust analytical functions; 4. new features of columnial index; 5. Strong integrations with SSIS, SSRS, Power BI.

1. I really cannot find any thing i don't like about this software. 2. if there is, maybe i have to compare with other software.

Microsoft SQL Server it's very flexible, it has a great capacity to integrate with many data management software such as ERP or BI.

Like other software, there is a steep learning curve. I know the basics, every day I learn new things about Microsoft SQL Server. It is not a claim, actually this type of situation occurs in almost all programs of its kind.

SQL Server continues to get better all the time. I use it for helping SMBs consolidate their data for BI/analytics for both on-premise and Azure. The product is solid and never have a problem (especially Azure). If you have used any of the previous versions. Due to its long history and wide use, resources are always available to support the product. The security continues to get better and integrates well into Power BI. Over the last couple of years, Microsoft has also added additional connector services which is great for many IT shops.

If Microsoft wants to stay relevant in the SMB world they need to make it more automated, intuitive and dummy proof for individuals in Marketing and other disciplines. The product requires some serious IT support which is not always available. I have never been happy with their Training and certification programs (basically they suck). Microsoft dictates how classes are to be run and lost connection with the evolving world.

It is easy to install. There is also a free Express Edition / Localdb, which has most features of the paid Version. The developer Edition has all Features of the Enterprise Edition. It is very easy to install even several instances on any system. I can solve nearly all tasks, I feel very confident. The documentation is great and it is easy to find answers to questions. It is just my every day tool.

If there are some heavy queries then the whole instance gets down, often even other instances on the same system. I don't understand why it is not possible to limit the effect. Many features which I would like to use are only available in the enterprise edition. But this edition cost much more than standard and I am forced to use only features of the standard edition. Often I am forced to use quite old version, for example 2016, but the current version is 2019. Again the reason is the price. Customers would need to spent more money for the latest version, therfore they force me to develop based on old versions.