Try our new research platform with insights from 80,000+ expert users
reviewer1477869 - PeerSpot reviewer
Senior Consultant at a computer software company with 10,001+ employees
Vendor
Dec 24, 2020
Good user interface, good technical support, and has the ability to scale
Pros and Cons
  • "The solution's initial setup isn't too complicated."
  • "The integration with other solutions could be improved for reporting aspects."

What is our primary use case?

We have a few projects. We're using the solution primarily to develop a modern sitemap.

What is most valuable?

The product has a very defined, well-prescribed format to it. It's easy for everyone to use for the most part.

The training is pretty good. It's well-described so that users can navigate the solution easily and follow the correct steps to initiate tasks effectively.

The user interface is pretty good.

The technical support on offer is excellent.

We've found the scalability to be quite good.

The solution's initial setup isn't too complicated.

What needs improvement?

I need more time with the solution. Right now, I can't think of any features that are missing from the product.

The integration with other solutions could be improved for reporting aspects. There are some reporting features in Tableau that we need access to and it would be ideal if there was a function between the two for data integration and data manipulation, with the final representation of the report available on Tableau.

For how long have I used the solution?

I've been using the solution for a year or more at this point. It hasn't been too long.

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

What do I think about the stability of the solution?

So far, the solution has been largely stable. However, I'm still exploring the solution and testing it against my requirements. The stability hasn't quite been proven fully just yet.

What do I think about the scalability of the solution?

The solution is pretty scalable. It meets all of my client's requirements. I'm able to make changes and expand if I need to. It's pretty simple to scale it out as necessary.

We deal, for the most part, with medium-sized companies. We don't really deal with smaller organizations or bigger enterprises.

How are customer service and support?

I'm extremely satisfied with technical support. It's been excellent so far. They are responsive and knowledgeable and I always get my questions answered in a timely manner. I have no complaints about their level of service.

Which solution did I use previously and why did I switch?

I've also worked with Tableau and SAP products. We use them all currently.

How was the initial setup?

The initial setup is not complex in any way. It's quite straightforward. It was installed quite easily onto our system. We didn't run into any issues in that sense.

What other advice do I have?

I'm using the calculator version of the solution.

We use both the cloud and on-premises deployment models.

We are Microsoft partners. We're not just users.

Overall, I would recommend the solution. We do have other plans to use other BI solutions, however, we haven't really focused on that just yet. So far, this product has met our needs pretty well.

On a scale from one to ten, I'd rate the solution at a nine. We've largely been happy with the product and its offering.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer. partner
PeerSpot user
reviewer1389651 - PeerSpot reviewer
Certified Adjunct Faculty, School of Engineering and Computing at a university with 1,001-5,000 employees
Real User
Dec 20, 2020
Helps introduce data analytics in a way that students understand and appreciate
Pros and Cons
  • "What Power BI is, is a whole collection of templates of small amounts of data that can be used to do something for a real world project, that can be easily set up and become the business intelligence environment or a data warehouse for a large amount of data, for a real world customer. That's what is remarkable."
  • "When it comes to improvement, I would say there could be more tutorials for students in universities who are just learning it. And it wouldn't have to be just for students in universities. It might also be for the people who use it in the real world."

What is our primary use case?

I have taught and mastered many desktop tools, including Power BI, for the purpose of prototyping designs for business intelligence and data warehousing. Currently, I am teaching data analytics at graduate level and Power BI is on my schedule.

We teach tools like Power BI by going through common scenarios in a business intelligence environment, which most often deal with the factual numerics that get designed into a sales force reporting dashboard or similar solution, showing details like order placement, orders shipped and paid for, etc. The templates for these typically use a style of diagramming called star schema, which is a common dimension modeling technique. 

I can't say whether it's the most frequent real-world use case that a real customer would focus on, but for the level of our tutorials, a sales scenario might involve a description of customers, products, locations, maybe geography, and the timing of sales for trends analysis.

Other than Power BI, I also teach AWS and Azure, where I help guide students to plan and come up with architecture for deploying to the cloud. It's not actually very hands-on, as it's more to help with architecture diagramming for the intentions that students have when using them. And at our institution, all of our courses last only four weeks, so it's very fast tracked, which sometimes means that we don't really go too in-depth.

AWS has a lot of samples and diagrams, including many graphics that are fairly artistically detailed. The level at which I've helped students reference those kinds of diagrams is mainly for their team projects, to illustrate their intention, for example, to deploy a database into AWS. If it's an SQL Server database, we usually choose Azure. But it's not to actually do it. It's rather to have the intention to, for illustration purposes.

How has it helped my organization?

I had a brilliant student in May last year, 2019, who did her graduate capstone project - where I was her advisor - using Power BI. And she has two times now responded to my invitation to be a guest speaker on that tool to classes such as the data analytics class that I've been teaching for about 20 times now, going back six years.

