Try our new research platform with insights from 80,000+ expert users
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.

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

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: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Ed Waslosky - PeerSpot reviewer
Director of Supply Chain Management at Intricon
Real User
Allows you to add information to the reporting information and expand upon it, but you can't share reports with others unless you have an additional package
Pros and Cons
  • "The flexibility of the program is valuable. We are able to add other information to the reporting information and expand upon it."
  • "We found out that you can't share a report with others unless you have an additional package. That caught us off guard. It came as a program that somebody could go in, build a report, and show it, but you can't share it without having additional licenses."

What is our primary use case?

We're using it for sales information and production information. Pushing a report into Power BI makes it easier to use and a little bit more powerful.

We're using the most recent version of the solution.

What is most valuable?

The flexibility of the program is valuable. We are able to add other information to the reporting information and expand upon it.

What needs improvement?

We found out that you can't share a report with others unless you have an additional package. That caught us off guard. It came as a program that somebody could go in, build a report, and show it, but you can't share it without having additional licenses.

For how long have I used the solution?

We've had Microsoft BI for about two years, and we are using it currently. It's a part of Microsoft Teams.

What do I think about the stability of the solution?

It's stable. 

What do I think about the scalability of the solution?

I don't know if it's scalable to the point that we want it. It seems to fit where we have it. We haven't really looked at its scalability. We have other tools, but it works well for what it's doing today.

There are roughly half a dozen users of this solution, and it has sales-related information. There is one driver, and she merges the information. So, there aren't too many rules at this point.

We don't have any plans to increase its usage at this time.

How are customer service and support?

It has been good.

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

That would've been Excel. So, it isn't a switch; it is growth.

How was the initial setup?

It was easy. We had a good understanding of being able to map two programs together. We had a little training, but otherwise, it was good.

The program installation took a few days, but it took weeks to make the intelligence and the company information look right.

What about the implementation team?

We did it ourselves. We had an individual who worked with it in the past. She picked it up very quickly because she was already trained.

We don't need anybody specific for its maintenance.

Which other solutions did I evaluate?

We didn't evaluate any other options. The use of Power BI just came with the program, and we installed it. We weren't looking for something different. It just was there for us to use.

What other advice do I have?

My advice to others who are looking into implementing this product is that it is important that they understand their information. They have to understand how the program works, but they also have to understand their information for it to work better.

I would rate it a seven out of 10.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Buyer's Guide
Microsoft Power BI
September 2025
Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: September 2025.
869,566 professionals have used our research since 2012.
PALAK SURI - PeerSpot reviewer
Senior Software Engineer at Eurofins
Real User
Fetches data from one server to another
Pros and Cons
  • "It is more user-friendly compared to SSRS."
  • "The only concern I have faced with Microsoft BI is the time it takes to find out an issue and rectify it."

What is our primary use case?

We use Microsoft BI to fetch data from one server in SSMS to another server.

What is most valuable?

I find many of the features of Microsoft BI valuable, in particular, I use the data flow tasks, look up and incremental loading of data. They have also introduced Hadoop in the control flow task.

I have created particular dashboards for a specific project so that I can show the clients the data related to their needs. Being able to show them a visual of the percentages in a pie chart has been very effective.

What needs improvement?

The only concern I have faced with Microsoft BI is the time it takes to find out an issue and rectify it.

In my last project, I worked with SSMS as my source and Oracle as my destination. This meant that there were certain compatibility issues between the two. I recommend for incremental load that Microsoft BI can include one task to overcome this concern.

For how long have I used the solution?

I have been working with Microsoft BI for six years.

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

Most of my experience was with MS BI, with Power BI the difference is mainly in the report sections. It is more user-friendly compared to SSRS.

What other advice do I have?

If you are not comfortable with SSIS, SSRS, and SSAS, there are many tutorials available for MS BI, especially if you are new to the solution.

I would rate Microsoft BI an 8 out of 10.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Ariful Ambia - PeerSpot reviewer
Executive Director at a manufacturing company with 5,001-10,000 employees
Real User
User-friendly and can deal with all kinds of data but doesn't support all data
Pros and Cons
  • "The initial setup is relatively simple."
  • "Power BI doesn't support some open-source data sources that are new, such as SnowSQL, Iceberg, or ClickHouse."

What is most valuable?

We are impressed with Microsoft Power BI. The tools seem very easy to use and very interactive. People love to see us reinforcing it, especially the top management. They're okay with that. We are exploring Supersets. 

It's user-friendly.

The most important thing is the developing version is free. Only the online version you have to purchase. That is one of the key advantages we are getting. We can reduce the internal costs that way. 

It can take in all kinds of data to analyze. 

It's very comparable to other solutions on the market.

The initial setup is relatively simple. 

What needs improvement?

Power BI doesn't support some open-source data sources that are new, such as SnowSQL, Iceberg, or ClickHouse. Those are the data sources I didn't find in Power BI. Those data sources cannot be connected to Power BI. You need third-party support for that. This is the one key problem I have with Power BI right now.

For how long have I used the solution?

