Try our new research platform with insights from 80,000+ expert users
Analyst Operations with 1-10 employees
Real User
Displays information well, simple to install, and low maintenance
Pros and Cons
  • "In the process of using data there is the Extract, Transform and Load (ETL). For extracting we are using another software, for transforming we are using our own coding in C#, and then we use Microsoft BI for loading the information. Microsoft BI displays information very well."
  • "The solution could improve the extraction and transformation of data. For example, you transform the data and then send it to Microsoft BI without having to use your own API. We are only providing the API to Power BI, and then Power BI is doing the job."

What is our primary use case?

We were using Microsoft BI but it could not do what we wanted it to do. Then we moved to an open-source platform, which was Apache Tika, Kafka, and third solution. We ended up moving back to Power BI only to display the information because displaying information with Power BI is better than open-source software. We are not using all aspects of the solution at the moment.

What is most valuable?

In the process of using data there is the Extract, Transform and Load (ETL). For extracting we are using another software, for transforming we are using our own coding in C#, and then we use Microsoft BI for loading the information. Microsoft BI displays information very well.

What needs improvement?

The solution could improve the extraction and transformation of data. For example, you transform the data and then send it to Microsoft BI without having to use your own API. We are only providing the API to Power BI, and then Power BI is doing the job.

In an upcoming release, Microsoft BI should increase the functionality of the solution.

For how long have I used the solution?

I have been using Microsoft BI for approximately six years.

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

What do I think about the stability of the solution?

We were satisfied with the stability of Microsoft BI.

What do I think about the scalability of the solution?

We have 30 users using the solution in my organization.

How are customer service and support?

We are in contact with the support of Microsoft but I have not been in contact directly.

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

I have used other solutions, such as Apache Tika and Kafka.

How was the initial setup?

The initial setup was straightforward.

What about the implementation team?

The solution only needs one person to do the maintenance.

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

There are a few options available for purchasing a license. Typically the number of users you have will determine the price of the license. The more users you have the more you will pay.

What other advice do I have?

The solution has had a lot of changes over the years and it is very good. However, there is more work to be done on extract and transform functions for it to be done properly.

I rate Microsoft BI an eight 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
reviewer1644669 - PeerSpot reviewer
PMO at a consultancy with 10,001+ employees
Real User
Highly performance, easy to use, but needs more data flexibility
Pros and Cons
  • "What I have found valuable about Microsoft BI is its performance and ease of use. The interface is very simple and it is accessible to everyone. If someone is new to this type of solution it is straightforward to understand."
  • "In the future, Microsoft BI can be better by increasing user-friendliness"

What is our primary use case?

I use Microsoft BI for the reports and our displaying the data in different ways. As a project manager, I need to follow the budget and receive confirmation about our projects. We have an SAP database and we follow and check all the budget data of the project including data usage.

What is most valuable?

What I have found valuable about Microsoft BI is its performance and ease of use. The interface is very simple and it is accessible to everyone. If someone is new to this type of solution it is straightforward to understand.

What needs improvement?

The solution could improve by having more options to manipulate the views of the data on the dashboards. I sometimes need to make them myself but there should be more customizable with drag-and-drop elements and filters on that data differently than it was designed. There are filters in the design stage but there are times you need something else other than how it was designed. For example, if you did not have some of the information at the time of the design. Having the ability to design, or request the data from the database as an end-user is very important. It would be beneficial to have more autonomy on the design of the requested data. You are not able to change the fields or the request data because it was done in the backend and you are not able to see how that request happened. Sometimes you need to make your own requests or have different requests regarding the data. We do not have access because we are not administrators.

In the future, Microsoft BI can be better by increasing user-friendliness.

For how long have I used the solution?

I have been using this solution for approximately three years.

What do I think about the stability of the solution?

The solution is stable.

What do I think about the scalability of the solution?

I have found it to be scalable.

We have approximately 1,000 people using the solution in my organization.

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

I have previously used QlikView and Qlik Sense.

What other advice do I have?

I would recommend this solution to others.

I rate Microsoft 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
Buyer's Guide
Microsoft Power BI
June 2025
Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: June 2025.
861,524 professionals have used our research since 2012.
BI Solution Engineer at DataSelf
Reseller
Easy to use for buildings charts and graphs and doing calculations
Pros and Cons
  • "It is a little easier at buildings charts and graphs than Tableau."
  • "It has limited performance capabilities in terms of connecting to large transactional databases, but it is fine for simple and quick queries from Excel spreadsheets or one table. The premium level is going to be more applicable for the higher transaction-level databases."

