I used Microsoft BI to develop reports and then deployed them into Microsoft BI web.
Senior Data Engineer at a computer software company with 1,001-5,000 employees
Easy to use, quick report generating, and simple installation
Pros and Cons
- "Microsoft BI was very helpful for me because I had a huge variety of connections. It is very convenient to build reports, even if somebody has no experience using BI tools or data visualizations. Additionally, the performance is very good when generating reports."
What is our primary use case?
What is most valuable?
Microsoft BI was very helpful for me because I had a huge variety of connections. It is very convenient to build reports, even if somebody has no experience using BI tools or data visualizations. Additionally, the performance is very good when generating reports.
For how long have I used the solution?
I have been using Microsoft BI for approximately three months.
What do I think about the stability of the solution?
The stability of the solution has been good.
Buyer's Guide
Microsoft Power BI
August 2025

Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: August 2025.
865,384 professionals have used our research since 2012.
What do I think about the scalability of the solution?
The solution is scalable.
We have approximately 100 people in my organization using the solution and they are mostly managers.
We used the solution on a daily basis, we were using it extensively.
Which solution did I use previously and why did I switch?
I have used Tableau previously.
How was the initial setup?
The initial setup was very easy to complete and it took approximately 30 minutes.
What about the implementation team?
We did the implementation of the solution using two technicians.
What's my experience with pricing, setup cost, and licensing?
The current licensing model that Microsoft BI has is expensive. My customers have told me the cost is approximately $20 per user and this can get expensive fast. There should be a one-time purchase option if the customer has a lot of users.
What other advice do I have?
I 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.

