I have started a consulting business. So my use case is typically what my clients are doing. I've used it for healthcare analysis, headcount analysis, financial and performance analysis.
Principal at a tech services company with 1-10 employees
Gives business power users the ability to do their own work, without help from IT
Pros and Cons
- "In the early stage of an implementation, it not only helps decision making, but it allows people to have insight into problems with data so that they can go and get it corrected."
- "Allows business users with a mission to solve their own problems, without an IT person."
- "One thing I would like to have is the scripting language, as they already have within Excel. It's already within a Microsoft business product, because Excel is the number one business product out there. So it would be nice to have the scripting capability in order to automate certain processes."
What is our primary use case?
How has it helped my organization?
One thing it's doing in the early stage of an implementation is, it not only helps decision making, but it allows people to have insight into problems with data so that they can go and get it corrected.
What is most valuable?
The ability for business users with a mission to solve their own problems, without an IT person.
What needs improvement?
One thing I would like to have is the scripting language, as they already have within Excel. It's already within a Microsoft business product, because Excel is the number one business product out there. So it would be nice to have the scripting capability in order to automate certain processes.
Buyer's Guide
Microsoft Power BI
May 2025

Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: May 2025.
857,028 professionals have used our research since 2012.
What do I think about the stability of the solution?
It's not only stable but it's constantly improving.
What do I think about the scalability of the solution?
The scaling is dependent on the data source itself, so it's not dependent on the solution. SQL Server, which is one of the strongest enterprise databases, makes that a good thing.
Which solution did I use previously and why did I switch?
We were previously using Excel, and Excel did not have the ability to deploy nor did it have the ability to easily do some of the things that people were asking for. The switch was driven by being overwhelmed in the Excel world.
My most important criteria when selecting a vendor are
- usability
- the ability to develop solutions in an agile fashion
- the ability to have power users on the business side able to do their own work.
How was the initial setup?
It's very, very easy to get started. The complexity is the typical complexity in deployment, in that you have to have people make decisions on who has rights to what data. As far as the implementation, it's quite easy.
What's my experience with pricing, setup cost, and licensing?
Pricing, that's where Microsoft beats Tableau. It is priced much cheaper.
Which other solutions did I evaluate?
The short list was really only Tableau and Microsoft, and frequently clients have Microsoft products already installed so they have the security, the Active Directory, as well as the use of Excel, and the use of the collaboration tools like O365.
What other advice do I have?
I'd say that Microsoft and Tableau are both nine and a half out of 10, and it's per the requirements I already mentioned. They both are very high-quality, easy to use, stable, they both allow business users to do a level of development, and they're both highly deployable.
My advice to a colleague would be that they actually do short trials with each of the products they're considering and the check the vendors' support.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.