What is our primary use case?

I've been a consultant, so I've built some reports for some clients. I use and prefer its desktop version. 

What is most valuable?

It is a little easier at buildings charts and graphs than Tableau.

What needs improvement?

At the enterprise level, it is a little expensive. To get the full capacity of integrations, you need to go premium.

It has limited performance capabilities in terms of connecting to large transactional databases, but it is fine for simple and quick queries from Excel spreadsheets or one table. The premium level is going to be more applicable for the higher transaction-level databases. 

For how long have I used the solution?

I've been in the Business Intelligence Industry for about seven years. I use this product off and on.

What do I think about the scalability of the solution?

It is complex to scale. There are just too many things you have to put in place. You got to have the gateways, and you got to have the premium service. There are a lot of components that get involved. It is not very straightforward. 

We sell our own BI tool. So, we have hundreds of clients. They are mid-sized organizations. We're building out our Power BI stack because people do like it, but right now, we have most of our stuff in Tableau.

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

I also use Tableau. They're very comparable products. I worked for different companies that built their own proprietary stuff, and mainly for visualization, Tableau and Power BI were the connectors to go to. So, there wasn't a switch.

I really like Tableau's web version over Power BI's web version. It is just easier to drag and drop things and blend data on the backend. It has a little simpler process in that regard. I don't like the charting in Tableau. Its charting is a little more complex than Power BI's charting.

Calculations are a little harder in Tableau. They can be a little more complex in Tableau as compared to Power BI. Tableau is a little more detailed in terms of creating calculations. You can't just add two columns together. Tableau should have the ability to add or subtract columns. They should make it like a wizard.

How was the initial setup?

The simple stuff is easy. When you want to get into the calculations and building DAX-type formulas, I don't think DAX is that great. I find Tableau's coding a little easier.

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

Its pricing is reasonable for the desktop stuff, but for enterprise-level, it is a little expensive. 

What other advice do I have?

I would advise others to just do their research and figure out what they want to do with it so that they know if it is going to be hard or easy.

I would rate Microsoft BI an eight 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.
PeerSpot user
reviewer1638714 - PeerSpot reviewer
Junior Data Scientist at a university with 5,001-10,000 employees
Real User
Good transforming of data for visualization, useful, stable, and scalable
Pros and Cons
  • "It is quite easy to use and it helps me to achieve the projects that I've been assigned."
  • "I feel the modeling page should be simplified."

What is our primary use case?

We use Microsoft BI typically to clean up data in Excel, as well as to create reports for my supervisor that will be analyzed and then used to draw conclusions.

How has it helped my organization?

It provides the common ground for data to be cleaned. We use this for everyone to work on cleaning up data in order to use it for visualizations, which has been helpful.

What is most valuable?

The transforming data before you start with the visualization comes in pretty handy.

It is quite easy to use and it helps me to achieve the projects that I've been assigned.

I have never had the inability to perform the tasks I've been assigned with the software. 

It's very useful because you can create helpful reports, which assist you to analyze data in a very organized way.

What needs improvement?

I feel the modeling page should be simplified. The links between different parts of your data, on the models' page, are a bit confusing. It was difficult for me to learn. 

For how long have I used the solution?

I have been using Microsoft BI for three months.

We are using an older version specific to the organization.

What do I think about the stability of the solution?

Microsoft BI is a stable product.

What do I think about the scalability of the solution?

Microsoft BI is quite scalable, especially with the number of coding languages that are available to use.

We have approximately 23 data scientists in our organization who are using this solution. We use it extensively.

We are mostly using Microsoft BI but we are trying to bring in Tableau and maximize the potential of both.

How are customer service and technical support?

I have not contacted technical support.

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

I also have experience with Tableau.

How was the initial setup?

When I arrived, this solution was already set up.

What other advice do I have?

For others who want to start using Microsoft BI, I would say go through some tutorials on your own first and then try and practice with practice data sets that are available online. Also, feel free to play around with the different tools, and the different visualizations, because you can use them differently for different things.

I would rate Microsoft BI a nine 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
reviewer1447362 - PeerSpot reviewer
Manager - Customer Success at a tech services company with 10,001+ employees
Consultant
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: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
reviewer1494948 - PeerSpot reviewer
Senior Manager Analytic & Insights at a hospitality company with 10,001+ employees
Real User
Flexible, easy to scale, good reporting, and good support
Pros and Cons
  • "The visualization and reporting are the most valuable features of this solution."
  • "This solution is resource-heavy."

