Microsoft Power BI Reviews

The main use cases that we see for Power BI are financial reporting, network analysis, structured and unstructured reporting, and self-service. We have just recently completed a pilot phase of Power BI and Qlik Sense, evaluating them against each other. In this pilot, we have had about 50 users in our company use Power BI, but eventually we envision having up to 300 concurrent users.

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.

There's also support for integration of Microsoft 365, which enhances collaboration with all these interwoven tools including email, Teams, SharePoint, and so on.

My main complaint is that the error messages need to be made more clear. Currently, they are either too generic or outright misleading, and finding the real problem is like searching for a needle in a haystack.

Along with that, whenever you encounter an issue and you need to do some troubleshooting, it is really hard to isolate the problem. For example, is it related to your data? Is it related to your report design or your construct? Or is it related to the visuals? Power BI is really not that helpful when it comes to troubleshooting.

My suggestion is that there should be some kind of design validator that says, "Hey, warning! This report (or this set of queries) cannot run fast." There may be a long list of restrictions you need to take into account when it comes to optimization.

I have been using Power BI for nine months now.

It's not exactly as stable as I would like. We have had several service reliability issues as well as service degradation issues, which of course are typical to a sales based context. During those moments, though, it has been pretty inconvenient, especially for the users. Luckily we have not been confronted with that situation in production yet, as it was a non-production pilot setup.

It's not easily scalable for us, in the way that we consider scalability. You have to be careful when considering an upgrade to your capacity plan, which comes with an extra cost. Alternatively, you need to simplify the reports that you have designed with your plan and eventually remodel them to accommodate further usage without unnecessary cost.

Even then, you are confronted with various product limitations or scalability constraints. For example, there is a maximum amount of queries that you can launch simultaneously. Ultimately, you need to remain cautious because it's not a one-size-fits-all approach especially when it comes to the price.

I've used the Power BI support from various locations multiple times and I am satisfied with the help I received.

The current deployment we have relies on SAP BO (Business Objects) which is a vintage version and an aging solution, over approximately 10 years old now. SAP does have a more innovative replacement product, of course, namely SAP Analytics Cloud, or SAC.

We discussed our needs, requirements, report layouts, and so on with SAP and following further deeper analysis, SAP came back and confirmed that they could not realize it in the short term using SAP Analytics Cloud. It would require much more effort, including the integration of a data warehouse and more to reach our goals. And hence, as per SAP's recommendation, we dropped that scenario from our considerations.

It's a sales-based offering so, by nature, it is simple and straightforward. However, the integration options are quite fuzzy and relatively complex when you start to connect to the variety of data sources.

It took a relatively long time of about three months to get everything up and running. The setup took longer than expected, to be honest, but the reason is not only related to the product as such. It was also related to the existing knowledge and capabilities of the IT delivery provider, where multiple gaps were identified.

I designed the implementation of Power BI myself as the enterprise architect. I've been supervising the entire deployment and together with Microsoft product support, we've encountered various issues and discussed various situations on how to manage Power BI.

An example of the trouble we faced was that there were various middleware components that we needed to deploy as well. They were deployed but they were not up to the standards that I had identified. We had to upgrade and then patch them up to avoid that happening again.

As of today, we have a team of eight staff, including managers, engineers, and administrators, who handle deployments and maintenance.

Our license is paid yearly and we have found that we have to be careful not to over-extend our usage in order to avoid upgrading our capacity plan.

Whether I can recommend Power BI depends on what you are searching for with this type of tool. It is not a one-size-fits-all solution.

I would rate Microsoft Power BI a seven out of ten.

We are using the product for some data tasks such as data binding and reporting. That's it.

The customization and management are very easy. 

We have found that the reporting and publishing are great. Sometimes people like to use the report for their teams.

The initial setup is quick and easy.

The solution is scalable.

It's reliable and the performance has been good.

The cost of the product is not too high.

You need to purchase upgraded support separately.

The marketing will need to increase more now. Power BI is a good product, however, from Microsoft, and I'm not getting too much marketing information about new features or anything like that. People don't know the capabilities and they really should.

