Try our new research platform with insights from 80,000+ expert users
IvanIvanov21 - PeerSpot reviewer
Expert Data Quality Management at a financial services firm with 1,001-5,000 employees
Real User
Top 5
Stable product with efficient data updation features
Pros and Cons
  • "It offers a lot of information and is very flexible and interactive."
  • "The product’s on-premise reporting servers could support real-time data refreshing capabilities like its on-cloud version."

What is our primary use case?

We use Microsoft Power BI to automate dashboards to present information to our senior management. It helps us extract the relevant data from the dashboard.

What is most valuable?

The product’s most valuable feature is data updates after modifying and refreshing the dashboard. It offers a lot of information and is very flexible and interactive.

What needs improvement?

The product’s on-premise reporting servers could support real-time data refreshing capabilities like its on-cloud version. It would be a very useful functionality.

For how long have I used the solution?

We have been using Microsoft Power BI for about a year and a half.

Buyer's Guide
Microsoft Power BI
February 2025
Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: February 2025.
837,501 professionals have used our research since 2012.

What do I think about the stability of the solution?

The product is stable. It works perfectly, and we haven’t encountered any issues working with it.

What do I think about the scalability of the solution?

It is a scalable product. We have around 100 Microsoft Power BI users in our organization. We are expecting growth in the number of users.

Which solution did I use previously and why did I switch?

We have worked with SAP BusinessObjects. Power BI is better because it has more flexibility and functionalities.

What other advice do I have?

I rate Microsoft Power BI a nine out of ten. I recommend it to users who want to pursue a career in data engineering. It will be very helpful and provides a lot of guides on the Internet, especially on YouTube. They can gain knowledge about its advantages and disadvantages.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
reviewer1709679 - PeerSpot reviewer
Information Technology Architect at a financial services firm with 201-500 employees
Real User
A good solution that supports the Microsoft ecosystem and is easy to install
Pros and Cons
  • "It is very good, and it supports the Microsoft ecosystem, including Excel, etc."
  • "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."

What is our primary use case?

We are using Power BI for reporting.

What is most valuable?

It is very good, and it supports the Microsoft ecosystem, including Excel, etc.

What needs improvement?

We have been using it only for a couple of months, and we are at the beginning of our learning. The area of improvement is difficult to say. 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.

For how long have I used the solution?

I have been using this solution for a couple of months.

What do I think about the stability of the solution?

It is stable.

What do I think about the scalability of the solution?

We are not sure because we currently have a simple installation on the PC, but the idea is to scale it via Office 365 cloud implementation.

It seems suitable for small, medium, and large enterprises. It should be able to scale up. Based on the marketing slides, it should be able to handle all kinds of enterprises.

How are customer service and support?

We have not had any problems, so we had no requirement to use technical support. 

How was the initial setup?

It is quite easy. You just need to install a program and use the connectors and drivers, and that's it. 

What about the implementation team?

I did it myself.

What's my experience with pricing, setup cost, and licensing?

We are end-users, and we don't take care of the prices and accounting. We get a product and pay the fee to our internal service provider, but its price should be reasonable. Otherwise, they wouldn't have bought it.

What other advice do I have?

We are not very experienced in it. So, I don't know if I can recommend it, but we are using it because it is very good.

I would rate it an eight out of 10.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Microsoft Power BI
February 2025
Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: February 2025.
837,501 professionals have used our research since 2012.
Emmanuel Oladinrin - PeerSpot reviewer
Senior Analyst at a manufacturing company with 5,001-10,000 employees
Real User
Reasonably priced, stable, but tab options needed
Pros and Cons
  • "The initial setup is simple to do."
  • "In Microsoft Excel, you are able to have tabs. However, in Microsoft BI you do not have this flexibility."

What is our primary use case?

We have both deployments for Microsoft BI, cloud, and the on-premise.

We are using SAP BI and Microsoft BI to augment the other.

What is most valuable?

Overall Microsoft BI is meeting our needs.

What needs improvement?

In Microsoft Excel, you are able to have tabs. However, in Microsoft BI you do not have this flexibility.

When you create tables in Microsoft BI, you have to create them separately. I can't have several reports packed together in one document, whereby I can have different tabs. You could have several pages of your dashboard, such as a summary page with all the detail. However, in the paginated reports, you don't have that kind of flexibility. This is a major area that Microsoft needs to work on.

For how long have I used the solution?

I have been using Microsoft BI for approximately three years.

What do I think about the stability of the solution?

Microsoft BI is stable.

What do I think about the scalability of the solution?

I have found Microsoft BI to be scalable. We did an enterprise-wide deployment and every one of the 500 people in the company uses it.

How are customer service and support?

I have not needed to contact Microsoft or the local vendor.

Which solution did I use previously and why did I switch?

We use SAP BI in parallel to Microsoft BI currently. Our plan is to replace the SAP BI with Power BI. The phase we are in now is to run both of them in parallel and see how everything is operating before we completely phase out SAP BI. The focus isn't on SAP or Power BI. It used to be our SAP BI solution. Since we started using Power BI, the plan is to actually discontinue SAP BI. maybe by next year we will no longer use the SAP BI.