IT Service and Strategy Consultant, Facilitator at BCAP SOLUTIONS
Offers great integrations with good visualizations
Pros and Cons
- "Easy to use and the visualization is valuable."
- "The formatting template could be improved."
What is our primary use case?
The main use case is for dashboarding on Excel spreadsheets until data lake and similar sources are ready for us to start integrating and dashboarding that information. We are a government motor transport entity and for each vehicle, there's a lifecycle. At every step of that life cycle, we need to know how many of a particular type of vehicle we have in our fleet and its status. I'm an IT service and strategy consultant and we are customers of Microsoft BI.
What is most valuable?
BI is very easy to use including the desktop version. The visualization is valuable, it's easy to select visualizations and show your data in different views. It opens up a lot of possibilities that weren't previously available and it's versatile. We're integrating with other solutions and if you look at Power BI pulling information from the data warehouse, it's integrated to an Oracle warehouse and works well.
What needs improvement?
The formatting template could be improved. In order for me to easily do visualizations, I have to format my Excel spreadsheet in a very specific template. I can't take a spreadsheet from my financial director and quickly put it in Power BI and then pivot into visualizations. I have to first check the formatting, that it's in the proper columns, and headings are logical. It needs all of that database thinking before you can actually get valuable information out of it.
I'd like to see more templates and better tooling so that when one opens a spreadsheet it's possible to manipulate data from Power BI without having to format the spreadsheet. If you were able to pull the information out of the spreadsheet via more detailed tooling, that would be brilliant.
For how long have I used the solution?
We've been using this solution for about three months.
What do I think about the stability of the solution?
Stability has been good so far.
What do I think about the scalability of the solution?
The scalability is good.
How are customer service and technical support?
We haven't required technical support.
How was the initial setup?
The initial setup was straightforward and didn't take too long. We had a team, the Azure FastTrack team, that assisted us and they were superb.
What's my experience with pricing, setup cost, and licensing?
We're using a subscription-based license and the government has a transversal agreement with Microsoft. We use the solution according to that contract, it's an EA license. When it comes to premium licenses, I think they all have room for improvement.
What other advice do I have?
I would recommend this solution to everyone, whether small, medium, or enterprise-size companies. Smaller companies should use the free version because it offers quite a lot and is valuable. I would recommend it for any size environment and specifically because it's not boxed in and you can visualize data that's on Microsoft products.
I rate the solution eight out of 10.
Which deployment model are you using for this solution?
Private Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Microsoft Azure
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Buyer's Guide
Microsoft Power BI
August 2025

Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: August 2025.
865,384 professionals have used our research since 2012.
Summer Intern at a financial services firm with 10,001+ employees
Good visualization capabilities, a lot of online content, but not easy to define a relationship and has a bit of a learning curve
Pros and Cons
- "Its visualization capabilities are pretty good. It is very easy to use. You can easily make your dashboard."
- "Defining a relationship was very confusing. There were circular directions for which I had to do a lot of adjustments in the data. They can do something to make it easier."
What is our primary use case?
I used it to build a simple dashboard. What I did was very simple. I used it to load different datasets. I defined relationships between them and played around with the data by using visuals.
I must have downloaded the version that was really available at that time.
How has it helped my organization?
I had to build a simple dashboard in which I had to combine two or three different datasets. They were large enough, so it wasn't possible to work on them easily in Excel. In Power BI, I used the relationship feature, and I was able to store the data in such a way that it does not occupy a lot of space. I could then send the file over email.
What is most valuable?
Its visualization capabilities are pretty good. It is very easy to use. You can easily make your dashboard.
There is a lot of self-help content available from a lot of different platforms, such as YouTube. So, whenever I faced an issue, it was not difficult. I could always find a solution to the issue I was facing.
What needs improvement?
Defining a relationship was very confusing. There were circular directions for which I had to do a lot of adjustments in the data. They can do something to make it easier.
For how long have I used the solution?
I worked on it this summer. I just used it for a month or two.
What other advice do I have?
Defining Relationships can be confusing when you are working with a complex data model. It can result in circular relationship referencing and the interface does not help solve it, or even understand it, in any way. It takes time to figure out a different way to structure the data model and Power BI offers no guidance on that. Online help is limited.
There is a lot of content available online. When I started out, the way I was defining the relationship between the data and the way my model was structured was not very efficient. I spent a lot of time in making it more efficient. So, I would advise others to do enough research. I was learning on the go. If you spend about six or seven hours learning it, it would be much better. Even though it is marketed as something that is easily usable and anyone can come and start using it, there is a bit of a learning curve.
I was very easily able to load the data and conduct an as-is analysis of what is happening, but if I want to do a deeper analysis of the data and break down a variable into different components, I don't know if it is possible in Power BI. I tried to do it a little bit, but it was not easy. So, it is good when you have the data, and you just want to present it and look at it in different ways, but if you want to analyze the data and break down the numbers and play around with the data, I don't know if it is possible in Power BI.
I would rate Power BI a seven out of 10.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Solutions Architect at a tech services company with 11-50 employees
Easy to learn with good data preparation features and good stability
Pros and Cons
- "As it was my first time using Power BI, I can say that it was fairly easy to learn, especially if you already know BI-type tools."
- "The one thing that I noticed specifically was the graphical features, and some of the analytical features. They were stronger on the Tableau side."
What is our primary use case?
There were two systems that the client was looking at creating some BI visualizations for. There was the system called ICE, which is a system that takes in automated calls, for service calls. They go into voicemail, however, if there's not an agent to take the call, it'll track statistics like how long a client was on hold, if an agent actually took the call, if the person hung up, et cetera. There are all of these different statuses and it would take all of those statistics. The product was used primarily to take that data in that case.
The other system was an ITSM system, which was the ticketing system. It would
it was my first time using Power BI, I can say that it was fairly easy to learn, especially if you already know BI-type tools. But the one thing that I noticed specifically was the graphical features, and some of the analytical features, I think they were stronger on the Tableau side. But the data preparation features, I much preferred the Power BI with the Power Query type features, at least for the datasets that we were working with. They were helpful in preparing the data.
combine those two data sets and reduce a merged analytical set of reports to just show when the call volumes were and what the performance rate was and the nature of the calls and things like that.
What is most valuable?
As it was my first time using Power BI, I can say that it was fairly easy to learn, especially if you already know BI-type tools.
The data preparation features were great. I much preferred the Power BI with the Power Query type features - at least for the datasets that we were working with. They were helpful in preparing the data.
What needs improvement?
The one thing that I noticed specifically was the graphical features, and some of the analytical features. They were stronger on the Tableau side.
There are two areas where the solution can be enhanced. One is natural language, where you can have third parties, however, it would be nice to have it built-in within Power BI, where a graph could be automatically explained in whatever language so that somebody can just kind of read through and have the graphic as an extra for exploring. That's something that I was looking at.
The other is the explained data, which is more of a lineage-type feature. My understanding is Tableau has that feature and Power BI doesn't. I was looking at a graph of comparisons and I noticed Tableau had this explained data feature, which gives, some lineage where data has come from, and Power BI doesn't have that. Or, if it does, it's not as well developed as Tableau.
For how long have I used the solution?
I used the solution a few months ago. I'm semi-retired, however, I did have a two-month contract and did some work with it. On the project, I did work a lot with Tableau, however, I also used Power BI, and would like to continue to use it more.
What do I think about the stability of the solution?
It was a short project on the Power BI side. I didn't really identify any glitches. Certainly, over time things might've come out, however, I enjoy doing experimenting and playing around with things. The one definite thing that I noticed, as I do art with Tableau, is some really neat art stuff, so I tried to replicate that with Power BI and the quality just wasn't there.
What do I think about the scalability of the solution?
With ITSM, there's a lot of data that they collect on that side. That could be an issue, scalability. It wasn't moved to production yet. I basically produced a report as there were some issues with the ICE data, the voicemail system, and data collection. They had some issues that they had to solve. However, they were collecting data on a daily basis. You get thousands and thousands of calls on a daily basis. It depends on how they want to store that data historically. There may be some performance issues and scalability issues, however, for me, I can't really address that, as I didn't see that side. There's always a potential for trouble.
How are customer service and technical support?
It was a really short project for me. I was really there just to analyze those two data sources and produce a report for them, with some examples, using Power BI. I was able to do that without getting tech support involved.
Which solution did I use previously and why did I switch?
I've used other solutions, such as Tableau and Power Query. Tableau from a graphical point of view is much better than Power BI, however, from a data manipulation standpoint and things like that, I prefer Power BI and Power Query to prep the data.
Tableau got bought out by Salesforce, which is a cloud-based company, so they're all going to push everything to the cloud. I'm sure they'll incorporate all these new features.
How was the initial setup?
I downloaded the solution from their website.
The server side was already set up, therefore, I don't know much about the initial setup process. As a contractor, I came in just on the development side, which was just downloading the Power BI tool as a client. It was fairly easy. That's the nice thing is it's easy to set up. It is similar to Tableau, in that Tableau is fairly easy to set up. It is all built towards this whole idea of self-service.
What other advice do I have?
I'm just a customer.
As I downloaded the solution right off the website, I assume it was the latest version. I don't know the version number off-hand.
I would do the development on-pre
There were two systems that they were looking at creating some BI visualizations for. So there was the system called ICE, which is a system that takes in automated calls, for service calls. And so goes into voicemail, but if there's not an agent to take the call, it'll track statistics like how long you were on hold, if an agent actually took your call, if you hung up. All of these different statuses would take all of those statistics. And so it was to take that data.
And the other system was the ITSM system, which is the ticketing system. And kind of combine those two data sets and reduce a merged analytical set of reports to just show when were the call volumes were, and what was the performance rate, and the nature of the calls and things like that.
It's easy to set up, however, regarding scalability and high-end analytical features, Tableau is still better on that. It's always important to keep up, as technology's changing all the time. They're always adding new features. There are no negatives in exploring these tools. In the end, you just want some visualizations that help you make decisions. Both Tableau and Power BI tools are great for that. However, if you want advanced stuff, then it's just about experimenting and seeing what will help you solve your problems.
I'd rate the solution at an eight out of ten.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Strategic Market Development Sr. Manager at a pharma/biotech company with 201-500 employees
Easy to use, flexible, but mobile application needs improvement
Pros and Cons
- "The solution is easy to use and flexible."
- "The solution could improve the mobile application design. It is difficult to use compared to the desktop version."
What is our primary use case?
I am using this solution to monitor the dashboards that someone else has created.
What is most valuable?
The solution is easy to use and flexible.
What needs improvement?
The solution could improve the mobile application design. It is difficult to use compared to the desktop version. Additionally, we have experienced a problem when attempting to update the desktop application. When we click to update we are unable to open the file to update.
For how long have I used the solution?
I have been using this solution for approximately two years.
What do I think about the stability of the solution?
I have found the solution to be stable.
What do I think about the scalability of the solution?
We have approximately 50 people using this solution in my organization.
Which solution did I use previously and why did I switch?
I have previously used Microsoft Excel.
How was the initial setup?
The installation was simple and it takes approximately five minutes.
What about the implementation team?
I did the implementation of the solution.
What's my experience with pricing, setup cost, and licensing?
We have a professional license for Microsoft BI and the price is fair.
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.
Manager - Customer Success at a tech services company with 10,001+ employees
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.
Engagement Professional at a consultancy with 51-200 employees
An intuitive business analytics service with tons of connections
Pros and Cons
- "The best feature for me is Power Query. I know that probably sounds strange, but you can't do too much with visuals and reports if the backend stuff is horribly dirty and just bad. But for me, that is absolutely fantastic. I can load the data and do the transformation and be able to load it in a useful way. There are tons of connections, which is absolutely fantastic as well. It's been fairly easy, and it's intuitive."
- "It would be better if they had some video tutorials. Most people from an Excel background may struggle with measures in Microsoft BI."
What is our primary use case?
I have used Microsoft BI for sales analysis. I've also used it to analyze people. Pretty much across the board, whether it's the number of people, number of dresses, number of hamburgers, number of widgets and then creating the dashboards and the metrics and so forth.
What is most valuable?
The best feature for me is Power Query. I know that probably sounds strange, but you can't do too much with visuals and reports if the backend stuff is horribly dirty and just bad. But for me, that is absolutely fantastic. I can load the data and do the transformation and be able to load it in a useful way. There are tons of connections, which is absolutely fantastic as well. It's been fairly easy, and it's intuitive.
What needs improvement?
It would be better if they had some video tutorials. Most people from an Excel background may struggle with measures in Microsoft BI.
For how long have I used the solution?
I have used Microsoft BI over the last 12 months.
What do I think about the stability of the solution?
I haven't really had any issues, but I haven't given it the full whammy or the full monty. It's been stable for my use.
How was the initial setup?
The initial setup was easy for me.
What other advice do I have?
I would tell potential users that there are many other tools out there, but I think it's a steep learning curve. For example, Alteryx and Domo, and Trifacta can be difficult to learn unless you have a SQL background. But if you're a Microsoft person, the transition is fairly easy for Microsoft BI. It's intuitive, and I would recommend it from that perspective.
On a scale from one to ten, I would give Microsoft BI an eight.
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.
Data Warehouse Engineer at a government with 1,001-5,000 employees
Easy to use and flexible but can't handle big data
Pros and Cons
- "The product is easy to use and simple to navigate."
- "The product doesn't support unstructured data. It doesn't support video, streaming, and strings of files."
What is our primary use case?
We primarily use the solution primarily for making dashboards. We are also doing analytics on Microsoft BI.
What is most valuable?
The solution is very stable.
The product is easy to use and simple to navigate.
The product has proven to be quite flexible.
It is quite scalable and it is doing the work that we want it to.
What needs improvement?
We'd like the solution to be more scalable.
We'd like the ability to manage it on the cloud, as a cloud-based solution. It is running out of business as it is not able to keep pace with the big data. Big data is not something that BI can support. It cannot be scaled that much.
The product doesn't support unstructured data. It doesn't support video, streaming, and strings of files. Microsoft is aware of this.
For how long have I used the solution?
I've been using the solution for seven to eight years at this point. It's been a while.
What do I think about the stability of the solution?
The solution is very stable. There are no bugs or glitches. It doesn't crash or freeze. It's reliable and the performance is very good.
What do I think about the scalability of the solution?
The solution is quite scalable, although, in our case, as we are not on the cloud, we are facing some issues.
We have more than ten people using the solution currently.
How are customer service and technical support?
I've never reached out to technical support in the past. I cannot speak to how helpful or responsive they are.
How was the initial setup?
I wasn't a part of the initial setup. That was something that was handled by another team. I can't speak to how long it took to deploy.
My understanding is that you only need two people to deploy the solution. Admins usually handle it.
What's my experience with pricing, setup cost, and licensing?
I don't have any insights into the licensing and payments required.
What other advice do I have?
We are using the latest version of the solution. I'm not sure of the exact version number.
I'd rate the solution at a seven out of ten. For us, it has met our expectations and we enjoy its capabilities.
I'd recommend this product to other users and organizations.
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.

Buyer's Guide
Download our free Microsoft Power BI Report and get advice and tips from experienced pros
sharing their opinions.
Updated: August 2025
Popular Comparisons
Tableau Enterprise
Teradata
IBM Cognos
Amazon QuickSight
SAP Analytics Cloud
SAP BusinessObjects Business Intelligence Platform
Oracle OBIEE
MicroStrategy
Oracle Analytics Cloud
QlikView
TIBCO Spotfire
Looker Studio
ThoughtSpot
Salesforce Einstein Analytics
Buyer's Guide
Download our free Microsoft Power BI Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- BI Reports for business users - which BI solutions should we choose?
- Business users moving from Tableau to MS Report builder
- Is Power BI a complete platform or only a visualization tool?
- What are the key advantages of OBIEE compared to Microsoft BI?
- What Is The Biggest Difference Between Microsoft BI and Oracle OBIEE?
- Is Microsoft Power BI good for an ETL process?
- How would you decide between Microsoft Power BI and TIBCO Spotfire?
- Is it easy to extract data from Oracle Fusion into Power BI?
- PowerBI or SyncFusion - which is better?
- What challenges to expect when migrating multiple dashboards from TIBCO Spotfire to Microsoft Power BI?