At my institution, I'm the only one teaching database design, whether undergrad or grad, and I found Power BI was a very attractive tool to introduce during the database design class, and then later enable the students to use it for their capstone. Unfortunately, it didn't work out in November this year, because few of the students picked up on it and gave the actual time it would take to focus their attention on using Power BI templates.

Overall, my observation is that the enrollment is way down and the students who are still in the program are very distracted, I think because of the pandemic. Despite this, Power BI has helped me introduce students to business intelligence and data analytics because it's a very attractive and cost-effective tool (there's no cost to it, it's free).

Another reason I'm inspired to focus my time on helping students with Power BI is because of the analyses done by the Gartner Group and Forrester Research, wherein they reviewed the strengths of Power BI. Both of them call it a "killer app". That caught my attention. And Power BI seems like the best thing to suggest to the students.

And I'm up to it on my side teaching through online, although I'm regretting that I cannot go on a campus to be still there for the students whose strong preference is to be together in a room learning on site. I hope that in the class in May, there'll be more people really interested in actually using it. In November, I was hoping some of the students would, but for reasons such as the pandemic, these online students have too many distractions. Especially if they're also still working or they have families with kids at home.

What is most valuable?

What Power BI is, is a whole collection of templates of small amounts of data that can be used to do something for a real world project, that can be easily set up and become the business intelligence environment or a data warehouse for a large amount of data, for a real world customer. That's what is remarkable. And that's what it takes.

It makes use of the ordinary things, and they'll sound familiar. Excel, Access, or SQL Server as the database, and the deployment techniques like Azure for it to be in the cloud.

It's very heavily like Microsoft promoting its own products, but I forgive it because this time it works. And I'm speaking from some experience; I worked in the data warehouse technology group at Oracle for three and a half years, and I was helping Oracle's clients put up a data warehouse with Oracle as the database, and to migrate data into the Oracle database. So that was my background. And for me to be persuaded that this collection of regular, already known, already used desktop tools could work just as well, but with the added value of the samples, the templates, frequent updates, and lots of support. That says a lot.

It also has other features that I like, especially regarding the designs in the set of templates for things that would perhaps be very puzzling to somebody doing it for themselves. It has pre-built tables to hold, during project lifestyle, maybe a small select amount of test data with the intention of the large amount of data going into production after deployment. And it has all the table designs that start out generic but that can be easily customized.

What needs improvement?

When it comes to improvement, I would say there could be more tutorials for students in universities who are just learning it. And it wouldn't have to be just for students in universities. It might also be for the people who use it in the real world.

The evidence that I see when I look into it is there's a lot of user group type of connections to the Power BI world. And many, many bloggers telling their stories and promoting themselves or small businesses promoting themselves to do it for you using Power BI. The claim being that they could help you get it done instead of you doing it yourself. That's what goes on in this industry. You see a lot of entrepreneurial people who want to work in the role of consultant and get paid for it. There's a lot of that.

And the invitation to look into the websites comes from little mini tutorials, which can be very helpful. But the next step of those tutorials, if most of the people get what they want out of them, is a contract to do the work. I don't want to introduce those kinds of things to my students, because it's kind of promoting something that could be a distraction.

I worked for years as an independent consultant. I even did a fairly long series of contracts up in the state of Washington at Microsoft and I had 38 years in the industry before I became an academic teacher. But I'm avant-garde when it comes to sales. I avoid salesman because I don't want to believe the hype. I don't want to be deceived. And I don't want to suggest that somebody go that way. The topic of sales is overdone. This is an opinion on my part.

On a practical note, the process of importing data into a new environment that has recently been designed is always a major effort. And Power BI has some weaknesses when it comes to loading data into an otherwise good concept and a good design because if it's not seriously tested and all shortcomings noticed beforehand, the importing process will fail.

Even a cool tool like Power BI cannot anticipate the complexity of the variety of sources of data. But they're not alone. That would not be a disqualifier. But because I don't have direct yet, hands-on, having done this, I don't really know how Microsoft would improve this area.

I think they've got it handled on integration. Everything that you're working with is already a Microsoft environment or a Microsoft tool. It's integrated. But if you're using the desktop tools by Microsoft and you need to deploy into a backend of Oracle, there might be some things that a smart consultant has to help out with. So cross-platform integration could use some improvement in terms of ease-of-use.

For how long have I used the solution?

I have used Microsoft BI in my data analytics classes for a few years now. 

What do I think about the stability of the solution?

In an abstract sense, it's holding up. I don't speak to actual customers of Microsoft products to answer that question. But I would suggest that it's holding up because the Gartner Group put out another magic quadrant output that describes it as being in the leader category.