We find the solution to be stable. There are no bugs or glitches. It doesn't crash or freeze. it's reliable.

The product can scale. It's not an issue.

You do need to purchases specific support in order to get a good amount of attention. If you are a company that needs 24/7 support, you need to pay for it.

The basic support is good, although it is a little slow. 

The Microsoft support model has it set up so that a first call will only get a user to their ambassador. Okay. Their ambassador will not have too much knowledge. They just identify what is the issue then they escalate to their team. Microsoft support could improve their services to attempt to have a first call resolution. Right now, in most cases, the first call resolution is not possible.

We did not use a different solution previously.

Power BI is a fast application. Therefore, the setup is very, very easy. You just license it, sign up, and you can use it.

The pricing is reasonable. It's not overly expensive, although you will need to pay for extra support if you think you will need assistance regularly.

We only looked at Microsoft. We did not consider other options. 

We are Microsoft partners.

I would rate the solution at an eight out of ten.

I am a Power BI technical senior developer and consultant and I use Power BI to provide solutions for my clients.

Everything that's in M Query and DAX is the heart of Power BI because with these tools you can make up for a lot of other missing features. When I say "missing features", I mean it in the sense that, even if you don't have a direct feature to do something, there are quite a few workarounds that you can figure out with DAX and M Query to make different situations work. I think these two are really the soul of the tool because they make a lot of impossible things possible.

There's a lot of room for improvement because Power BI is a new tool and hasn't really been in the market for that long, especially considering alternative tools such as MicroStrategy or Tableau which have been around for more than a decade. Because Power BI is younger than those tools, I feel it hasn't reached a certain level of maturity that comes with time and it is lacking in quite a few areas which I'm hoping will be seen to in the future, given how it has been progressing so far with its new releases.

There is no specific area that I have a problem with. It's just that, with whatever feature you come across, every visual has its own formatting and behavior. What you get in one visual for a feature, you don't seem to get in another.

When it comes to the feature's functionality, that's all fine, but, say, for instance, that you want to go ahead and turn off only the sub totals and not the grand totals. This might not be immediately possible, especially if you are working in a project where your technical solution is the backend site which the users don't quite care about. What they care about is what they see and interact with, and the visuals and formatting (and visual settings) at hand are what really matter to them.

This is where I think standardization really needs to come in. Basic stuff like being able to selectively turn on or off only the sub totals or grand totals. There should be certain formatting options which should be standard across every visual. What options you get here, you should also get over there, for example. These are simple things, but many a time it's something the end user takes very seriously. They generally do not care about what's happening in the background with regard to the calculations and everything else.

In essence, the standard visualizations should have features and options in common with one another, even when it comes to other visualization tools such as bar charts and line charts. These are all pretty basic visualization features, and giving them some standard way to be customized will make them as capable and competitive as what other tools allow you to do. Of course, you can do this if you add your own custom visuals from the library, but when it comes to basic default stuff, they should at least be deep enough in terms of standard customization to compete.

Right now it seems like they're trying to add a lot of features, but at the expense of losing out on the essence of the basics. The basics in Power BI should be equally as good as the basics in any other tool, and in this case I believe it to be a problem of adding more depth to certain features. The width, and variety, of features is not a problem for me. Whatever features are already available need to be deep enough to work with comfortably, and I feel this is where Microsoft needs to direct its focus.

I have been in the BI world for about six or seven years now and for the last few years it's all been Power BI for me.

Their support is a little slow in the sense that when I post a question to them, I don't get a response as fast as I'd like. Unless you're a premium user and you've got a dedicated technical support team — that's a different thing.

When it comes the usual Microsoft bugs, they generally don't come up with solutions too quickly. And many a time they don't even have a running solution; some bug fixes will probably only be part of the next release. Even then, however, the new releases are themselves often not terribly stable. Whenever you get a new feature, you almost know that this one's not going to work as perfectly as you would want it to. So you just have to wait for the next one, and that's what it is. It takes a little while to stabilize. This kind of thing, along with their support in general, can probably be sped up a little bit.