I switched to Microsoft BI from SAP BI because, in my part of the world, it is becoming the most popular BI tool. Additionally, the ease of integration and our organization is a Microsoft shop. Everything is Microsoft, our databases, our ERP, and we use Microsoft dynamics and Business Center. 

The ease of integration of the BI tool is important for our organization. The scalability and then the licensing are good. If you choose the cloud for SAP BI, you have to spend more. The planning modules sometimes do not come with the package and you will need to spend on it.

It is not necessarily that Microsoft BI is better, but because there are other benefits when you consider Microsoft BI. The ease of integration with the DB and the ERP, and then you look at the overall cost.

How was the initial setup?

The initial setup is simple to do.

What about the implementation team?

We did the implementation ourselves. The solution does require maintenance.

What's my experience with pricing, setup cost, and licensing?

The price of Microsoft BI is reasonable. Other solutions such as SAP Cloud are more expensive.

We pay annually for the license of the solution and we are using a premium license.

What other advice do I have?

The choice of a BI tool is relative. If you have the capacity and the budget, you could decide to use SAP BI. There are other BI tools on the market. Why did we choose Microsoft BI is because of the nature of our business environment, the nature of your data, and many other factors that have to be considered.

I rate Microsoft BI a seven out of then.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
BI Consultant at a manufacturing company with 1,001-5,000 employees
Real User
DAX and M Query makes impossible things possible, but is overall lacking in visual standardization
Pros and Cons
  • "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."
  • "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."

What is our primary use case?

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

What is most valuable?

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.

What needs improvement?

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.

For how long have I used the solution?

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.

How are customer service and support?

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.

Which solution did I use previously and why did I switch?

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.

How was the initial setup?

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.

What's my experience with pricing, setup cost, and licensing?

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.

What other advice do I have?

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.

Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
Chief Technical Officer at Value Partners
Real User
Offers simple licensing, good pricing, and an easy setup
Pros and Cons
  • "We find the solution offers good stability."
  • "Microsoft Power BI was born native on the cloud, however, it's quite difficult when it has to connect to on-premise data sources."

What is our primary use case?

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.

What is most valuable?

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.

What needs improvement?

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.

What do I think about the stability of the solution?

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

What do I think about the scalability of the solution?

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

How are customer service and support?

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

Which solution did I use previously and why did I switch?

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.

How was the initial setup?

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

What's my experience with pricing, setup cost, and licensing?

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.

What other advice do I have?

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.

Which deployment model are you using for this solution?

Public Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer: partner
PeerSpot user
LeandroLucas - PeerSpot reviewer
Head of Product at Bitz
Real User
Stable, easy to set up and scalable
Pros and Cons
  • "The initial setup is easy."
  • "The solution doesn't integrate well with third-party tools."

What is our primary use case?

We use that solution to provide all the KPIs for the software development to manage the business, et cetera.

What is most valuable?

The solution is very helpful for managing the business. 

The initial setup is easy.

We have found the scalability to be quite good.

Stability is excellent overall.

Technical support is good.

What needs improvement?

For managing the business, it's okay, however, as a product management tool, it's lacking. I would like to use BI to provide services for the customers eventually. Microsoft's solution is not good for improving the product for the customers. It's just good for managing the business, and not supporting the customers.

The solution doesn't integrate well with third-party tools.

I'd like them to add to the knowledge base, or at least to offer more documentation about how to use the solution.

It would be helpful if more AI was integrated into the solution. 

For how long have I used the solution?

