Microsoft Power BI Reviews

Microsoft SSRS is a fantastic means for end users to access, run, and schedule delivery of reports. - Core functionality is simple to use for business users of all skill levels - Report models even allow end users to adjust their own reports using a model of your data - Report builder provides an even easier method for users to build their own reports - Report data can even be scheduled for periodic delivery with the report data as an attachmentMicrosoft SSAS is one of the best BI suites on the market. It is also one of the least expensive, and the features bundled rival competitors with prices many more times as expensive. - This feature is one of the most exciting areas of database technologies today - Very powerful and relatively easy to use when compared to other Bi suites

- Active Directory authentication requires an additional login for users without Internet Explorer - Learning curve behind any business intelligence package is quite steep - Price of the SQL Server bundle is potentially cost prohibitive for smaller businesses

I am quite passionate about the SQL Server suite of tools, and am a fervent user of SSRS. I use SSAS less, only because I am focused more on administration and have not moved into the SSAS space - yet. I am looking to head into the BI arena later on this year, and SSAS is my BI suite of choice!

I have been a professor at a program mastery at UISEK University for the past two years where I teach students how to use these tools.

Being able to transfer data with the Power Query feature is great for teaching with about one to two hundred rows of data. I am also able to see the relationship between multiple tables and create various sheets and dashboards.

The Power Query feature needs to be improved to handle large amounts of data. This feature is also slow for large data transfers making it better to use some kind of script.

Additionally, in the next release, I would like to be able to export thing, such as charts, as a PDF.

I have been using this solution for two years.

We use Power BI in cloud solutions in other systems. There are lots of products in our environment that work with Power BI. One use case is we use it to track the real-time sensor data to Power BI using Azure.

We have lots of customers. We make premium subscription projects for them. We have a Tableau portion. We are also Tableau partners and resellers. As a company, we make lots of Tableau projects. 

The most powerful site of Power BI is the cloud site. You can do everything in power BI. There are lots of things that the solution provides. If you have a huge data warehouse in the cloud, Power BI fits. 

In some cases, there are some add-ons that you can put together in Power BI - for example, data factory, data bricks, and also data lakes. Some Microsoft solutions work together and are integrated already. You don't need to worry about that.  

If you know what you do, Power BI is a good solution.

The solution is stable. 

The product can scale. 

There are some limitations of Power BI. The front end, for example, is not fancy.

The solution should not be used in some cases. 

The cost of the solution can get high.

There is a strong community around the solution that can help users learn about the product and troubleshoot.

When we compare Power BI with other solutions, we can see there are lots of things that should be done. Some things are there, however, they are not working well. Microsoft puts lots of solutions in one place and declares it a complete solution. However, in the practice, you can see that this STK is not working properly or the request is not giving the same results. You discover that when you open a ticket to Microsoft. They will tell you that they are still in development on that product so it will available in the future. 

When you use the Power BI as an enterprise solution, as a consultant, you find out that the product is not fully ready for enterprise. In that way, we suffer a lot. That said,  every version becomes better.

They need to have an analytics suite of some sort.

I've been working with BI solutions for 20 years. I've been using Power BI for two years so far.

The product is stable. For one of our customers, there are one thousand clients connecting to the same report. Everyone gets their own results and can search them. It needs more power. It can consume a lot of energy. 

The scalability of the product is great. It's on the cloud, which makes it easy to scale. 

There are good communities and groups that can help you troubleshoot if necessary.

I'm also familiar with Tableau.

We are SAP partners and resellers also. We make lots of SAP business intelligence solutions and do business intelligence projects.

Step-by-step implementation is easy. The difficult part is when you enter the infrastructure site. There are lots of Power BI developers, however, they do not know the other cloud environment. In that way, they can only design the front site. That said, they should know the architecture. They should know the other infrastructure and know the data also. If they do, they can produce lots of things. As an example, Microsoft offers a flow integration so that you can create a data flow that consumes the data and give the results to other services. Also, there are lots of things that you can do, however, you need to know the Azure environment in order to do them. 