What is most valuable?

The visualization and reporting are the most valuable features of this solution.

It is quite flexible for reporting purposes.

What needs improvement?

This solution is resource-heavy. I would like to see it consume fewer resources. When I use it on my laptop, it consumes a lot of resources.

For how long have I used the solution?

I have used this solution within the last 12 months.

We are using the latest version.

What do I think about the scalability of the solution?

It can scale easily.

We have more than 50 people who are using this solution in my company. Across the company, most are in marketing and finance.

How are customer service and technical support?

I would rate the technical support an eight out of ten.

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

We use Oracle BI and Oracle OBIEE.

How was the initial setup?

The initial setup was pretty straightforward.

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

It would be better if the price was cheaper.

What other advice do I have?

I would recommend this solution and suggest they use it.

I would rate this solution an eight out of ten.

Which deployment model are you using for this solution?

Private Cloud
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Group DWH and BI Senior Manager at Virgin Mobile Middle East and Africa
Real User
Scalable, easy to learn, and integrates well with the entire Microsoft Office Suite
Pros and Cons
  • "The initial setup is straightforward."
  • "Maybe they can enhance the UI a bit. Right now, it's very basic, I would say, compared to the MicroStrategy or Qlik."

What is our primary use case?

I mainly use it for sales analysis. We are in the telecom industry, so on a daily basis, we see a couple of trends in the number of activations of customers and registration, the performance of the dealer, and items like that.

What is most valuable?

Its integration with the Microsoft Office Suite is great. I can easily connect it to any of the Excel or any CSV files, and I can immediately create a dashboard. 

It's like the higher level of pivot tables. For the people who mainly use Excel, this is like an advanced version. This is much more flexible and I don't have to train people to use it, as it's very user-friendly compared to Qlik. Qlik needs some expertise and a layman cannot immediately go to Qlik and do stuff unless he understands it. When it comes to Power BI it's a five minutes tutorial, he can definitely understand what needs to be done.

The solution is stable and scalable. So far I don't have any issues, however, it depends on the amount of data we use. I'm just running it on my PC.

The initial setup is straightforward. 

The solution is free as it's bundled with Office 365.

What needs improvement?

Maybe they can enhance the UI a bit. Right now, it's very basic, I would say, compared to the MicroStrategy or Qlik. 

They could also improve the mobile experience. If people are using this mobile app for BI, they need better performance there. The rendering of the objects, for example, if you create the dashboard on Power BI when someone sees that on the app, it comes in a different format. They can do some enhancements there to standardize it.

Once we expand it as a centralized repository, if I could find much more use cases, that would be ideal. However, now it's very limited in our organization.

For how long have I used the solution?

We don't use the solution filly and don't yet have a license for it. That said, I've had the chance to work with it for more than a year now.

What do I think about the stability of the solution?

The solution is stable. There are no bugs or glitches and we don't have any trouble with it crashing or freezing. It's reliable and the performance is good. 

What do I think about the scalability of the solution?

My understanding is that the solution is scalable. 

I can easily load a billion rows in less than two or three minutes and play around with it. However, I haven't tested on big data files or anything like that.

Right now, we don't have too many users. It's just three to four people as of now, as our primary BI tool is still Qlik Sense. It's only for ad hoc use cases we use Power BI, and just myself and a couple of team members, as well as the BI specialist, that access it.

How are customer service and technical support?

I've never reached out to technical support in the past. If I run into issues, I tend to Google solutions to find answers to my questions. YouTube is also a good resource if you need information.

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

We currently use Qlik Sense as our BI product.

How was the initial setup?

The initial setup is not complex or difficult. It's simple and straightforward. 

It took, 10 to 15 minutes, if I remember correctly, to set everything up. It's just a .exe file installing. It's not hard and it's pretty fast.

What about the implementation team?

We did not need a consultant or an integrator to handle the implementation. I just played around a bit with it.

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

We don't have a license on Power BI, so we don't publish anything. It's mainly for some ad hoc use cases that we use Power BI format.

Power BI is free; it comes with Office 365.

Which other solutions did I evaluate?

I've currently looked at MicroStrategy and am in the process of comparing a few other products.

What other advice do I have?

We are just a customer and an end-user.