I am certified in MicroStrategy and have worked with it for several years. However, most of the business I am getting lately is all Power BI.

In my experience, everybody is switching from either MicroStrategy to Power BI or Tableau to Power BI. I'm hearing and seeing this going on in the market, for some very good reasons. I'm no longer working with MicroStrategy, but not because I don't like it. It's simply that I'm not getting enough work in that area.

Setup is very easy. In Power BI that's one thing you will find across the board when using it. It is very easy in terms of getting something done. Even complex things can be done in a pretty easy way and there's no complex challenge in it.

The pricing is good. It's pretty competitive because I have worked on a few other tools as well, and Power BI is on the cheaper side.

That said, many times people are attracted by its affordable price tag, but then they see that it doesn't do everything they want and they conclude that that was the reason why it was so cheap. There's a problem with this kind of thinking, because even though it might not have everything, the price is still on the cheaper side compared to other analysis products like MicroStrategy. The complete suite of features from MicroStrategy is very costly, but at the same time there's no doubt that it can achieve a lot.

What you get with Power BI is that you start to find that even simple stuff requires a lot of gymnastics to achieve because there's no in-built, straightforward feature for it and you need to come up with a workaround. There are a few too many workarounds needed for my comfort, but otherwise it's a very good tool and it's one of my favorites. The pricing is competitive for a reason.

If you are looking for tabular reporting, then Power BI is not the tool for you. This isn't something that Microsoft speaks much about, and in my experience, if you want to do tabular reporting then there first has to be something in Power BI which can actually take loads of data and print it out on visuals in a tabular way, which is currently lacking. Power BI is really designed for analytical dashboarding and that's what it does best. For tabular reporting, on the other hand, it's better to just get the data exported out into Excel and do the rest there.

I would rate Microsoft PowerBI a seven out of ten.

I primarily use the solution for the reports. We use it a lot for self-reporting.

We're making a dashboard that can show specific details and can be easily customized. It's very useful for creating dashboards.

The reporting is good.

The solution is stable. 

We can scale it if we need to.

It's a very easy-to-use solution. The product is quite user-friendly.

The initial installation is difficult. 

The pricing is a bit high and we'd like it to be less expensive.

I've used the solution for two years now.

The product is stable. Its performance is good. There are no bugs or glitches. It doesn't crash or freeze.

The scalability is good. If a company wants to, it can expand.

We have about 15 to 20 people that use the solution.

We're not sure if we will expand usage in the future or not. That's still to be decided.

We manage technical support ourselves. We do not need to reach out to Microsoft for help. Therefore, I can't speak to how helpful or responsive they would be.

I found the initial setup to be difficult. It's not exactly straightforward. The deployment might take about an hour.

We use three people for deployment and maintenance tasks. 

We have to pay for licensing. I've paid for a license in the past.

We'd like for it to be a little less expensive.

I would recommend the solution to others based on its ease of use.

I largely work with the engineering and R&D teams. Typically, the data insights and data teams use Power BI for business-related data visualization. However, for me and my customers, most of the tools like Power BI and Tableau are used to do data visualization for the engineering data. That could be even predicting the behavior of a machine, meantime between failure, or tracking of an IoT center data or even the behavior of the fleet management and things like that. In all the engineering use cases where we need data visualization, we use this product.

We have 16,000 to 17,000 or more people who are trained in insights and data. This group uses all the data analytics tools, data visualization tools, BI tools, and all the other tools from a business use cases perspective. It could be market basket analysis, sales reports, and all those kinds of other business reporting.

The solution has been stable.

We've found that the scalability meets our current needs.

It's good for data visualization and analysis. 

My understanding is that the initial setup is pretty easy.

Technical support has always been great for us, as strategic partners. 

There could be more scalability.

Microsoft should offer additional features for visualization and have additional features for slicing and dicing that data. Those would be good to have.

We've been using the solution since Microsoft introduced the solution to the market.

The product is more or less stable. Power BI doesn't have any problem with the stability aspect.

The solution can scale. It meets our needs.