In some cases, Power BI can be expensive.

We are using the current version of the solution.

I'd advise new users that there are lots of communities and lots of user groups that deal with the product. They should attend them. They should watch the videos about Power BI. It's important to extend your knowledge. If you want to be a Power BI developer, you should also know the other technologies as well.

I'd rate the solution at an eight out of ten.

We use Microsoft BI for dashboards and monitoring tools and dashboards. We mostly use it to produce charts and graphs for our customers.

The solution is easy to use and charts can be built quickly with the tools.

The solution could improve by having more attractive graphical charts.

I have been using Microsoft BI for two and a half years.

Microsoft BI has been stable in my usage.

The scalability of Microsoft BI is good.

We have approximately 2,000 users using this solution.

The technical support is very good, they have been available when we needed them.

The installation is straightforward.

My advice to others would be to compare Microsoft BI to all the other similar solutions and see what fits their use case best. If they're looking for nice looking charts then perhaps, they should compare this solution to the others. If you are looking for a solution that is easy to use and quick to learn then Microsoft BI could be the right fit.

I rate Microsoft BI a seven out of ten.

I used Microsoft BI to develop reports and then deployed them into Microsoft BI web.

Microsoft BI was very helpful for me because I had a huge variety of connections. It is very convenient to build reports, even if somebody has no experience using BI tools or data visualizations. Additionally, the performance is very good when generating reports.

I have been using Microsoft BI for approximately three months.

The stability of the solution has been good.

The solution is scalable.

We have approximately 100 people in my organization using the solution and they are mostly managers.

We used the solution on a daily basis, we were using it extensively.

I have used Tableau previously.

The initial setup was very easy to complete and it took approximately 30 minutes.

We did the implementation of the solution using two technicians.

The current licensing model that Microsoft BI has is expensive. My customers have told me the cost is approximately $20 per user and this can get expensive fast. There should be a one-time purchase option if the customer has a lot of users.

I rate Microsoft BI a nine out of ten.

On-premises

I use Microsoft BI for my own projects that are related to integrating with Excel datasets. I use the visualization and graphing functions, and I have tried using the Python integration.

The most valuable feature is integration with Python.

The integration with third-party products could be more stable.

I have been using Microsoft BI for approximately one month.

Microsoft BI could be a little more stable.

We have approximately 10 users. I don't expect that we will expand our usage or continue using this product.

I have not been in contact with technical support.

There is no complexity in the initial setup. It takes approximately 15 minutes to deploy.

There are twenty people in the team that handles the deployment and maintenance of our solutions.

In summary, this is a good product and I recommend it.

I would rate this solution a nine out of ten.

On-premises

The interactive reports, DirectQuery and integration with the other Microsoft services are valuable features.

There needs to be support for more data sources in DirectQuery.

DirectQuery is a method of connecting your data directly, i.e. any changes in data source will reflect in report immediately. (This is very great feature if you are doing live analysis of your data). As of now there are limited number of Data Sources such as SQL, SQL Azure, which are supported by Power BI with DirectQuery. Although Microsoft keeps working on adding different data sources in DirectQuery (currently only six data sources in this method and three more in Preview), that's why I feel that still DirectQuery (method of connecting your data) has more room for improvement because there are many other data sources that are commonly used by different organization like (MySQL, Access, etc.)

I have used this solution for two years.

In the beginning, we did encounter some stability issues; now, Microsoft is doing great things to make this product more stable and enhanced.

We were using SQL Server Reporting Services (SSRS reports), now we are moving towards Power BI due to its Publish on web part, as well as the interactive cross-filtering throughout all the visuals (i.e., if you need).

The setup is easy. It is very easy to use. If you are an Excel and SQL user, then it is very easy to get a grip on this product.

We tried Tableau. Although Tableau itself is a great product, we chose Power BI due to its pricing and Microsoft's focus to make it a better product.