Try our new research platform with insights from 80,000+ expert users
PALAK SURI - PeerSpot reviewer
Senior Software Engineer at a healthcare company with 10,001+ employees
Real User
Jan 31, 2022
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.

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

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
reviewer1247253 - PeerSpot reviewer
DGM IT at a manufacturing company with 5,001-10,000 employees
Real User
Jan 31, 2022
Easy to use solution
Pros and Cons
  • "The data can be accessed from anywhere."
  • "I would like to see a more user-friendly interface with Microsoft BI."

What is our primary use case?

Our company is a manufacturing firm. We have an ERP running in our company. I develop the reports for the business that include sales, stock and production related information. These dashboards are used for analytics purposes by management, enabling them to make decisions regarding the products and business improvement.

We use the BI text file and summarize the information on dashboards to help management make the right decisions for the business. The information includes production figures, running status, forecasts and actual positions. 

We have 10  users of this solution.

What is most valuable?

The most valuable feature of Microsoft BI is the ease of use. The data can be accessed from anywhere. We control access through Office 365.

What needs improvement?

I would like to see a more user-friendly interface with Microsoft BI. Microsoft does regular updates, new features are added every month or so.

For how long have I used the solution?

I have been using Microsoft BI for one year.

What do I think about the stability of the solution?

Microsoft Power BI is stable with no issue.

What do I think about the scalability of the solution?

The solution is scalable.

How are customer service and support?

Overall, technical support is good.

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

Prior to using Microsoft BI, we had been using OBIEE. Oracle is a complicated product with poor visuals. Comparing with Microsoft BI, we found Microsoft to have better handling, graphics, features, and easier development and coding. 

How was the initial setup?

The initial deployment of Microsoft BI was relatively easy. We installed it to the machine and connected it to our Oracle database.

What about the implementation team?

We were able to install the solution ourselves internally.

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

Microsoft BI requires licenses.

What other advice do I have?

Microsoft Power BI is an easy product. If you have some idea about the business intelligence solutions and some technical knowledge, it is a self-deployed solution.

I would rate the solution an 8 out of 10.

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
Buyer's Guide
Microsoft Power BI
January 2026
Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: January 2026.
881,757 professionals have used our research since 2012.
reviewer936228 - PeerSpot reviewer
Manager- Projects at a computer software company with 10,001+ employees
Real User
Jan 31, 2022
Dashboards are easy to use
Pros and Cons
  • "The dashboards of Microsoft BI are easy to use."
  • "Microsoft BI has its own challenges in terms of user interface and how quickly somebody can learn how to use it."

What is our primary use case?

My company uses Microsoft BI's dashboards. We build them for the business and the operations team. We have four to five customers using this solution.

What is most valuable?

The dashboards of Microsoft BI are easy to use.

What needs improvement?

I would like to see the usability improved with Microsoft BI. Microsoft BI has its own challenges in terms of user interface and how quickly somebody can learn how to use it.

For how long have I used the solution?

I have been using Microsoft BI for four years.

What do I think about the stability of the solution?

Microsoft Power BI is stable compared to any other business subjects or any other tools.

What do I think about the scalability of the solution?

Any Microsoft project is scalable. 

How are customer service and support?

Technical support has been good.

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

We have used QlikView. Microsoft BI's dashboards are easier to use and not as complex.

How was the initial setup?

The initial setup of Microsoft BI is straightforward and easy to install. We install ourselves.

What other advice do I have?

I would recommend Microsoft BI. The dashboards are not that complex and are easy to use. 

I would rate this solution an 8 out of 10.

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
Ariful Ambia - PeerSpot reviewer
Executive Director at a manufacturing company with 5,001-10,000 employees
Real User
Jan 30, 2022
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
Jan 27, 2022
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
Assistant General Manager at a computer software company with 11-50 employees
Real User
Jan 25, 2022
Easy to manage and simple to set up with good customization potential
Pros and Cons
  • "We have found that the reporting and publishing are great."
  • "You need to purchase upgraded support separately."

What is our primary use case?

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

What is most valuable?

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.

What needs improvement?

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.

What do I think about the stability of the solution?

We find the solution to be 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 product can scale. It's not an issue.

How are customer service and support?

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.

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

We did not use a different solution previously.

How was the initial setup?

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

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

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.

Which other solutions did I evaluate?

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

What other advice do I have?

We are Microsoft partners.

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

Disclosure: My company has a business relationship with this vendor other than being a customer. partner
PeerSpot user
reviewer1236651 - PeerSpot reviewer
Accounting Services Finance Manager M&S at a hospitality company with 10,001+ employees
Real User
Jan 17, 2022
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
Top 20Leaderboard
Jan 16, 2022
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
Buyer's Guide
Download our free Microsoft Power BI Report and get advice and tips from experienced pros sharing their opinions.
Updated: January 2026
Buyer's Guide
Download our free Microsoft Power BI Report and get advice and tips from experienced pros sharing their opinions.