We are dedicated partners. We have a couple of Microsoft architects that are dedicated to us. We have fairly decent support. I don't have any problem with them. If you ask a commercial end-user what kind of Microsoft support they get, in that case, you might get a disappointing answer. For us, we are satisfied.

I work with a services company and we work with a lot of different customers. So depending on which customer, what is that ecosystem, we'll end up using a lot of different BI tools. That includes both licensed and open-sourced software as well. For example, we've used Tableau and Microsoft Power BI.

I am personally not involved in the implementation process, however, my understanding is it's not that difficult to set up.

I don't oversee day-to-day operations. I just have a team that does that for me.

I cannot speak to the exact pricing. Sometimes we, for example, resell some licenses. We are strategic partners with Microsoft. It entirely depends on how the contract with the customers is. Sometimes the customer procures all the licenses and gives them to us and sometimes we resell the licenses. It completely varies from customer to customer.

We have a strategic partnership with Microsoft and a lot of our customers also are Microsoft shops.

We use both cloud and on-prem deployments. It's a mixed kind of a situation, depending on the customer scenario and situation. We have some implementations that are on the cloud and there are some older installations, legacy installations, which are on-prem. That is also giving us an opportunity to move them to the cloud. Most of our customers are looking to move to the cloud slowly and gradually. I anticipate that we will be seeing more cloud-based installations going forward.

There are one-off scenarios where the customer has an interesting mix of cloud platforms. They might have an IoT platform that is deployed on AWS, and that data is coming to the data lake and being visualized using Power BI, however, not necessarily on Azure.

I would rate the solution at a nine out of ten. 

We are a solution provider and Microsoft BI is one of the products that we implement for our customers. It is used for customized dashboarding, reporting, and self-serve analytics, on a broad scale in enterprise.

The amount of customization that you can do is good, and it's relatively straightforward to do. People with limited experience in terms of coding can implement this themselves. If an organization doesn't have a high amount of skill, internally, then it's something that they can still spin up themselves, relatively well.

It could be changed to the point where it's more suited for self-serve analytics.

The look and feel should be updated in terms of the types of dashboards and graphs that you can produce. They aren't as visual as some of its competitors.

I have been selling and using Microsoft BI for approximately two years.

Microsoft BI is a stable solution.

This product is scalable.

We have dozens of customers that use it.

The Microsoft technical support is not great. You need to have a partner in place that's able to handle these services for you. Customers aren't going to get answers quick enough if they're going directly to the vendor.

I have experience with a couple of other similar products but I'd only downloaded the free versions of these tools to play around with. One of these is Tableau.

Tableau is a solution that would be used more at the enterprise scale. It may be more suitable for analytics. 

These days, from a visual perspective in terms of analytics, dashboards, and customized dashboards, I tend to use Google products.

The complexity of the installation depends on what you're using it for. If you're doing anything relatively complex, such as working with AI or machine learning, then you would probably want to have a specialist service provider do it for you.

We've seen that people are tending to use solutions that compete with it, just because they are easier to automate. From a large-scale point of view, the installation could be simpler.

That said, in its simplest form, it can be used for self-serve analytics.

A company can handle the deployment and maintenance in-house on its own. Or, if they're doing a large-scale project, they might be in need of two engineers.

My customers pay a yearly licensing fee.

From a cost point of view, it's competitive in the enterprise space, although it's not as competitive when you add up all of the additional costs. Things like integrations cost extra and it's probably where Microsoft makes more of the money.

I would rate this solution an eight out of ten.

I mostly work in the oil and gas industry. Microsoft BI is primarily associated with surveillance, optimization, product, and forecasting-related items. While I am not currently using Microsoft BI, I have prior experience, and in my current position, I am guiding the team on a larger scale. I don't use it myself frequently, but I am the lead for that team, and when I do use it, I use it for reporting purposes.

Microsoft BI has a multitude of additional features. Overall it's an EDA tool, from which you can extract, transform, and load data. You can pull reports, visualize them in real-time, and connect them to a variety of other data sources.

When I compare other analytical tools to Microsoft BI, I believe Microsoft BI is far more accurate, and the frequency is also better.