It's a well-respected research group, Gartner. In fact, companies that want to acquire its research for anything more specific or consulting, have to pay for it and have ownership. I don't pay for it. But there are many vendors who have my school email on their lists, so I get the reports for free, and I have my hands on quite a collection of the reports.

And that's why I'm mentioning them because the Gartner Group has mentioned Power BI twice now. So as far as long-term prospects go, I'd say Power BI is a stable solution.

How are customer service and technical support?

Microsoft provides frequent updates and a lot of support for Power BI.

Which solution did I use previously and why did I switch?

I have worked in the data warehouse technology group at Oracle for three and a half years, helping Oracle's clients deploy a data warehouse with Oracle as the database. But when Power BI came onto the scene, I was more and more persuaded to use it instead for business intelligence and data warehouse purposes. This was mainly because I enjoyed how easily Power BI builds on existing tools that I'm already familiar with like Excel and Access. 

How was the initial setup?

The setup is straightforward, because it exhibits itself within familiar tools, like spreadsheets.

The complexity comes when you try to convert from simple beginnings into something that needs to eventually become reality. But I'm guessing. I don't know that it's complex. And anyway, I personally like complex. It attracts my attention.

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

For my primary use case, i.e. teaching students, the free version of Power BI is adequate.

What other advice do I have?

May is the next time I'll be teaching the data analytics class, the graduate class, and I will be actively trying to promote Power BI for the team project.

I would rate Microsoft Power BI an eight 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
Microsoft Power BI
December 2025
Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: December 2025.
879,371 professionals have used our research since 2012.
reviewer1467924 - PeerSpot reviewer
Compensation Coordinator at a computer software company with 1,001-5,000 employees
Real User
Dec 9, 2020
The easiest and most stable solution that has good querying capabilities and great support and is light years ahead of other solutions
Pros and Cons
  • "The querying capabilities are the most valuable because they allow me to build many automations. We have many workflows and many databases that we work on a daily basis. They need to be updated quite quickly. In order to not to take much of our time doing these updates manually, I have set up these automations using the systems. The process is just to ingest the data and reprocess it. Every time I click a button, everything is updated in almost real time. It is by far the easiest system not only for querying but also for data modeling, data visualization, and deployment. It is light years ahead of Tableau and even Microsoft Excel to do these kinds of things. It is very easy to use and set up, and it has a lot of videos on the internet."
  • "I would like it to be a little bit more secure when I'm using the design feature on my desktop. For example, to have the ability to set up security passwords for opening the file. Currently, they don't have that. Tableau, for example, has a visual way of doing data processing steps, whereas the Power BI system still has some code, although it is very low code. It would be great to have the kind of view that Tableau has."

What is our primary use case?

In general, we use it to have access to the data that we have processed from the HCM system and also to deploy it to the teams. Because it has low-level security features, I can guarantee that only selected people have access to the information seamlessly. We don't take a lot of steps to create, for example, different profiles and ensure the data security that I need.

It is on the cloud because we have pro accounts. Usually, we have the desktop version for designing and using ourselves here, but when we deploy this, it is usually on the Microsoft cloud; it is not on-premises. We are using the most updated version because they release monthly updates.

What is most valuable?

The querying capabilities are the most valuable because they allow me to build many automations. We have many workflows and many databases that we work on a daily basis. They need to be updated quite quickly. In order to not to take much of our time doing these updates manually, I have set up these automations using the systems. The process is just to ingest the data and reprocess it. Every time I click a button, everything is updated in almost real time.

It is by far the easiest system not only for querying but also for data modeling, data visualization, and deployment. It is light years ahead of Tableau and even Microsoft Excel to do these kinds of things. It is very easy to use and set up, and it has a lot of videos on the internet.

What needs improvement?

I would like it to be a little bit more secure when I'm using the design feature on my desktop. For example, to have the ability to set up security passwords for opening the file. Currently, they don't have that.

Tableau, for example, has a visual way of doing data processing steps, whereas the Power BI system still has some code, although it is very low code. It would be great to have the kind of view that Tableau has.

For how long have I used the solution?

I have been using this solution for around two and a half years. I am currently using it, and I have also used it in the previous company.

What do I think about the stability of the solution?

It is very stable and very reliable. It is by far the most reliable system I have used for deploying many things.

What do I think about the scalability of the solution?

It is very scalable, especially because the pricing was great. Right now, they are integrating a lot with Microsoft Power Apps and the Power Platform as a whole. Power Ultimate and other things are being integrated into the system as well.

In my previous company, more than 200 to 300 people were using it on a daily basis. In my current company, we have less than ten people using it because we are still a very confined team.

How are customer service and technical support?

The technical assistance is great, and I have never had any problems with them. Their support to communities is also great. I would rate them a ten out of ten.

How was the initial setup?