We are using Power BI, however, not to the full scale. It's still unlicensed as of now, and I'm using desktop versions only.

I don't remember the version, as it comes with Office 365. I didn't give a thought to the version.

From my experience with the desktop version, I'd rate the solution at a nine out of ten.

From my experience, I'd recommend the solution to others. 

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
reviewer1620744 - PeerSpot reviewer
VP Cloud Platform
Real User
Intuitive with great visuals and good scalability capabilities
Pros and Cons
  • "Technical support has been great."
  • "Most clients have MacBooks. Therefore, they use Tableau as Power BI Desktop is not available for the MacBook right now."

What is our primary use case?

We have a startup focused on analytics around sports and athletes' performance. The data sits in our platform called Hercules, which is exposed through an ODBC connector or API layer. We're currently building a connector to expose that data in a consumable way, inside Power BI (with one connector for Tableau as well). 

What is most valuable?

I love the fact that it's got a very intuitive user interface. 

I like the fact that you can create aggregations and view measures and metrics on the fly. 

I like the visuals themselves as all of our customers are moving away from Excel and this gives them a very unique way to have their data represented in a more visual manner with active slicing and dicing data right there, with the time dimensions and different dimensions. 

I also like the automatic refresh mechanism that it can do. You can have the data refresh automatically every 30 minutes, for example.

The initial setup is pretty simple. 

The stability has been pretty good.

The solution can scale.

Technical support has been great.

What needs improvement?

Most clients have MacBooks. Therefore, they use Tableau as Power BI Desktop is not available for the MacBook right now.

When you're building, the documentation sucks. It's a painful experience to find out how to do things inside the connector framework. 

I don't like the fact that they need to have a premium excuse to manage larger sets of data. On top of that, there are limitations in building a custom connector. If you want to build a custom connector for your customers, the navigation is flawed. For example, when I build a custom connector to talk to Power BI and report, I want some contextual data of the report, and I want to have what we call incremental refresh. However, incremental refresh right now is only supported in a SQL-based backend. It's not supported for API-based connectors. That's something that we really, really want. We only try to work around it.

Basically, I would love to see that incremental refresh with API-based connectors. I'd also want the report-based contextual information available inside the connector.

The licensing is very confusing.

For how long have I used the solution?

I've been using the solution since about 2014. I've used it for many years at this point.

What do I think about the stability of the solution?

We've found the stability to be fine so far. there are no bugs or glitches. It doesn't crash or freeze. 

What do I think about the scalability of the solution?

It's easy to scale if you have the premium model. We just started exploring that right now.

The clients we have that use it are medium-sized businesses. These are basically soccer clubs or sports clubs, who are internally using it. however, we want to give it to a larger audience. We haven't gone there yet, though likely we will in the future.

How are customer service and technical support?

Technical support has been awesome. they are helpful and responsive and we are more than satisfied with the level of service we receive from them.

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

I also use Tableau. I've used Power BI to a larger extent than Tableau, however, we have a startup in which we have an audience on BI and we are doing research to see how many of them are on Tableau versus Power BI.

We didn't previously use a different solution. We started with Power BI because that was one of our device partner's tools of choice. However, we are trying to support Tableau and Power BI now.

How was the initial setup?

The setup was pretty straightforward. I mean the setup for the Power BI Desktop. The download is pretty straightforward. Once you get to do more complex things with it, using the gateway and things like that, then it gets a little complex. On top of that, the documentation is difficult. It's there, however, it's difficult to find.

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

The licensing is a little convoluted, and not easy to take advantage of. You're able to scale it in the premium model. However, they are very different versions. There's a difficulty in understanding which one of them applies to you and what the costs would be eventually, and what the performance and thresholds are for each one. The documentation might be there, however, for a small company, in order to find out all the aspects of licensing it's not that easy.

Which other solutions did I evaluate?

We've also evaluated Tableau and we use both right now.

What other advice do I have?

We are in the startup program for Microsoft.

I'm on the latest version of the solution. I cannot speak to the exact version number.

It's deployed on the cloud for automatic refreshment service and it's got a gateway on-prem.

It's a very good tool to quickly get started and it does scale, however, as you get into the larger deployments and at a larger scale, it's better to involve a Power BI expert or a partner to help you get there.

I'd rate the solution at an eight out of ten. There's room for improvement from the setup and scale perspective.

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: June 2025
Buyer's Guide
Download our free Microsoft Power BI Report and get advice and tips from experienced pros sharing their opinions.