Principal at a tech services company with 1-10 employees
It allows individuals to do the analysis themselves
Pros and Cons
- "It allows individuals to do the analysis themselves."
- "Drill-down in dashboards needs to improved. The capability only works in Power BI Desktop today. We need to have an alternative approach today."
What is our primary use case?
Consolidating data from multiple sources and providing dashboards to a broad set of users: Finance, Human Resources, Operations, and Leadership.
How has it helped my organization?
It allows individuals to do the analysis themselves. We are getting adoption beyond original expectations.
What is most valuable?
Most importantly, the dashboards. Recently, we are exploring vendor provided analysis/visuals and the use of R.
What needs improvement?
Drill-down in dashboards needs to improved. The capability only works in Power BI Desktop today. We need to have an alternative approach today.
For how long have I used the solution?
Three to five years.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Buyer's Guide
Microsoft Power BI
May 2025

Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: May 2025.
857,028 professionals have used our research since 2012.
IT Director at VIC Dept of Health and Human Services
Provides data feeds for enterprise KPI reporting
Pros and Cons
- "Provides data feeds for enterprise KPI reporting."
- "There is continual improvement year-over-year."
- "The data source definition is all over the place."
- "It needs a wizard that covers all its options."
- "It needs an AI which can choose the appropriate connection strings and provide options for connections."
What is our primary use case?
How has it helped my organization?
- We are running over 500,000 report annually.
- It provides data feeds for enterprise KPI reporting.
- It provides data feeds for AI.
What is most valuable?
- Integration of DB and reporting
- Standardised SQL language
- Plenty of support
- Cloud options
- Continual improvement year-over-year
What needs improvement?
- The data source definition is all over the place.
- It needs a wizard that covers all its options.
- It needs an AI which can choose the appropriate connection strings and provide options for connections.
For how long have I used the solution?
More than five years.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Business Intelligence Developer at a financial services firm with 5,001-10,000 employees
Self-service allows end-users to source information, but email-based subscription is needed
How has it helped my organization?
It cuts away the time spent to source some of this information. It saves a lot of time, and a lot of things have been automated. Things that used to take close to a week, now, in one day, we are done with it.
What is most valuable?
It's actually the self-service of Power BI, because we're on a lean structure here, the technical side. So we wanted them to push some of those things back to end-users.
What needs improvement?
For our reporting services, it would be good to have the capability for email-based subscriptions. I want to be able to change the sender dynamically, without having to rely on running through an exercise passage.
I know for a fact that SAP can do this, dynamic sending for subscriptions. Also IBM Cognos can do it. Why Microsoft refused to do that, that you have to rely on add-on to be able to do that...
Overall, it has performed to our expectation. It's okay for what we want to use it for. But because they keep changing, every now and then, there's a major shift in versions, so we are trying to catch up.
What do I think about the stability of the solution?
I've used the IBM suite, and I've used SAP, and Microsoft is fairly stable for me. And because there is a large community for issues that arise, for every bug that you encounter, you have a solution, just Google it, without having to go for special training like with SAS.
What do I think about the scalability of the solution?
From what I understand, it requires some level of expertise to even understand what it can do, how it can be used in a huge enterprise. That is not so easy for deployment. But for a medium sized organization, yes, it's scalable.
How was the initial setup?
It was straightforward. Very straightforward.
You can just go to YouTube, somebody has done it before. Because it has GUI, just click, click, click, next, next, and you're done. And YouTube helped a lot in deploying projects: SSAS Projects, SSIS projects, and SSRS projects.
Which other solutions did I evaluate?
IBM Analytics. But the learning curve for IBM, that's what actually led us to pause on the implementation of the Cognos 10. Everything was pretty much difficult to do. Things that you could do in two clicks in Microsoft, you would be doing in five, ten clicks in IBM.
What other advice do I have?
When selecting a vendor, the most important criteria are affordability - because of the exchange in my country - and ease of use.
I would rate this solution a seven out of 10, because you can actually go from the common tools that you use, from your Excel, from your SharePoint... You can pretty much do everything with it. The little things that you can't do, you can customize it to do by writing code.
I would say that, you should look away from the limitations. Focus on the positives of it, because it's cheaper to acquire than most of the big five. It's cheaper to acquire and easy to use.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Flexibility in analyzing data is helpful, but it needs to be simpler to use
Pros and Cons
- "The most valuable features are the flexibility, how many ways you can interrogate the data, and the the graphical visualization."
What is our primary use case?
I use it for budget analysis. I am in charge of budget analysis for the organization. I get figures from other units, and then I do a budget comparison with forecasting.
The performance is very good.
How has it helped my organization?
For a long time I had to do everything manually, and it took a long time. At the moment, I just have to refresh and I get my report. A few clicks are needed. Once I get the data in the right format, then I have the report as quickly as it is required.
It used to be stressful towards the month's end, to meet the deadline for reporting, especially when these reports are required by the board of the company. But now, as long as the other units give me my numbers on time, I don't waste a lot of time in preparing the numbers. I can now use my time in analyzing the outcome, rather than preparing the figures and cleaning up the data. It provides efficiency and saves time.
What is most valuable?
The most valuable features are the flexibility, how many ways you can interrogate the data, and the the graphical visualization.
What needs improvement?
They need to make it as user-friendly as possible. Make it as non-technical as possible. At the moment, if you are not a person who is familiar with modeling analysis, it might be a bit scary. So I think it should be a very simple user interface. It should be very easy to learn.
What do I think about the stability of the solution?
It can be annoyingly slow at times, but I think it's because of the bandwidth, the connectivity we have. I've always believed if we had better connectivity, it would be perfect. Sometimes it's slow. But I really don't blame it on the solution. I blame it, but on my connectivity.
How are customer service and technical support?
I always just try to Google if I have issues, and a lot of time that is perfectly good. I just need to know the basics.
Which solution did I use previously and why did I switch?
I knew there must be a better way of doing what I was performing, so I searched. I did not have a previous solution, I just did things manually.
How was the initial setup?
It was easy. The only thing I noticed was that it was so slow. It took a long time to download, but again, I think that was my connectivity.
What's my experience with pricing, setup cost, and licensing?
At the moment I'm using a free version.
What other advice do I have?
When selecting a vendor, the most important criterion for me is, it should be something that is really user-friendly. By that I mean, I don't need to go through specialized training to learn how to use it; not in this day and age, when the solution should be really a solution. I don't need to be an expert to know how to use it. Just user friendly, click and go. Also, I think it should be something that assures me of its stability.
For me, at the moment, it is the best thing that I've used. But I can't compare it to the other ones. It is the only one I know, apart from just normal financial modeling which I've used before. To me it is the best, but I can't really compared to any others because I don't know how the others work.
Do your research. For me, this is the only one I know. But I know there are others which are better.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Head of IT at a construction company with 10,001+ employees
Users already using Excel can generate new reports and dashboards within minutes
Pros and Cons
- "It is in the cloud, which makes it easy for mobile access of reports and data."
- "Users already using Excel can generate new reports and dashboards within minutes."
- "Initial setup was very straightforward. Users can get up and running reporting on databases within minutes."
- "Real-time refreshing for SAP BW would be nice. We know its on the radar for the development team at MS. "
- "Not having to login again after a mobile app upgrade. A simple login on mobile would be great."
What is our primary use case?
Microsoft Power BI gives a true self-service tool to the user. The IT team can focus on ensuring that the database is in a good place. It is also in the cloud, which makes it easy for mobile access of reports and data.
How has it helped my organization?
The business users have taken to Microsoft BI like a duck to water. It requires a low amount of training. Users already using Excel can generate new reports and dashboards within minutes.
What needs improvement?
- Real-time refreshing for SAP BW would be nice. We know its on the radar for the development team at MS.
- Not having to login again after a mobile app upgrade. A simple login on mobile would be great.
For how long have I used the solution?
One to three years.
What do I think about the stability of the solution?
None.
What do I think about the scalability of the solution?
None.
How are customer service and technical support?
They are fabulous.
Which solution did I use previously and why did I switch?
The previous products include Tableau, Cognos, BusinessObjects, and Sisense. All of them have high price tags! Why pay and get ripped off for these products when you have Power BI? It will give you just as much, growing every month at an acceptable cost model.
Want to waste a lot of money? Then go for the others, I can recommend BusinessObjects as a great way to burn your money.
How was the initial setup?
Initial setup was very straightforward. Users can get up and running reporting on databases within minutes. I can read a number of databases including a good old Excel spreadsheet.
What about the implementation team?
Internal Team. It is that easy. However, we did get a third party to do the training to key users for us. The course was tailored to our business.
What was our ROI?
Paid for itself in the first month.
What's my experience with pricing, setup cost, and licensing?
Make it low in cost. It is a no-brainer!
Remove the cost of a licence to show a dashboard within SharePoint. Why should readers of a dashboard have to pay to view?
Which other solutions did I evaluate?
Globally, we evaluated a number of products, including Salesforce's product, Microsoft won on the ground of simple functionally and cost.
What other advice do I have?
Love that fact that we have a great development team that is moving the product forward every month.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Senior Manager with 10,001+ employees
Ease of development and maintenance
Pros and Cons
- "Ease of development and maintenance."
- "Needs single sign-on."
What is our primary use case?
- P&L
- Revenue
- Logistics
- IT services
- Stock control
- Costs
- Sales
How has it helped my organization?
- Established a culture of management by indicators.
- Improvement of services
- Greater visibility of results
What is most valuable?
- Predictable cloud environment
- High performance
- Ease of development and maintenance
What needs improvement?
- Delta update
- More than 10 GB of space
- Single sign-on
- More than 30 Windows to update by Power Bi gateway.
For how long have I used the solution?
One to three years.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Project Manager with 51-200 employees
It helped identify bad data
Pros and Cons
- "Helped identify bad data, enabling the corrections needed to the data for management."
- "It needs more graphics and overlays."
- "It needs more analytic tools."
What is our primary use case?
Our primary use cases for this solution are Health and Wellness claims and short-term and long-term disability data.
How has it helped my organization?
It helped identify bad data, enabling the corrections needed to the data for management.
What is most valuable?
- Ease of use
- Dashboard
- Easy access to databases and spreadsheets
- Multi-table access
What needs improvement?
- More graphics and overlays
- More analytic tools
- More interfaces to databases, especially multi-table management
For how long have I used the solution?
Three to five years.
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: May 2025
Popular Comparisons
Teradata
IBM Cognos
Amazon QuickSight
SAP Analytics Cloud
SAP BusinessObjects Business Intelligence Platform
Oracle OBIEE
MicroStrategy
Oracle Analytics Cloud
QlikView
Looker Studio
TIBCO Spotfire
Salesforce Einstein Analytics
Microsoft SQL Server Reporting Services
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?