Try our new research platform with insights from 80,000+ expert users
Northern Europe IT Business Intelligence Manager at a recruiting/HR firm with 10,001+ employees
Real User
Nov 29, 2020
The tool is very flexible, allowing for creativity
Pros and Cons
  • "The tool is very flexible so it allows creativity."
  • "I think that the product would benefit by increasing the range of visuals and graphics readily available, as opposed to using a third party included as part of the product."

What is our primary use case?

Microsoft BI can be useful for several scenarios, depending on your end audience, or what they're looking for. Depending on your creativity, imagination, and what the tool allows you to build, you can create a lot of cool things with it. You can build a lot of very elaborate and dynamic reports for example. The most important thing to consider is to understand what your audience is looking for. The development side of the tool is not the problem.

How has it helped my organization?

The usability of the tool is very simple. If you know the basics, it's fine. Even if you don't have the basics, there is a lot of self-service documentation available which helps to guide the user to start to use the tool, and how to navigate through it. 

There was also a new feature added last month to help new users practice using the system by providing an example data set to experiment with. Power BI server can be run on-premise so that your reports are available locally. Or you can have a premium version, including all your reports on the Cloud. It can be determined by the number of refreshes required from the reports or can depend on the volume of users that are consuming the reports.

What is most valuable?

The tool is very flexible so it allows for creativity. Power BI allows you to incorporate Microsoft Visio diagrams and other graphics from Microsoft tools. You can also integrate third-party visual graphics created from other tools, such as R or Python. It is useful to be able to obtain additional charts or different types of graphics developed by a third-party tool. This gives you more options for your end solutions. However, for some third-party tools and graphics such as Zoom charts, you have to pay for those separately. This is useful if you really wish to mesmerize your audience with dynamic, interactive visuals.

Alternatively, if you just want to use what is available to you, and with a little bit of UX/UI knowledge and creativity, you can build really cool stuff with it. For example, you can have dynamic dashboards on a screen that is connected in real-time. Users can interact directly with the data, so when they click the mouse, they can see the data changing. There's a lot of things that you can do with it. Let's say you develop a report, to put on a big touchable screen. Let's say the CEO is presenting to someone, and he's on a big screen. As soon as he touches a dialogue or a graphic on the screen, all the data changes. 

As an example, in CNN news, or any news, where they are presenting, and there are some dashboards and reports, journalist clicks on the screen, and everything changes instantly. That's what Power BI can do. If you have touch screens Power BI allows you to interact with your data.

What needs improvement?

I think that the product would benefit by increasing the range of visuals and graphics readily available, as opposed to using a third party included as part of the product. One way they could do that is for Microsoft to buy some of those third party companies, as they are specialists in visual creation, and they are making money from that. However, I understand that perhaps Microsoft maybe doesn't want to invest in that side of the business. Perhaps it is a financial decision. I would say that if we can have those additional visuals built into the product, it will be great. Alternatively, in the future, there should be an additional tool there that allows you to create your own visuals. That will give users more flexibility. 

It would also be useful for users with little experience in coding, or other Microsoft tools such as Excel. For example, let's say, you are a random user, and you're just looking at the computer for the first time. You open Power BI, but you know you can go to an Excel file and connect to that Excel file from Power BI. This is very simple and intuitive. So, once you have connected to the data, you can see your fields on the right-hand side, and all you need to do then is to drag and drop the fields you need. You can then select a relevant visual or graphic, and put the information alongside that visual, and then you have the visual and the data created as one item. This is very useful and dynamic. This would also have the other huge advantage, in that it would be a cheaper solution to use. I would like the ability to reuse connections. 

For example, if I created a connection to an SQL server, and I published my report using that connection, and then shared my report, it would be useful to be able to reuse the existing connection to the SQL server. In this way, I can reuse the existing dataset to create another report. I believe this is already the subject of a support ticket. Say I then wanted to reuse another connection from a different connection, say Oracle, to use in the same report, I could use the connections to those two sources and build the report. If I already have the sources online, and available for me, it would make sense that I could reuse them. At the moment, you can only reuse one data source. You cannot reuse more than one data source, at least if the data sources are online. One workaround would be to access each data source in turn, to obtain the data for the report. However, from October 2020, when using Excel driven reports, it is possible to reuse data flows or reuse the data component, from Power BI in Excel. So Microsoft has already implemented it for Excel, but it is still in the preview features. That will help a lot in financial areas. This could also impact company sales forecasts and sales.

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