We have various departments in our company. While some departments have used it for maybe two years, my particular department has only used it for about a year. 

What do I think about the stability of the solution?

This is a stable product. I found, once, in the middle of the work, it shut down or something. However, it is stable. When I put some of the reports in the Power BI cloud version, everything worked fine. I was able to get the report data. 

What do I think about the scalability of the solution?

As long as I can scale my data, I can scale the product. I just put my data into Power BI and do what I need to do. 

The data solution we have is open source. The whole team is working on it, and that's a team of 15 people. The number of people that are actively writing and reporting is maybe six or seven people. Maybe two or three people seeing are seeing report deposits and getting the outcomes. 

How are customer service and support?

We don't have any technical contract with anyone, whatever the problem comes up, we can solve it ourselves. In my country, I personally don't know anyone who is actually, is smart enough to show us anything extra that we don't already know.

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

We are exploring Power BI, Microsoft Synapse Analytics, and some BI features on Azure

We previously used Oracle BI. It's a good tool. Oracle BI is more for the enterprise, big enterprise, for big control of data security and can get into how you control your people, who can see what, et cetera. The downside is, it is very old. You will not get the very latest tools or visuals in Oracle BI. That, we can easily find in Power BI.

How was the initial setup?

The implementation process is relatively easy. One the junior developer can learn the process in maybe one or two days. He can catch up on Power BI and how it works. It is straightforward, I would say.

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

We do have a license for the product. 

We purchased a few licenses for the top bosses who want to see the reports on the run, on their own PC, laptop, or mobile. We purchased a few licenses for the developers as well. other than that, no need to purchase a license.

What other advice do I have?

We have both on-premises and cloud versions. The advanced team who has actually been using it for around two years have an online version. They're putting the data online and showing it. I cannot say exactly what they do. However, on our side, we do not use an online version. We have the three versions that we are using now that are on-prem. 

Overall, it's a good solution. However, there are a lot of other really great similar solutions you can use as well.

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

Which deployment model are you using for this solution?

On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
IT Enterprise Architect - Partnership at a consultancy with 51-200 employees
Real User
Offers many ways to connect with data sources and collaborate, but a pain to troubleshoot
Pros and Cons
  • "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."
  • "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."

What is our primary use case?

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.

What is most valuable?

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.

What needs improvement?

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.

For how long have I used the solution?

I have been using Power BI for nine months now.

What do I think about the stability of the solution?

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.

What do I think about the scalability of the solution?

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.

How are customer service and support?

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

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

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.

How was the initial setup?

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.

What about the implementation team?

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.

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

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.

What other advice do I have?

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.

Which deployment model are you using for this solution?

Public Cloud
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
reviewer1236651 - PeerSpot reviewer
Accounting Services Finance Manager M&S at a hospitality company with 10,001+ employees
Real User
User-friendly, offers helpful reports, and has good dashboards
Pros and Cons
  • "It's a very easy-to-use solution."
  • "The initial installation is difficult."

What is our primary use case?

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

What is most valuable?

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.

What needs improvement?

The initial installation is difficult. 

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

For how long have I used the solution?

I've used the solution for two years now.

What do I think about the stability of the solution?

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

What do I think about the scalability of the solution?

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.

How are customer service and support?

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.

How was the initial setup?

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. 

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

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.

What other advice do I have?

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

Which deployment model are you using for this solution?

Public Cloud
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Director, IoT and Connected Products Portfolio at a consultancy with 10,001+ employees
Real User
Great data visualization and analysis with helpful technical support
Pros and Cons
  • "My understanding is that the initial setup is pretty easy."
  • "Microsoft should offer additional features for visualization and have additional features for slicing and dicing that data."

What is our primary use case?

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.

What is most valuable?

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. 

What needs improvement?

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.

For how long have I used the solution?

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

What do I think about the stability of the solution?

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

What do I think about the scalability of the solution?

The solution can scale. It meets our needs.

How are customer service and support?

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.

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

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.

How was the initial setup?

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.

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

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.

What other advice do I have?

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. 

Which deployment model are you using for this solution?

Public Cloud
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
reviewer1755777 - PeerSpot reviewer
Technical Analyst at a energy/utilities company with 10,001+ employees
Real User
Accurate, with good frequency, and has a wide range of features
Pros and Cons
  • "ou can pull reports, visualize them in real-time, and connect them to a variety of other data sources."
  • "Integrating it with the physics build model or the engineering model should be included."

What is our primary use case?

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.

What is most valuable?

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.

What needs improvement?

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.

For how long have I used the solution?

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.

What do I think about the stability of the solution?

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.

What do I think about the scalability of the solution?

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.

How are customer service and support?

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.

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

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

How was the initial setup?

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.

What about the implementation team?

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

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

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.

What other advice do I have?

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.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer. Partner
PeerSpot user
Buyer's Guide
Download our free Microsoft Power BI Report and get advice and tips from experienced pros sharing their opinions.
Updated: September 2025
Buyer's Guide
Download our free Microsoft Power BI Report and get advice and tips from experienced pros sharing their opinions.