Try our new research platform with insights from 80,000+ expert users
reviewer1759668 - PeerSpot reviewer
Associate Data Analyst at a financial services firm with 10,001+ employees
MSP
Jan 15, 2022
Provides infinite possibilities for visualizations and excellent integration
Pros and Cons
  • "Previously we used Excel, which took a long time - two or three weeks - to bring the data into a uniform format, whereas BI can do the same job in a day."
  • "I would like Microsoft to include some inbuilt machine learning so that it becomes point-and-click, rather than us developing models out of API and BI connecting to that and getting the results. That process gets in the way of continuity."

What is our primary use case?

I work in fraud analytics in the insurance industry and use Power BI for broader and high-level reports. We also do some fraud detection, and our output is sent to a Power BI dashboard for various clients to see. It's basically our visualization tool organization-wide.

What is most valuable?

The most valuable feature is the infinite possibilities when it comes to visualizations. If a particular visualization is not available as a default or in the market, you can just load in a Python nr script and get a visualization from that. It's very flexible in that respect and opens up a plethora of opportunities. The huge number of connectors that are available is also a big advantage - BI can connect to various things, even competitors like Google's Data Studio, and it is even able to connect to various Google data sources and be a powerful alternative to Data Studio. It's also a data modeling tool, so it keeps everything within the app, which is really convenient, allowing the pipeline to complete itself in a more fluid way.

What needs improvement?

In the next release, I would like Microsoft to include some inbuilt machine learning so that it becomes point-and-click, rather than us developing models out of API and BI connecting to that and getting the results. That process gets in the way of continuity.

For how long have I used the solution?

I've been using this solution for two years.

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,665 professionals have used our research since 2012.

What do I think about the stability of the solution?

Power BI's stability has improved in the last few years and now seems pretty good, especially with R.

What do I think about the scalability of the solution?

I don't know if BI is directly scalable, but we used a lot of aggregated marks in order to make sure it is able to work with a huge number of roles in the data set. Microsoft demonstrated that they were able to achieve up to one trillion rows, and we haven't got there, but we did get close.

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

Previously we used Excel, which took a long time - two or three weeks - to bring the data into a uniform format, whereas BI can do the same job in a day.

What other advice do I have?

If you're on Azure, Power BI is tightly integrated with many of the products. And even if you have a non-Azure solution, the family of connectors for data sources is wide, so you can fit it in many places. I would rate BI as nine out of ten.

Which deployment model are you using for this solution?

Public Cloud
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Technical Manager at a computer software company with 201-500 employees
Real User
Jan 13, 2022
User-friendly, feature-rich, and easy to implement but there is no column-level security
Pros and Cons
  • "This product has a lot of features and most of them are user-friendly."
  • "There is no column-level security in Microsoft BI, and this is a feature that most of our customers are looking for. That is something that should be implemented."

What is our primary use case?

We are a solution provider and Microsoft BI is one of the products that we implement for our customers.

What is most valuable?

Microsoft BI is easy to implement, as it is a web-based product that doesn't need to be installed.

This product has a lot of features and most of them are user-friendly.

The visualizations are pretty easy to create. In fact, if you want to create anything new, it is pretty easy to do.

The reporting capability is good.

What needs improvement?

There is no column-level security in Microsoft BI, and this is a feature that most of our customers are looking for. That is something that should be implemented.

For how long have I used the solution?

I have been working with Microsoft BI for between six and seven years.

What do I think about the stability of the solution?

This is a stable product.

What do I think about the scalability of the solution?

Microsoft BI is scalable.

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

We also use Oracle BI.

How was the initial setup?

The implementation process is pretty easy.

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

Both cost-wise and implementation-wise, this product is a good choice.

What other advice do I have?

This product is good in terms of cost, it is pretty easy to implement, and I can recommend it for those features and the reporting.

Overall, the product is good but there are a few limitations.

I would rate this solution a seven out of ten.

Which deployment model are you using for this solution?

Public Cloud
Disclosure: My company has a business relationship with this vendor other than being a customer. implementer
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,665 professionals have used our research since 2012.
reviewer1311126 - PeerSpot reviewer
Managing Partner at a tech services company with 51-200 employees
Real User
Jan 9, 2022
Great on the cloud, easy to expand, and have a good community around it
Pros and Cons
  • "The solution is stable."
  • "The cost of the solution can get high."

What is our primary use case?

We use Power BI in cloud solutions in other systems. There are lots of products in our environment that work with Power BI. One use case is we use it to track the real-time sensor data to Power BI using Azure.

We have lots of customers. We make premium subscription projects for them. We have a Tableau portion. We are also Tableau partners and resellers. As a company, we make lots of Tableau projects. 

What is most valuable?

The most powerful site of Power BI is the cloud site. You can do everything in power BI. There are lots of things that the solution provides. If you have a huge data warehouse in the cloud, Power BI fits. 

In some cases, there are some add-ons that you can put together in Power BI - for example, data factory, data bricks, and also data lakes. Some Microsoft solutions work together and are integrated already. You don't need to worry about that.  

If you know what you do, Power BI is a good solution.

The solution is stable. 

The product can scale. 