The initial setup was very easy. It took a little bit less than a month to get everything designed, tested, and deployed after we got the licenses.

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

Its pricing is great.

What other advice do I have?

The first piece of advice is to become very clear about licensing and the data governors. Always get the licenses and get them right. You must also be clear about who is going to control these accesses. The second piece of advice is to understand a lot about the low-level security to create profiles and data access features to allow the specific data to be seen only by a specific public.

Currently, in my organization, the greatest challenge is getting proper licensing. We have a little bit of resistance from our IT department who would like us to use Tableau more. It is not Microsoft's problem. It has more to do with the vendor of choice of the company, and they say that we have to use Tableau, but I don't want to use Tableau.

I would rate this solution a ten out of ten. It deserves this rating.

Which deployment model are you using for this solution?

Private Cloud

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Microsoft Azure
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Oscar Estorach - PeerSpot reviewer
Chief Data-strategist and Director at a consultancy with 11-50 employees
Real User
Top 5
Nov 29, 2020
Enables you to embed visualisation and reports into your applications
Pros and Cons
  • "It's a great tool for visualization data, and it's free for engineers."
  • "It is too slow. I hope in future it will be a comparable big data tool, such as, for example, Data Lake."

What is our primary use case?

Usually, when dealing with business intelligence projects with big data, all customers have Office 365 but within these licenses, Microsoft BI is often included.

How has it helped my organization?

The use case depends on the project. For example, in the logistics project, we need maybe four persons. For retail sales without stocks, it's a very easy project for us, but only for sales, and purchase orders, it's a standard part of the tool, to incorporate warehousing. Sometimes it's more difficult to clean the data if you have something like visualizations. It is often more difficult to understand what kind of data you need for the customer, or the strategy of the company who needs the information, to build a suitable solution. Customers often change their requirements. That's why Microsoft BI is more useful than traditional user tools, as it is flexible to changing requirements.

What is most valuable?

It's a great tool for visualization data, and it's free for engineers. Microsoft BI has a good online community. You don't need to be an engineer to use it. In Microsoft BI you can embed the visualisation and reports into your applications. Embedded items are much faster and cheaper to use. It's very easy to work with the customers using this kind of tool, rather than say, Oracle. I have used the personal edition, but some customers have been trained to use the professional version. Initially, I spent a lot of time learning the new system. As I was already experienced in other, similar technologies it was not difficult to understand the visualizations. I encouraged our clients to do more with Microsoft BI.

What needs improvement?

It should work faster and have more common languages so that you can use it more in different types of connections. It doesn't work well on big data. It is too slow. I hope in future it will be a comparable big data tool, such as, for example, Data Lake. It uses the DAX language, which is not used widely. Maybe they should develop this part of the tool to improve access to people who don't know DAX. Sometimes it needs to have a special configuration and hardware to connect to a data warehouse. So, interoperability with other systems could be improved.

For how long have I used the solution?

I began using it a few years ago. I was involved in testing and last year, I was tasked with some large projects in Azure which included databases, a data warehouse with SQL, and Azure SQL. It is a cloud-based service, which means that a project is easy to use and design. You can use different tools for different things, but all the visualization in Microsoft BI is all in one tool. 

What do I think about the stability of the solution?

Microsoft BI is stable and works consistently well. 

What do I think about the scalability of the solution?

Microsoft BI is a very scalable tool. You can start small and build up your project as you wish. 

How are customer service and technical support?

I used Microsoft Azure support because we have a project. I have a good relationship with Microsoft. I don't have any problems.

How was the initial setup?

It is easy to install Microsoft BI. You simply download and install it from the Microsoft Microsoft BI website, and it is available to download on windows. It can be downloaded and installed in 5 minutes.

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

Microsoft BI is free for the personal edition, but there is also a paid-for professional version. Setting up Microsoft BI is simple.

Which other solutions did I evaluate?

Oracle products are well-engineered but too heavy to accomplish small tasks. However, to use it for enterprise, you need to have a lot of knowledge about the different kinds of tools available. It has more flexibility but is more complex because it's designed for enterprise-level systems. Comparing this to Oracle which is at least 10 years old. Java is also old, but it's more structured. It's more proprietary.

What other advice do I have?

Every month Microsoft puts in another update. We are likely to use Microsoft BI in future projects. Microsoft BI does not fit every business case, so for that reason, I would give it an eight out of 10.

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?

Amazon Web Services (AWS)
Disclosure: My company has a business relationship with this vendor other than being a customer. Reseller
PeerSpot user
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.

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 technical 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
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
Buyer's Guide
Download our free Microsoft Power BI Report and get advice and tips from experienced pros sharing their opinions.
Updated: December 2025
Buyer's Guide
Download our free Microsoft Power BI Report and get advice and tips from experienced pros sharing their opinions.