I['ve used the solution since 2013.

What do I think about the stability of the solution?

I find the product to be quite stable. There are no bugs or glitches. It doesn't crash or freeze. It's reliable. 

What do I think about the scalability of the solution?

The scalability of the product is quite good. If a company needs to expand it, it can.

How are customer service and support?

We get technical support from a third party, however, they offer very good support and we have been quite happy with their level of service. They always have enough staff. 

How was the initial setup?

The implementation process is straightforward. It's not overly complex or difficult.

Deployment took less than a month.

Which other solutions did I evaluate?

I'm also aware of Power BI, which has better integration with third-party tools.

What other advice do I have?

We do not sell Microsoft products. We just use them.

I'm not sure which version of the solution we're using.

We use both cloud and on-premises deployments. 

I'd rate the solution at an eight out of ten. I'd recommend the solution to others as the management portion of the solution is very easy.

Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
Sasa-Vujovic - PeerSpot reviewer
Senior Consultant at ICTPro
Real User
Top 20
Easy to prepare, distribute, and automate reports or connect to databases
Pros and Cons
  • "Many of my customers already use Microsoft products like Office 365, so I often propose Microsoft Power BI because it integrates well with all the standard Microsoft business tools. And it's the quickest tool to implement and start using daily."
  • "Microsoft BI's visualization could be better. Though Power BI's visualization has steadily improved over the years, it's not on the level tools like Tableau and SAS or some of the more expensive products on the market."

What is our primary use case?

As a consultant, I propose something appropriate for my client companies. Mostly, it's some type of ERP, warehouse management, or BI software. It depends on the size of the companies and their requirements.

Small and medium-sized businesses usually need some operations software to cover all the daily necessities. In most cases, I propose some local or regional software for ERP and warehouse management solutions. But for business intelligence and reporting, I typically go with a Microsoft solution.

What needs improvement?

Microsoft BI's visualization could be better. Though Power BI's visualization has steadily improved over the years, it's not on the level tools like Tableau and SAS or some of the more expensive products on the market.

What do I think about the stability of the solution?

Power BI is as stable as every other Microsoft product. It depends on the environment and other factors — it's not just Power BI. But it's quite stable, I think. And it's also on a very high level.

How are customer service and support?

Microsoft has a lot of partners that offer support and help you with implementation. So if you have some issues that can't be resolved by one level of support, you can find someone else in the same environment. I would say that from the partner level, Microsoft support is excellent. But, of course, it depends on how much you want to pay for it.

How was the initial setup?

The complexity of the Power BI setup depends on how much integration you need, the number of different databases you have to connect, and whether you're automating the system. However, setup is relatively easy for a standard environment. For reporting alone, it was easy to set up. So it really depends on the complexity of the environment, not on the tool.

What's my experience with pricing, setup cost, and licensing?

Power BI's price is reasonable, especially if you can put it in some bigger package and use it with other products. The value of a solution doesn't just come from its features as a standalone product. The price should also reflect how easy it's to set up, clean data, and integrate with other solutions. So in that regard, I would say Microsoft Power BI's price is appropriate.

Which other solutions did I evaluate?

I recommend Tableau to customers for some things and Power BI for others. But, overall, you can use Power BI in more ways, it's cheaper, and it has a better pricing model.

What other advice do I have?

I rate Microsoft Power BI nine out of 10. It's widely used and incredibly practical. And it's a little easier to prepare, distribute, and automate reports or connect to databases. Power BI is also useful for warehouse management and data systems in data lakes. It's like a Swiss knife for reporting. So I generally recommend Microsoft Power BI for clients who don't have specific requirements for visualization. Tableau is better in that area. But at the same time, Power BI is also upgrading those features. 

Many of my customers already use Microsoft products like Office 365, so I often propose Microsoft Power BI because it integrates well with all the standard Microsoft business tools. And it's the quickest tool to implement and start using daily. You don't need much training. People can pick up this tool quickly and start using it right away. So I think that's the biggest advantage of Power BI. 

Which deployment model are you using for this solution?

Public Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
reviewer1447362 - PeerSpot reviewer
Manager - Customer Success at a tech services company with 10,001+ employees
Real User
User-friendly and easy to install but isn't very scalable
Pros and Cons
  • "The product is stable."
  • "My data is restricted to my DB and I'm not sure how this would handle an extremely large dataset."

What is our primary use case?

We primarily use the solution for analysis. I have a DB setup that I have. I use that DB for analyzing data, providing business solutions or business insights to the customers. Most of the time, I use Power BI for that or sometimes even Tableau.

What is most valuable?

The solution isn't hard to use. It's very user-friendly. 

The product is stable. 

The product is easy to install.

What needs improvement?

I haven't used the advanced version and therefore haven't accessed all of the features.

The solution isn't very scalable. My data is restricted to my DB and I'm not sure how this would handle an extremely large dataset.

For how long have I used the solution?

I've been using the solution for two years. 

What do I think about the stability of the solution?

The stability of the product is good. It doesn't crash or freeze. there are no bugs or glitches. It's reliable. 

What do I think about the scalability of the solution?

I wouldn't describe the solution as scalable. 

While it is available as an option to most people in our organization, I'm not sure how many people are actually actively using it. I know that I use it myself quite often. 

How are customer service and technical support?

I've never reached out to technical support for assistance. I cannot speak to how helpful or responsive they are. 

Which solution did I use previously and why did I switch?

I also use Tableau. I've used Tableau for about seven months. 

There are other programming languages like Python and R, where they use analytics for graphical representation, or they can use Power BI and Tableau in our company. There are many options.

How was the initial setup?

The installation is not complex or difficult. It's straightforward. 

We have Office 365, which holds Power BI, and therefore I was able to have it easily installed.

I can't recall how long the deployment actually took. 

What's my experience with pricing, setup cost, and licensing?

I personally do not pay for a license. It may be arranged through our company. I have no insights into that aspect of the solution, however. 

What other advice do I have?

I'm a customer and an end-user.

The solution, being on the cloud, is automatically updated, and therefore, you are always on the latest version if you are using it. 

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

I'd recommend the product to those who want a basic tool that can help them study analytics.

Which deployment model are you using for this solution?

Public Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Download our free Microsoft Power BI Report and get advice and tips from experienced pros sharing their opinions.
Updated: February 2025
Buyer's Guide
Download our free Microsoft Power BI Report and get advice and tips from experienced pros sharing their opinions.