What needs improvement?

There are some limitations of Power BI. The front end, for example, is not fancy.

The solution should not be used in some cases. 

The cost of the solution can get high.

There is a strong community around the solution that can help users learn about the product and troubleshoot.

When we compare Power BI with other solutions, we can see there are lots of things that should be done. Some things are there, however, they are not working well. Microsoft puts lots of solutions in one place and declares it a complete solution. However, in the practice, you can see that this STK is not working properly or the request is not giving the same results. You discover that when you open a ticket to Microsoft. They will tell you that they are still in development on that product so it will available in the future. 

When you use the Power BI as an enterprise solution, as a consultant, you find out that the product is not fully ready for enterprise. In that way, we suffer a lot. That said,  every version becomes better.

They need to have an analytics suite of some sort.

For how long have I used the solution?

I've been working with BI solutions for 20 years. I've been using Power BI for two years so far.

What do I think about the stability of the solution?

The product is stable. For one of our customers, there are one thousand clients connecting to the same report. Everyone gets their own results and can search them. It needs more power. It can consume a lot of energy. 

What do I think about the scalability of the solution?

The scalability of the product is great. It's on the cloud, which makes it easy to scale. 

How are customer service and support?

There are good communities and groups that can help you troubleshoot if necessary.

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

I'm also familiar with Tableau.

We are SAP partners and resellers also. We make lots of SAP business intelligence solutions and do business intelligence projects.

How was the initial setup?

Step-by-step implementation is easy. The difficult part is when you enter the infrastructure site. There are lots of Power BI developers, however, they do not know the other cloud environment. In that way, they can only design the front site. That said, they should know the architecture. They should know the other infrastructure and know the data also. If they do, they can produce lots of things. As an example, Microsoft offers a flow integration so that you can create a data flow that consumes the data and give the results to other services. Also, there are lots of things that you can do, however, you need to know the Azure environment in order to do them. 

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

In some cases, Power BI can be expensive.

What other advice do I have?

We are using the current version of the solution.

I'd advise new users that there are lots of communities and lots of user groups that deal with the product. They should attend them. They should watch the videos about Power BI. It's important to extend your knowledge. If you want to be a Power BI developer, you should also know the other technologies as well.

I'd rate the solution at an eight out of ten.