It has additional features, which are very much useful. The most important thing I like is that it is just a data platform connecting to the overall process and it can be utilized in any sector.

Integrating it with the physics build model or the engineering model should be included. When we use engineering models linked to Microsoft BI or Salesforce, the engineering models are from a third-party application.

I have been working with Microsoft BI for the last three and a half years.

We are using the latest update.

I have used it both on-premises and on the cloud.

In terms of stability, I have seen some cases where it is difficult as well as some cases where it is very easy. Overall, it is a stable and reliable product.

It is easy to scale Microsoft BI.

We have a larger team. Microsoft BI specifically, is not limited to any subset or any team. I believe we have 1,000 plus users in my company currently who are using this application.

I have been in touch with the technical team, but not specifically for Microsoft BI. Based on my experience with Microsft technical support, I would rate them a four out of five.

Technical support is pretty decent.

I use a variety of tools, including Salesforce, and I have developed a number of Python-based tools.

The initial setup was simple. However, when I did it the first time, it was complex. Once I understood the process it was simple.

My field was small due to the type of setup required. I scheduled it for one week, during which we also tested.

Definitely, it requires maintenance in terms of quality checking of the data, as well as whether or not the run times or schedules are working properly.

I had some assistance when I deployed the first time, but I am now able to complete the deployment on my own.

In terms of licensing, I've never worked on the contractual side of their license. However, I believe that the number of licenses currently in use is appropriate for our organization. It also adds value to the team. I have never worked on licensing, but I have heard that it is reasonable.

I have not used it on the mobile app. I'm not sure how Microsoft BI works on a mobile app. 

Mobile apps are sometimes third-party apps that are difficult to configure and use. As a result, mobile apps are something that will be required in the future, upcoming data transformation.

Before implementing Microsoft BI or any other analytical tool, we must first understand the domain. Basically, how the data is linked, what data you want to transform, and what output you need for the finished product. Then you proceed with your deployment in a sequential manner. It will be very simple.

I would rate Microsoft BI an eight out of ten. I haven't explored many other items that are feasible or possible, or the analytical part of Microsoft BI's functionality, which I haven't personally used, so there's a gap. Otherwise, I would have given it a ten.

For the most part, clients require dashboards. We are developing quite a few dashboards for them.

The solution has improved a lot within the organization. We can view chunks of data and detailed data at various levels. 

When we have done training in the cloud previously, I have a long experience in BI tools. I've worked on Cognos BI, Informatica, and other tools including QlikView. 

The solution is stable.

The scalability is good.

There are some great automation elements in the product.

It's a good tool and designing dashboards is easy.

In SAP, we have a suite of components here in a single module. This includes forecasting and budgeting. There's also a smart answers section. Whenever we design any chart or something, the tool provides some information regarding that data. That would be quite a good feature that could be included in future versions of Microsoft BI.

The licensing could be a bit better.

You do need to do some hard coding for certain things in Microsoft BI.

I've used the solution for about one year.

The solution is stable. There are no bugs or glitches. I haven't had issues with it crashing or freezing.

The scalability is great. If you need to expand the product, you can do so. You can easily add more users. 

I'm not sure how many users are using the product. 

Technical support is great. I've worked with them before and have been happy with their level of service. 

I've previously used Cognos BI. I've also had the opportunity to work with SAP.

I haven't got any opportunity to install any Power BI system. That said, for tutorial purposes, I have installed the desktop version in my system. It was very smooth.

It took 30 to 40 minutes for me to install the desktop version. During my learning phase, I prepared one dashboard. Similar to when I worked on Cognos BI, there were some features that we have to hard code and incorporate manually. There is some automation in Power BI. For example, if we are designing some interactive things we have to write code possibly. Still, even having to write code, in Power BI, was a very smooth experience.

We have people on our team that can handle maintenance tasks. 

We had a team of five to six people that handled the implementation in-house.

The client is continuing to use it, likely due to the fact that they see some sort of ROI. However, I don't have exact metrics. 

I'd prefer if the licensing was a bit better.

The customers need to pay the licensing fee. I can't speak to the exact pricing for their contract.