For how long have I used the solution?

I have 10 years of experience using BI tools, like Tableau, Power BI, QuickView, and MicroStrategy. I have a background in technical architecture but my main expertise is in BI tools. I use Power BI. It's a business intelligence tool that helps you develop and create reports that you can connect to various data sources. Then you can slice and dice, and build what you want to build from there.

What do I think about the stability of the solution?

Microsoft BI is stable.

What do I think about the scalability of the solution?

The product is scalable, and new updates come out every month.

How are customer service and support?

Microsoft Technical Support is very good. If I need their assistance, they will liaise with me. They are very flexible, useful, and very friendly. They are very open to helping you out. So depending on how you escalate your call, and say it's a high-priority issue they contact you very fast. They have support lines globally. So if I'm in the Czech Republic, I may be contacted by someone from Romania, or from India, or another zone. It's fine, if, for example, I'm not English, and I need to speak to someone who speaks Spanish, they put me in touch with someone who speaks Spanish. There is a lot of available support for Power BI, and they have their own Power BI page called Power BI Support. Power BI issues are registered on that page. Support usually fixes the issues within the given timeframe. The other good part about Power BI is the huge Microsoft community that it is there. So you can raise tickets and use the community which is on the same page. Sometimes the community helps you find your solution. So, it provides two ways to access support solutions.

How was the initial setup?

It's easy to install which helps new users to the product. The installation process is easy. You can install it from the Microsoft store, or you can go directly to the Microsoft portal, and download the version that you require. It keeps historical versions available in case you need to test a different version. The advantage of the Microsoft store is that as soon as you install it from there, it always keeps you updated with the latest version. Also from a Power BI service point of view, you have several capabilities. The learning curve comes in when researching the different features, and what is new in the product, as well as what is going to be provided in future versions. The advantage of Power BI is that every month you have something new provided with the update. For example, you may have a new connection, additional visuals, or use new narratives.

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

We have 8,000 Power Bi licenses in our organization, so it is widely used. Setup is easy, and the cost is economical. You do sometimes need to pay additional costs for third party products which "plug-in" to Microsoft BI.

What other advice do I have?

I would give Microsoft BI a 10 out of 10.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Murali_Krishna - PeerSpot reviewer
President at a security firm with 10,001+ employees
Real User
Top 10
Nov 29, 2020
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?

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.

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. 

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 technical 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.
PeerSpot user
Buyer's Guide
Microsoft Power BI
January 2026
Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: January 2026.
881,114 professionals have used our research since 2012.
Lead Statistical Analyst | Innovation Champion at a pharma/biotech company with 10,001+ employees
Real User
Jul 30, 2020
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.
PeerSpot user
Business Intelligence Developer at a retailer with 1,001-5,000 employees
Real User
Jun 2, 2020
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.
PeerSpot user
Samuel Olubode - PeerSpot reviewer
Internal Audit Officer at a financial services firm with 51-200 employees
Real User
Top 20
Sep 25, 2024
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.
PeerSpot user
Software Engineer at a consultancy with 1-10 employees
Real User
Top 10
Mar 26, 2024
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.
    PeerSpot user
    IvanIvanov21 - PeerSpot reviewer
    Expert Data Quality Management at a financial services firm with 1,001-5,000 employees
    Real User
    Nov 28, 2023
    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.
    PeerSpot user
    Head of analytics team at a media company with 51-200 employees
    Vendor
    Sep 18, 2023
    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.
    PeerSpot user
    Buyer's Guide
    Download our free Microsoft Power BI Report and get advice and tips from experienced pros sharing their opinions.
    Updated: January 2026
    Buyer's Guide
    Download our free Microsoft Power BI Report and get advice and tips from experienced pros sharing their opinions.