The use case for power BI is to generate dashboards for high-end management and operational dashboards.
Principal System Developer at HHRC
Is easy to install, stable, and scalable, and helps to quickly create dashboards
Pros and Cons
- "What I like about Power BI is how fast you are able to create dashboards and how fast you are able to fetch the data. You can connect to the database or data source, and then you can design your dashboards very easily."
- "There are some limitations in Power BI; you have to work in the Power BI base. However, if you want something not out-of-the-box and you want something custom, you have to do a lot of work."
What is our primary use case?
How has it helped my organization?
Microsoft BI, if used properly, can provide insights that will help management to take better decisions and can benefit from cost optimizations, reduce risks, etc.
What is most valuable?
What I like about Power BI is how fast you are able to create dashboards and how fast you are able to fetch the data. You can connect to the database or data source, and then you can design your dashboards very easily.
The best thing about Power BI is that you can manipulate the data within Power BI, so you don't have to update the data source to have filtration or conditional formatting. You can easily do those things under Power BI.
It is easy and has rapid development.
It is stable and scalable as well.
What needs improvement?
There is an issue with Microsoft because the on-premises Power BI is behind the cloud Power BI. So, the on-premises Power BI is six months or one year behind the cloud version because Microsoft published the cloud features first, and then they published the on-premises version. This has been an issue. They should be on the same level of capability.
There are some limitations in Power BI; you have to work in the Power BI base. However, if you want something not out-of-the-box and you want something custom, you have to do a lot of work. Microsoft can provide some easy way to customize the dashboards.
Buyer's Guide
Microsoft Power BI
January 2025
Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: January 2025.
831,071 professionals have used our research since 2012.
For how long have I used the solution?
I've been using this solution for two to three years.
What do I think about the stability of the solution?
It is stable, but there is an issue with Microsoft because the on-premises Power BI is behind the cloud Power BI. The features of on-premises Power BI are six months or one year behind the cloud version. They are not on the same level of capability.
What do I think about the scalability of the solution?
The scalability of Power BI is quite good.
How are customer service and support?
Microsoft technical support could be more knowledgeable.
Which solution did I use previously and why did I switch?
We switched to Power BI because it is easy, and there is rapid development.
How was the initial setup?
Installation is easy and took about half an hour.
What about the implementation team?
It requires a little bit of effort, and we needed the help of a consultant.
What's my experience with pricing, setup cost, and licensing?
Power BI comes with enterprise Microsoft licensing. So for the user, you don't have to pay, but you do have to pay a one-time cost.
What other advice do I have?
If you want to use Power BI, you should go for the cloud version. Don't use the on-premises version because the cloud version has a lot of features which the on-premises version doesn't have.
Also, if you are going to use Power BI, you should know what all your capabilities are. Otherwise, if you try to do some things such as develop a dashboard which is not supported by Power BI, it will be a showstopper for you.
I would rate this solution at eight on a scale from one to ten.
Which deployment model are you using for this solution?
On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Product and Systems Director at SPCM
It's good for tracking indicators like KPI, sales, and a bunch of other essential metrics for our company's strategic planning.
Pros and Cons
- "Power BI has strong support from Microsoft. If you need help, they answer promptly. There are also several discussion groups where you can get information, like the product roadmap and any new things coming up."
- "Microsoft has made a lot of progress with Power BI in the past couple of years, but there is still some room for improvement. For example, Integration is one area they could work on. They are adding more integration with other Microsoft tools, but I would like it if they sped up the process."
What is our primary use case?
Power BI is used internally to track indicators like KPI, sales, and a bunch of other essential metrics for our company's strategic planning. Power BI creates reports and compiles data coming from various sources, and we create dashboards for managers and executives to monitor these indicators.
There is also an external use case. We also have a team that provides BI as a service. Let's say your company collects all your data manually in Excel sheets and creates reports. We get rid of the Excel files and automate everything using Power BI to create dashboards and reports.
What needs improvement?
Microsoft has made a lot of progress with Power BI in the past couple of years, but there is still some room for improvement. For example, Integration is one area they could work on. They are adding more integration with other Microsoft tools, but I would like it if they sped up the process.
For how long have I used the solution?
We've been a Microsoft partner for 12 years.
What do I think about the stability of the solution?
Microsoft Bi is stable.
What do I think about the scalability of the solution?
Microsoft BI is scalable.
How are customer service and support?
Power BI has strong support from Microsoft. If you need help, they answer promptly. There are also several discussion groups where you can get information, like the product roadmap and any new things coming up.
How was the initial setup?
Everything is in the cloud, so you don't do anything. You only need to download a client, and that's it. If you have to create an embedded solution, it only takes five minutes.
The entire deployment takes a couple of hours, but you don't need a specialist to deploy it. Obviously, you need someone who understands the technology and how to follow instructions, but it's pretty straightforward stuff.
What's my experience with pricing, setup cost, and licensing?
Power BI's price is good relative to its competitors. It has more than 400 or 500 different connectors. A lower price would always be welcome. The price is fine, but the licensing is complicated. Quantum mechanics is easier to understand than Microsoft licensing.
What other advice do I have?
I rate Microsoft BI nine out of 10. If you are thinking about using Microsoft BI, go for it. Microsoft BI is worth it. It's one of the products Microsoft got right from the beginning. It's perfect.
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 has a business relationship with this vendor other than being a customer: Partner
Buyer's Guide
Microsoft Power BI
January 2025
Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: January 2025.
831,071 professionals have used our research since 2012.
Senior Business Analyst at a tech services company with 501-1,000 employees
Allows us to create dashboards that provide insights about operations and different transactions for top management
Pros and Cons
- "The user experience is easy. Users get familiar with it quickly."
- "Sometimes while developing, the front end is not easily customizable and it has limitations. We cannot go and do any UI we want. We have to stick to the limitations of the product."
What is our primary use case?
The use case is mainly creating the dashboard for the organization's data transaction and its data project. We create dashboards on top of this data for the top management.
I am using the latest version.
The solution can be deployed on cloud or on-premises. It depends on what the client wants and if it's available.
We have around 10 to 15 people using this solution in our organization.
How has it helped my organization?
Microsoft BI provides insights about the normal day-to-day work from operations or different transactions. It depends on the organization's business. It provides insights for top management to help them make more accurate decisions.
What is most valuable?
The user experience is easy. Users get familiar with it quickly.
What needs improvement?
Sometimes while developing, the front end is not easily customizable and it has limitations. We cannot go and do any UI we want. We have to stick to the limitations of the product.
It's user friendly, but it does have its limitations. A designer cannot dream of anything they want to do and just go and do it. The dashboard has to look a specific way. If we can make the front end more flexible, that would be good because it's on the server. Clients are asking for a better UI, but it has its limitations.
For how long have I used the solution?
I have been using this solution for five years.
What do I think about the stability of the solution?
The stability is good. The solution is being used daily, on a moderate to high level in our organization.
What do I think about the scalability of the solution?
The solution is scalable.
How are customer service and support?
Technical support is good.
Which solution did I use previously and why did I switch?
Sometimes I work with Qlik Sense, which is another BI tool.
How was the initial setup?
Initial setup was straightforward.
What about the implementation team?
Our technical team completed the deployment. It was all done in-house. Deployment only required two people.
What other advice do I have?
I would rate this solution 8 out of 10.
The solution is reliable, maintainable, and scalable. It has good performance. The security is good. The only thing would be improving the front-end limitation, which prevents us from designing a UI that can match what the client wants. Be aware of the product's limitations so you don't promise the clients anything that the product itself cannot do.
Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
DGM IT at a manufacturing company with 5,001-10,000 employees
Easy to use solution
Pros and Cons
- "The data can be accessed from anywhere."
- "I would like to see a more user-friendly interface with Microsoft BI."
What is our primary use case?
Our company is a manufacturing firm. We have an ERP running in our company. I develop the reports for the business that include sales, stock and production related information. These dashboards are used for analytics purposes by management, enabling them to make decisions regarding the products and business improvement.
We use the BI text file and summarize the information on dashboards to help management make the right decisions for the business. The information includes production figures, running status, forecasts and actual positions.
We have 10 users of this solution.
What is most valuable?
The most valuable feature of Microsoft BI is the ease of use. The data can be accessed from anywhere. We control access through Office 365.
What needs improvement?
I would like to see a more user-friendly interface with Microsoft BI. Microsoft does regular updates, new features are added every month or so.
For how long have I used the solution?
I have been using Microsoft BI for one year.
What do I think about the stability of the solution?
Microsoft Power BI is stable with no issue.
What do I think about the scalability of the solution?
The solution is scalable.
How are customer service and support?
Overall, technical support is good.
Which solution did I use previously and why did I switch?
Prior to using Microsoft BI, we had been using OBIEE. Oracle is a complicated product with poor visuals. Comparing with Microsoft BI, we found Microsoft to have better handling, graphics, features, and easier development and coding.
How was the initial setup?
The initial deployment of Microsoft BI was relatively easy. We installed it to the machine and connected it to our Oracle database.
What about the implementation team?
We were able to install the solution ourselves internally.
What's my experience with pricing, setup cost, and licensing?
Microsoft BI requires licenses.
What other advice do I have?
Microsoft Power BI is an easy product. If you have some idea about the business intelligence solutions and some technical knowledge, it is a self-deployed solution.
I would rate the solution an 8 out of 10.
Which deployment model are you using for this solution?
Public Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Senior Analyst at a tech services company with 10,001+ employees
Good visualizations, dashboards, and scalability, but needs better user interface, rule-based security, and support
Pros and Cons
- "Its visualizations and dashboards are most valuable. Power BI is great in terms of visualizations and dashboards. The reports that we previously had were not very nice in terms of visualization. It also provides the ability to play with the data."
- "We have a lot of servers and applications from which we want reports, and it allows us to create reports from an SQL source or some other source."
- "They can improve it in terms of rule-based security. Currently, it has very limited rules."
- "They can improve the user interface a little bit to make it more user-friendly. When creating a dashboard, it is not very user-friendly. You have to click on a certain style and use your keyboard keys to move it. You cannot drag and drop it."
- "Their technical support can be better. They normally take too long to escalate and resolve a case."
What is our primary use case?
We use it for reporting. We are using its latest version.
What is most valuable?
Its visualizations and dashboards are most valuable. Power BI is great in terms of visualizations and dashboards. The reports that we previously had were not very nice in terms of visualization. It also provides the ability to play with the data.
We have a lot of servers and applications from which we want reports, and it allows us to create reports from an SQL source or some other source.
What needs improvement?
They can improve it in terms of rule-based security. Currently, it has very limited rules.
They can improve the user interface a little bit to make it more user-friendly. When creating a dashboard, it is not very user-friendly. You have to click on a certain style and use your keyboard keys to move it. You cannot drag and drop it.
Their technical support can be better. They normally take too long to escalate and resolve a case.
For how long have I used the solution?
I have been working with Power BI for five or six months.
What do I think about the stability of the solution?
I am at the initial stage of using it. We have just deployed a report in our organization, and it is working fine so far. It seems to be stable. I am not sure if we faced any issues with it.
What do I think about the scalability of the solution?
It is good in terms of scalability.
How are customer service and technical support?
I have had only one interaction with them, and it was a bad one. They took around a month to resolve a simple issue. We also had to escalate the case. The resolution was very simple, and ideally, they should have found it on the first day. They normally take too long when it comes to the escalation of cases.
How was the initial setup?
As a first-time user, I found it to be of medium complexity. You have to connect it with the SQL database or your data source. You might not find it very straightforward.
What other advice do I have?
It can also be deployed on-premises. If you have it on-premises, make sure that you meet all the prerequisites and have all permissions. You should sort these things out before deploying Power BI. I faced some issues because I missed one of the prerequisites, and it took me one month to get it resolved. That's why I recommend completing all prerequisites.
I would rate Microsoft Power BI a seven out of ten.
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: I am a real user, and this review is based on my own experience and opinions.
Technical Director, Information Management at a construction company with 5,001-10,000 employees
Good reports, dashboards, and visualizations, but needs more report outputs and better documentation
Pros and Cons
- "Reports, dashboards, and visualizations are most valuable."
- "It should have more report outputs. They should expand the report outputs. Its documentation should also be better."
What is our primary use case?
It is used for data visualization and analytics. We have its latest version.
How has it helped my organization?
It has provided better and deeper analytics for our data. It has also been helpful for custom visualizations as per client requirements.
What is most valuable?
Reports, dashboards, and visualizations are most valuable.
What needs improvement?
It should have more report outputs. They should expand the report outputs.
Its documentation should also be better.
For how long have I used the solution?
I have been using this solution for five years.
What do I think about the stability of the solution?
It is fairly stable.
What do I think about the scalability of the solution?
It is scalable based on licensing. You would need premium and additional organizational licenses. Mostly everyone in the organization uses this feature. We have around 4,000 users of this solution in our organization, which includes a lot of project management people.
We don't have any plans to increase the usage in the future. We are currently content with its usage.
How are customer service and technical support?
They exceed expectations and provide good quality support.
Which solution did I use previously and why did I switch?
We had other solutions, but they were some form of ad hoc databases and spreadsheets. We switched to this solution for integrating various data sets from different data sources and for richer analytics.
How was the initial setup?
It was straightforward. It took two weeks.
What about the implementation team?
It was an in-house job. For its maintenance, we probably have a staff of about 20 people.
What other advice do I have?
I would rate Microsoft BI a seven out of ten. It is a really well-developed product, but it has some room for improvement.
Which deployment model are you using for this solution?
Hybrid Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Manager, BI & Analytics at Perceptive Analytics
User-friendly, offers a flexible measure creation capability, scalable to large datasets, and has good community support
Pros and Cons
- "Two valuable most features are the ability to create columns and create measures."
- "In my opinion, the software is a little bit limited in terms of the flexibility it offers, with regard to the design of the visualization."
What is our primary use case?
I am currently a management consultant and, before my current employment, I was a management consultant as well. I also had a stint with an online retailer in India. My usage with Power BI has been in the area of practical day-to-day operations, web host operations, and equipment status monitoring.
What is most valuable?
Two valuable most features are the ability to create columns and create measures.
The create measures feature offers you a little bit more flexibility. You can define what kind of measure you need using a formula, and the way Power BI works is very similar to Excel. In fact, most of the functions that you use in Excel are present in Power BI as well. When you create measures or columns, you just write the formula as you would in Excel, which will allow you to visualize that data in the way that you want.
What needs improvement?
In my opinion, the software is a little bit limited in terms of the flexibility it offers, with regard to the design of the visualization. By comparison, if you look at some other visualization tools, such as Tableau, for instance, the range of designs, or the range of graphics that you can create with Tableau is far greater than what you can do with Power BI.
Of course, they do provide an option to download templates and use them, but every time, you have to go to the Power BI store, search for those templates, download them and then use them. I think it's a growing universe of visualizers that they have, so probably, they are also working on the same thing. I believe, in terms of the designs of the visualizations that the tool can create, there is some room for improvement.
One more aspect that needs improvement is the formatting of visualizations that we create. Formatting in this context is the colors or the font style or font sizes. The formatting options, I believe, could be made a bit more user-friendly than the way things are right now. It's a little hard to figure out where to go and how to change the formatting of a particular chart or graph. So, I think the formatting options could be made a little bit more user-friendly.
For how long have I used the solution?
I have been using Power BI for more than three years.
What do I think about the stability of the solution?
Microsoft BI is definitely stable.
What do I think about the scalability of the solution?
This product is scalable and in fact, I have worked on it with fairly large datasets. It also gives you the option of publishing onto a server. When the dashboard/report is published to the Power BI server, we get a link that can be shared with others in the organization. At the enterprise level, it is possible to give access to a list of users who will have a need to look at the report frequently. These users can just click on the link and view the report whenever they want to. It is also possible for them to use filters and interact with the report.
How are customer service and technical support?
I am fairly comfortable with the tool and to this point, I really haven't felt the need to reach out to Microsoft with regard to the specific features of the tool. In case I do need some help on a particular feature, what I usually do is Google what I am trying to find and I get some links to the Microsoft community, or something similar, which answers my question.
To that extent, it has been very convenient to find help in whatever we are required to do with the software. The simple things are taken care of automatically. In case there is some trouble with the visualizations, you can always find help or assistance on the Microsoft community pages.
Which solution did I use previously and why did I switch?
I have also worked with Tableau and I think that each of these tools has its advantages.
I believe the cost of the software plays a deciding factor in a company's decision to implement either of the two. While each product has its pros and cons, if you're looking for something that's more value for money, then I think Power BI is the better choice.
On the other hand, if you are willing to choose an expensive option that gives you a lot more flexibility, then I think that Tableau would be a better choice.
It ultimately depends on what you are going to use it for. If you're using it for a variety of visualizations that you want to create, Tableau will be a better choice. On the other hand, if people have budget constraints then Power BI will provide a good value for the money.
How was the initial setup?
The initial setup is straightforward. You just download the software from their website, install it, and sign in.
What's my experience with pricing, setup cost, and licensing?
This product offers good value for the money.
What other advice do I have?
In a nutshell, I recommend this product and I would suggest implementing it. It has a very good range of features that it offers. For organizations starting on their business intelligence journey, I believe Power BI is a very good tool to start with. It's very user-friendly and it provides a graphical user interface where users can just drag and drop their required fields into particular templates of visualizations. It means that you get the charts quickly. There's no complex learning curve involved. From that perspective, I would say that it's definitely worth a try.
My biggest complaint is that it's a bit limited right now, in terms of the choice of visualizations it offers.
I would rate this solution an eight out of ten.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Identifies customer purchasing patterns and provides good visualization
Pros and Cons
- "It has provided customer purchase patterns and great visualization."
- "This solution needs integration with SAS and more deep analysis functionality."
What is our primary use case?
Our primary use for this solution is geospatial analysis.
How has it helped my organization?
This solution has provided an accurate analysis of our customers repurchasing the same plan for telecom Jio. It has provided customer purchase patterns and great visualization.
What is most valuable?
The most valuable features are the visualization and integration with Office365.
What needs improvement?
This solution needs integration with SAS and more deep analysis functionality.
For how long have I used the solution?
I have been using Microsoft BI for five years.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Buyer's Guide
Download our free Microsoft Power BI Report and get advice and tips from experienced pros
sharing their opinions.
Updated: January 2025
Popular Comparisons
Teradata
Amazon QuickSight
IBM Cognos
SAP Analytics Cloud
SAP BusinessObjects Business Intelligence Platform
Oracle OBIEE
MicroStrategy
Oracle Analytics Cloud
Salesforce Einstein Analytics
TIBCO Spotfire
ThoughtSpot
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?