Disclosure: My company has a business relationship with this vendor other than being a customer. Partner
PeerSpot user
reviewer1752738 - PeerSpot reviewer
BI and data chief consultant at a media company with 11-50 employees
Consultant
Jan 7, 2022
Allows you to create dashboard presentations
Pros and Cons
    • "We would like it if they added more Python libraries in the Power BI service. For Power BI service right now, you can use Python, but it is limited to a few libraries or a few packages from Python."

    What is our primary use case?

    We are implementing it for dashboard presentation. For example, one of our customers is in the energy sector. Another one is in the government sector, so it's dashboards mainly.

    What is most valuable?

    The ability to create dashboard presentations for various sectors is a valuable feature. It's an excellent product.

    What needs improvement?

    We would like it if they added more Python libraries in the Power BI service. For Power BI service right now, you can use Python, but it is limited to a few libraries or a few packages from Python. Other than that, it's an excellent product.

    Another area that could be improved is maybe more extensions or more visuals.

    For how long have I used the solution?

    I have been working with Power BI for four or five years. I am working with the latest version. It's a monthly release.

    What do I think about the stability of the solution?

    The solution is stable.

    What do I think about the scalability of the solution?

    Microsoft BI is scalable.

    What other advice do I have?

    I would rate this solution 9 out of 10.

    For someone who is looking into implementing this product, my advice is to check between the two versions because Microsoft Power BI is not one solution. You have one solution which is coming with SQL services on-prem and you have the cloud solution. You need to check because there are differences in the features. Anyone who is implementing Power BI needs to be careful on which platform they're using: on-premise or on the cloud. There is a difference in the features between the two solutions.

    Disclosure: My company has a business relationship with this vendor other than being a customer. Implementer
    PeerSpot user
    reviewer1128801 - PeerSpot reviewer
    Director of Analytics and Cognitive Computing at a consultancy with 11-50 employees
    Real User
    Jan 7, 2022
    Quick chart building tools, responsive technical support, but more attractive charts needed
    Pros and Cons
    • "The solution is easy to use and charts can be built quickly with the tools."
    • "The solution could improve by having more attractive graphical charts."

    What is our primary use case?

    We use Microsoft BI for dashboards and monitoring tools and dashboards. We mostly use it to produce charts and graphs for our customers.

    What is most valuable?

    The solution is easy to use and charts can be built quickly with the tools.

    What needs improvement?

    The solution could improve by having more attractive graphical charts.

    For how long have I used the solution?

    I have been using Microsoft BI for two and a half years.

    What do I think about the stability of the solution?

    Microsoft BI has been stable in my usage.

    What do I think about the scalability of the solution?

    The scalability of Microsoft BI is good.

    We have approximately 2,000 users using this solution.

    How are customer service and support?

    The technical support is very good, they have been available when we needed them.

    How was the initial setup?

    The installation is straightforward.

    What other advice do I have?

    My advice to others would be to compare Microsoft BI to all the other similar solutions and see what fits their use case best. If they're looking for nice looking charts then perhaps, they should compare this solution to the others. If you are looking for a solution that is easy to use and quick to learn then Microsoft BI could be the right fit.

    I rate Microsoft BI a seven out of ten.

    Disclosure: My company has a business relationship with this vendor other than being a customer. Implementer
    PeerSpot user
    PeerSpot user
    Manager, BI & Analytics at a consultancy with 11-50 employees
    Real User
    Jan 6, 2022
    Simple to use but interface could be more intuitive

    What is our primary use case?

    The primary use cases for Microsoft BI are typical for business intelligence, including operational monitoring and KPI tracking.

    What is most valuable?

    Microsoft BI is easy to use and simple.

    What needs improvement?

    The user interface could be a bit more intuitive. Some parts of the user interface could be a bit more intuitive so that it's a bit easier to use.

    For how long have I used the solution?

    I have been using Microsoft BI for the past four 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 fairly scalable.

    How are customer service and support?

    I have not really had to contact Microsoft BI. I think my use cases so far have been pretty simple so I did not feel the need to interact with them.

    How was the initial setup?

    The initial setup takes only a few minutes. It's just a matter of downloading the file and installing it.

    Once it is installed, it takes minimal involvement from a maintenance perspective. It runs on its own.

    What about the implementation team?

    We deployed Microsoft BI in-house. We did not need a vendor team to come in. 

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

    We are not paying any licensing fees for our current Microsoft BI setup. The version that we are using is free of cost unless you wish to deploy it on a server; that is where the cost component comes in.

    What other advice do I have?

    I recommend Microsoft BI. 

    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
    reviewer1722714 - PeerSpot reviewer
    Operations Center Technician at a renewables & environment company with 501-1,000 employees
    Real User
    Jan 6, 2022
    The visualization is convenient and easy to use.
    Pros and Cons
    • "I like that I can use Power BI to upload data. That is very important for me. The visualization is also convenient and easy to use."
    • "I like that I can use Power BI to upload data. That is very important for me. The visualization is also convenient and easy to use."
    • "The maps in Power BI could be improved. You deal with many maps over the years, like maps of America and Saudi Arabia. The maps aren't detailed enough, and there aren't enough visualization tools. Whenever I want to use a map, I struggle with choosing the right visualization."

    What is our primary use case?

    We use Power BI for dashboards and various reports. It's primarily a visualization tool. We don't use it for business intelligence— just visualization.

    What is most valuable?

    I like that I can use Power BI to upload data. That is very important for me. The visualization is also convenient and easy to use.

    What needs improvement?

    The maps in Power BI could be improved. You deal with many maps over the years, like maps of America and Saudi Arabia. The maps aren't detailed enough, and there aren't enough visualization tools. Whenever I want to use a map, I struggle with choosing the right visualization.

    For how long have I used the solution?

    We've been using Microsoft BI for about three years now.

    What do I think about the scalability of the solution?

    Microsoft BI is scalable. There are some limitations depending on the amount of data you need, but it's enough for me so far. We have about 50 users, and we'll likely increase our usage in the coming years as Microsoft adds more features and our people train themselves to do more with it. 

    How was the initial setup?

    Setting up Microsoft BI is straightforward. It took about one week if you include training on how to send reports and other things. We were able to do it by ourselves with a team of about five people. 

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

    The license is annual. If you need a fancy visualization, you have to pay a bit more, but a valid license covers everything else. I'm developing reports and rolling them out to some users who are not developers, so I need the visualization and have to pay for the license. In the case of Tableau, you don't need to pay, or maybe you spend a little less because you're not a developer. 

    What other advice do I have?

    I rate Microsoft BI 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
    Dhammika Weerakoon - PeerSpot reviewer
    Solutions Area Lead at a tech consulting company with 501-1,000 employees
    Reseller
    Top 10
    Jan 6, 2022
    Stable and scalable solution for data reporting
    Pros and Cons
    • "I've seen no issues with BI's stability."
    • "BI is scalable, but there are some problems with limited online storage."

    What is our primary use case?

    My primary uses of this solution are BI reporting using SQL server reporting, Power BI online reports, and BI dashboards. We connect to SQL server databases plus other sources, including data warehouses in the cloud and on-premise.

    What needs improvement?

    There are areas where BI lags behind its competitors - for example, Qlik has an in-built data manipulation engine while BI does not. I also do not like transformation in BI, as we have to go back to the data for this process instead of being able to do things on the fly, as with Qlik. Other areas for improvement include the language that BI uses, the ability to do data manipulations, and the flexibility of the licensing models. In the next release, I would like to see manipulation and internal analytics, as well as some analytics features.

    For how long have I used the solution?

    I've been using this solution for four years.

    What do I think about the stability of the solution?

    I've seen no issues with BI's stability.

    What do I think about the scalability of the solution?

    BI is scalable, but there are some problems with limited online storage and always having to go back to the data warehouse.

    What other advice do I have?

    I would rate this solution as eight out of ten.

    Disclosure: My company has a business relationship with this vendor other than being a customer. Implementer
    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.