Typically, the solution architect is the one who decides which tool to use. However, we also were there and had a brainstorming session before choosing the tools. We did look at open-source options. At the time I prepared one checklist comparison between all the tools available in the market. Those included SAP, QlikView, and Tableau.

We are an integrator and a partner. We are providing support activities to one of our clients.

I would rate the solution at an eight out of ten.

We are a consultant company so we use the many tools, just for our customers. However, we have professional services on, for example, Microsoft Power BI.

The initial setup is easy.

The solution is cloud-native. 

It works well with Microsoft products. 

The licensing is very simple.

We find the solution offers good stability.

You can scale the solution if you need to. 

Technical support has always been helpful and responsive.

Pricing is quite reasonable.

They should improve the connector to on-premises data. Microsoft Power BI was born native on the cloud, however, it's quite difficult when it has to connect to on-premise data sources. You have a gateway. It's not very easy.

The solution offers good stability. There are no bugs or glitches. It doesn't crash or freeze. It's reliable. 

The product scales well. If a company needs to expand it, it's not a problem.

We use a couple of professionals from Microsoft directly for our clients, and we are really satisfied with them.

We use SAS BI and Microsoft BI. I prefer Microsoft BI as, from a licensing point of view, it's easier as it's a per-user licensing. If Power BI is the right tool for companies, it's a shorter time-to-market approach to business intelligence.

The initial setup is very straightforward. It's not overly complex or difficult. A company should have no issue with the process. 

We find the licensing to be very straightforward. It's easier to understand than other options on the market. 

The pricing is fairly inexpensive. It's not a costly solution.

We have a business relationship with Microsoft. We are a Microsoft Gold Partner for cloud products. In the past, we've used a lot of Microsoft products and also some of our clients have used them directly.

I'd rate the solution at a nine out of ten.

I'd advise that new users should take care of the technical architecture in order to connect in the right way to the data sources to extract data.

We have many use cases, from creating full ETL workloads for supporting some dashboards to only building dashboards by themselves. For example, there is one stage where we had to do some data integration from several sources to assess the quality of the data that we are consuming for our projects. We had to ingest data and convert it using Power BI, which is useful but isn't the best ETL tool, and I understand that that is not its purpose. Finally, we built out a schema model and built reports upon that. It's a full project. 

We also have another project, where we are attempting to do some incremental refresh because we are ingesting a lot of data from lake sources and SQL sources. We are doing direct query and applying some optimization from Synapse.

I am currently using the latest version of Power BI.

The most valuable feature is definitely the visual aspect and the DAX capabilities to virtually do anything.

Something that everyone has suggested and that we are currently implementing and testing is the ability to export tables with the same format. That is something many customers were seeking, and right now it is possible to do that. Focusing on table support is a huge opportunity.

One opportunity for improvement would be on the Power Query side. As a consultant, I know Power Query is not the main strength of Power BI. It is not where Power BI shines, but many customers use Power Query to do full ETL workloads for deliverable cookies.

When you try to process a lot of data from one million records, it breaks. The computer runs out of CPU and memory. It's terrible, but I know it's not its main purpose, so that would be my suggestion.

It's stable, but the desktop is not so stable. I have experienced several crashes. I would say there is a lot of opportunity for improvement on that.

A couple of people are needed for deployment and maintenance. You always need a developer who is proficient on Power Query and maybe some other DevOps guy who sets up the pipeline. So, maybe two people at most. It's very easy.

Scalability on the ETL side is not so good. When you run the workloads on service, you can fail almost anything, but it's not exactly the best for scaling.

On the virtualization side, I would say it's good.

I haven't actually needed much technical support. I know there are forums and people respond, but I haven't really sought that out. There is so much documentation online, there are books online, and there are YouTube channels from guys that provide solutions to issues and to some other stuff. The community is very proficient.

It is very easy. Even non-IT professionals use it and deliver value to the company.

I would rate this solution 8 out of 10. 

My advice is to just jump right into it, download the Power BI desktop and start looking at YouTube channels. There are lots of people who have made wonderful things on YouTube.