I take care of business transformations in the company, which includes solution transformation, and so on. We have a range of products that are legacy products. They are fairly old. We are substituting them with new age products, and one of them is Power BI. We are using its latest version currently.
President at a security firm with 10,001+ employees
Good visualization, automatic charts, and drill-down capabilities
Pros and Cons
- "The drill-down capabilities and automatic charts are the best ones. The visualization is also very good. In terms of visualization, no competing product, such as IBM Cognos or any other product, has the same capabilities."
- "Microsoft BI comes under pressure when there is a lot of data to be crunched. It gets slower and slower, and the functionality becomes a bit of a problem. The performance goes down with data being fed into the system. The infrastructure requirement also increases if you have to increase the performance. This is the area that can be improved in my opinion. Initially, the product is good, but over the years, when data gets accumulated, it becomes a problem unless the old data is kind of archived and is no longer shown on the visualization. It has a feature by using which a user can query for a report through simple questions to a bot. So, if I want to look for the customer share of revenue by geography, I just simply state that in the chatbot. If I wanted it in a pie chart, then you say, "Please show it to me in a pie chart." It comes out well for basic charts. This feature should be improvised more so that people can very quickly get customized reports on the go."
What is our primary use case?
What is most valuable?
The drill-down capabilities and automatic charts are the best ones. The visualization is also very good. In terms of visualization, no competing product, such as IBM Cognos or any other product, has the same capabilities.
What needs improvement?
Microsoft BI comes under pressure when there is a lot of data to be crunched. It gets slower and slower, and the functionality becomes a bit of a problem. The performance goes down with data being fed into the system. The infrastructure requirement also increases if you have to increase the performance. This is the area that can be improved in my opinion. Initially, the product is good, but over the years, when data gets accumulated, it becomes a problem unless the old data is kind of archived and is no longer shown on the visualization.
It has a feature by using which a user can query for a report through simple questions to a bot. So, if I want to look for the customer share of revenue by geography, I just simply state that in the chatbot. If I wanted it in a pie chart, then you say, "Please show it to me in a pie chart." It comes out well for basic charts. This feature should be improvised more so that people can very quickly get customized reports on the go.
For how long have I used the solution?
I have been using this solution for a couple of years.
Buyer's Guide
Microsoft Power BI
February 2026
Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: February 2026.
883,824 professionals have used our research since 2012.
What do I think about the scalability of the solution?
Its scalability is good. The only issue is the performance that degrades when more data comes in, but when it comes to scalability within a particular level of data, it is really good.
How are customer service and support?
I don't know. I am not technically so much involved in the day-to-day side of this.
How was the initial setup?
The initial setup is a process by itself, so we have to take external help in terms of implementation. In terms of various reports and other things, I don't have an idea about the complexity of the implementation because we took expert advice, and an external consultant implemented it for us. I would guess that it is a bit extensive and needs a lot of work to be usable.
What other advice do I have?
I would definitely recommend Power BI for those entities that are not complex. Unless and until there is a very high volume to be handled, I believe Microsoft Power BI is the best solution to go for, particularly when somebody buys a stack of Microsoft products, which includes Office, SharePoint, and so on. The whole Microsoft Office Suite is a brilliant product in its entirety, and there is good and easy integration with SharePoint, etc. This is a nice feature that other products don't have. There is a stack of IBM as well, but it is not as good as Microsoft.
I would rate Microsoft BI an eight out of ten. I am pretty happy with this solution, and the two points are down because of the performance issue and probably the cost.
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.
Lead Statistical Analyst | Innovation Champion at a pharma/biotech company with 10,001+ employees
Has good drag and drop interactability visualization but it's a bit complicated to make it refresh automatically
Pros and Cons
- "We like the drag and drop interactability visualization. We really like that. It's user-friendly."
- "If I have to update data automatically, where I have to pin the gateway, it doesn't update. There is a scheduled refresh functionality so that it refreshes automatically, but I find it very hard to make it work."
What is our primary use case?
We have SharePoint in our company and then we just wanted to visualize that list and it connects to the Check Point list.
What is most valuable?
We like the drag and drop interactability visualization. We really like that. It's user-friendly.
What needs improvement?
If I have to update data automatically, where I have to pin the gateway, it doesn't update. There is a scheduled refresh functionality so that it refreshes automatically, but I find it very hard to make it work. Even though it's supposed to connect seamlessly, it's a bit complicated to make it refresh automatically.
For how long have I used the solution?
My company has been using Microsoft BI for a few years but I've been using it since January 2020.
What do I think about the stability of the solution?
It's very stable.
What do I think about the scalability of the solution?
I think it's very scalable. I don't even foresee that as a challenge.
We have five or six users who view the reports. There are other departments who might be using it as well but we have five or six in my department. It's expected to rise to 15, 20.
The users are managers who want to look at some of the resources.
How are customer service and technical support?
I haven't interacted with Power BI before. If I get stuck at someplace, I just go online and I search in the forums and I find my way.
How was the initial setup?
There isn't really a setup involved. It's just download Power BI desktop and publish it.
What's my experience with pricing, setup cost, and licensing?
We have a premium Power BI license in-house that's quite an expensive license. It's $10 a month for four users and then I think 35,000 at the premium rate.
What other advice do I have?
Ensure that you use Sharepoint. If you are within the Microsoft system and want to have a similar experience to Microsoft Teams, then Microsoft Power BI is a very good solution for that.
I would like to have the ability to run the scheduled refresh for R and Python on the server. Right now, it's not possible.
I would rate it a seven out of ten.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Buyer's Guide
Microsoft Power BI
February 2026
Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: February 2026.
883,824 professionals have used our research since 2012.
Business Intelligence Developer at a retailer with 1,001-5,000 employees
Easy to make people understand what is going on but I would like to use SQL properly within the reports
Pros and Cons
- "The drag and drop facility to easily change the data correctly is the most valuable feature. I am happy to see visualizations. It's easier to talk about and make people understand what is going on."
- "I would like to be able to use SQL properly within the reports and allow multiple people to work on the same report at the same time. If one person is working on it, then it causes issues for anyone else wanting to make reports."
What is our primary use case?
Our primary use case is to learn what Power BI can do. We also use it to create dashboards and to see what is available for people to use. We see how it integrates with Excel. You can easily get the data into a visualization but also still have access to the underlying data.
We use it see how we can move away from an Excel spreadsheet but still give the users the correct answers to the questions that they have. I want to move away looking and fixing issues on particular lines and be able to easily answer the questions with visualizations so users can answer the questions a lot quicker and adapt to changes easier.
How has it helped my organization?
I was self-learning it, we don't use it in our organization. We are looking to use it though in the future. We use a different tool and want to see if we can get more questions answered with Power BI. It's linked to Office 365 and Azure, so it would help us to answer some difficult questions and help identify issues/problems so we can find solutions and adapt the model a lot quicker. Going through over 100,000 lines of data takes too long and we need to be able to group the data more to be able to identify what works better, so a pie chart or map will help to identify issues that are not working.
What is most valuable?
The drag and drop facility to easily change the data correctly is the most valuable feature. I am happy to see visualizations. It's easier to talk about and make people understand what is going on. But I need a way to work on getting the data showing correctly and be able to drill down into a worksheet like Excel, as people like to know what the top-level information means. It's important to be open and show them what they want. The number of visualizations is great. So many different options to choose from like heat maps to pie charts.
What needs improvement?
I would like to be able to use SQL properly within the reports and allow multiple people to work on the same report at the same time. If one person is working on it, then it causes issues for anyone else wanting to make reports. We want to condense some reports, so they work for all departments, and not have a version for every single department. Also, I would like to have formulas easier to complete and create. Having its own system means something new to learn, although saying that, it's not hard to pick up this information.
For how long have I used the solution?
I have been using Microsoft BI for six months.
Which solution did I use previously and why did I switch?
Microstrategy, and no, we have not swapped yet. I use both to keep on top of my own skill set.
What's my experience with pricing, setup cost, and licensing?
It depends on what you are wanting to do. Get the cost of users, and the servers, and work out if you are hosting, or if it's going into the cloud.
Which other solutions did I evaluate?
We didn't as it's a company decision to look to change the BI system.
Which deployment model are you using for this solution?
Public 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.
Internal Audit Officer at a financial services firm with 51-200 employees
Provides valuable data visualization tools, but the customization features need improvement
Pros and Cons
- "The product is scalable."
- "There is room for improvement in terms of customization and configuration options, particularly for more advanced users."
What is our primary use case?
I use Power BI primarily for generating reports, analyzing data, and supporting data-driven decisions across various functions within the organization.
How has it helped my organization?
The solution's data integration capabilities are beneficial because they allow us to seamlessly integrate data from multiple sources, simplifying the analysis process and providing a comprehensive view for better decision-making.
What needs improvement?
There is room for improvement in terms of customization and configuration options, particularly for more advanced users.
For how long have I used the solution?
I have been using Power BI for quite some time now.
What do I think about the scalability of the solution?
The product is scalable. Expanding its use across different teams within the organization has been relatively easy.
What was our ROI?
We are seeing a good return on investment with Power BI, particularly in terms of how it has streamlined our reporting and analytics.
What's my experience with pricing, setup cost, and licensing?
The solution's costs are quite reasonable given the range of features provided.
What other advice do I have?
We receive real-time reporting with Power BI, which greatly impacts our decision-making process by allowing us to respond more quickly to changes in the data.
The data visualization tools particularly strong. The ability to create custom dashboards and reports tailored to different
It is highly user-friendly and cost-effective. However, it may lack certain advanced features present in other solutions.
Overall, I rate it a seven out of ten.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Software Engineer at a consultancy with 1-10 employees
Enables us to look at the budget for all of the departments in our company
Pros and Cons
- "The accounting data needs improvement."
What is our primary use case?
We use Microsoft Power BI to budget for all departments and to compare the balance of the past month.
What needs improvement?
The accounting data needs improvement.
For how long have I used the solution?
I have been using Microsoft Power BI for a year.
What do I think about the stability of the solution?
It is a stable solution.
What do I think about the scalability of the solution?
Ten users are using the solution.
How was the initial setup?
The initial setup is complex.
What other advice do I have?
I would rate the overall solution an eight out of ten.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Expert Data Quality Management at a financial services firm with 1,001-5,000 employees
Stable product with efficient data updation features
Pros and Cons
- "It offers a lot of information and is very flexible and interactive."
- "The product’s on-premise reporting servers could support real-time data refreshing capabilities like its on-cloud version."
What is our primary use case?
We use Microsoft Power BI to automate dashboards to present information to our senior management. It helps us extract the relevant data from the dashboard.
What is most valuable?
The product’s most valuable feature is data updates after modifying and refreshing the dashboard. It offers a lot of information and is very flexible and interactive.
What needs improvement?
The product’s on-premise reporting servers could support real-time data refreshing capabilities like its on-cloud version. It would be a very useful functionality.
For how long have I used the solution?
We have been using Microsoft Power BI for about a year and a half.
What do I think about the stability of the solution?
The product is stable. It works perfectly, and we haven’t encountered any issues working with it.
What do I think about the scalability of the solution?
It is a scalable product. We have around 100 Microsoft Power BI users in our organization. We are expecting growth in the number of users.
Which solution did I use previously and why did I switch?
We have worked with SAP BusinessObjects. Power BI is better because it has more flexibility and functionalities.
What other advice do I have?
I rate Microsoft Power BI a nine out of ten. I recommend it to users who want to pursue a career in data engineering. It will be very helpful and provides a lot of guides on the Internet, especially on YouTube. They can gain knowledge about its advantages and disadvantages.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Head of analytics team at a media company with 51-200 employees
A stable solution that can be used for reporting and dashboarding, but its integration and visualization could be improved
Pros and Cons
- "We've used Microsoft BI for the general use cases around reporting and dashboarding."
- "Microsoft BI’s integration and visualization could be improved."
What is most valuable?
We've used Microsoft BI for the general use cases around reporting and dashboarding. We used it once for Power Apps to develop a live application.
What needs improvement?
Microsoft BI’s integration and visualization could be improved.
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 BI is a stable solution.
Which solution did I use previously and why did I switch?
Between Microsoft BI and Tableau, I would go for Tableau because it's more powerful. Tableau could connect to a variety of databases, and the visualization is much, much better. I would always prefer Tableau because of the dimension picking you could do there. Speed-wise, the latency issues were much lesser in Tableau.
If you're using Azure in general as a cloud service provider, Power BI would be more integrative. If you need a stand-alone system and are not worried about the cloud setup, I recommend using Tableau.
What's my experience with pricing, setup cost, and licensing?
Microsoft BI for desktop is free to use, and you can download and use it.
What other advice do I have?
Overall, I rate Microsoft BI a seven out of ten.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
BI Expert at a financial services firm with 1,001-5,000 employees
Fast and user friendly
Pros and Cons
- "You don't need much support with Microsoft Power BI because it has such a large base of users who can answer your questions on their forums. There are also many video tutorials and webinars available online that offer solutions to whatever problems you may have."
- "Microsoft is behind IBM when it comes to security features."
What is our primary use case?
I've used it for work I did with three clients in the Brazilian banking sector:
Bank Bradesco, B&B Bank, and the Regional Bank of Brazil.
What is most valuable?
It's very fast and user-friendly.
What needs improvement?
Microsoft is behind IBM when it comes to security features.
For how long have I used the solution?
I've used Microsoft Power BI for about three years with different clients.
How are customer service and support?
You don't need much support with Microsoft Power BI because it has such a large base of users who can answer your questions on their forums. There are also many video tutorials and webinars available online that offer solutions to whatever problems you may have.
Which solution did I use previously and why did I switch?
I use Cognos Analytics 11 for some projects, but many of my clients prefer Microsoft Power BI because it is less expensive.
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: February 2026
Popular Comparisons
Tableau Enterprise
Teradata
IBM Cognos
Amazon QuickSight
SAP Analytics Cloud
SAP BusinessObjects Business Intelligence Platform
Oracle OBIEE
MicroStrategy
QlikView
Oracle Analytics Cloud
ThoughtSpot
TIBCO Spotfire
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?


















