Try our new research platform with insights from 80,000+ expert users
Lead Statistical Analyst | Innovation Champion at a pharma/biotech company with 10,001+ employees
Real User
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.

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

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 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 Kathmandu
Real User
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
Microsoft Power BI
August 2025
Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: August 2025.
865,384 professionals have used our research since 2012.
Software Engineer at Lorenzo Imperatrice
Real User
Top 10
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
    Top 5Leaderboard
    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
    Carlos Mardinotto Junior - PeerSpot reviewer
    BI Expert at a financial services firm with 1,001-5,000 employees
    Real User
    Top 10
    Fast and user friendly
    Pros and Cons
    • "You don't need much support with Microsoft Power BI because it has such a large base of users who can answer your questions on their forums. There are also many video tutorials and webinars available online that offer solutions to whatever problems you may have."
    • "Microsoft is behind IBM when it comes to security features."

    What is our primary use case?

    I've used it for work I did with three clients in the Brazilian banking sector: 
    Bank Bradesco, B&B Bank, and the Regional Bank of Brazil.

    What is most valuable?

    It's very fast and user-friendly.

    What needs improvement?

    Microsoft is behind IBM when it comes to security features.

    For how long have I used the solution?

    I've used Microsoft Power BI for about three years with different clients.

    How are customer service and support?

    You don't need much support with Microsoft Power BI because it has such a large base of users who can answer your questions on their forums. There are also many video tutorials and webinars available online that offer solutions to whatever problems you may have.

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

    I use Cognos Analytics 11 for some projects, but many of my clients prefer Microsoft Power BI because it is less expensive.

    Which deployment model are you using for this solution?

    On-premises
    Disclosure: My company does not have a business relationship with this vendor other than being a customer.
    PeerSpot user
    Fabio Xavier - PeerSpot reviewer
    Director of Systems of the TCESP at a government with 501-1,000 employees
    Real User
    Useful drag and drop function, straightforward implementation, and high availability
    Pros and Cons
    • "The most valuable features in Microsoft BI are the analysis using the feature drag and drop function. It's very easy to load and use different data sources."
    • "Microsoft BI could improve by allowing large-size data sources. We have large data sources, and we have problems loading them in Microsoft BI."

    What is our primary use case?

    We use Microsoft BI to construct panels and analysis for the final users by themselves. We have all the units outside and analyses made by the final users. They can share their work with other colleagues and other teammates easily.

    What is most valuable?

    The most valuable features in Microsoft BI are the analysis using the feature drag and drop function. It's very easy to load and use different data sources.

    What needs improvement?

    Microsoft BI could improve by allowing large-size data sources. We have large data sources, and we have problems loading them in Microsoft BI.

    I would like to see in a future release the ability to create rules with no code. Similar to drag-and-drop solutions, or some other way with no code.

    For how long have I used the solution?

    I have been using Microsoft BI for approximately two years.

    What do I think about the stability of the solution?

    The solution is reliable, we do not have a problem with the availability.

    What do I think about the scalability of the solution?

    Microsoft BI is a scalable solution.

    We have approximately 500 users using this solution in my organization. We have plans to increase the use of the solution. Our employees are getting better with the ability to use the solution.

    How are customer service and support?

    The support from Microsoft is satisfactory.

    How was the initial setup?

    The initial setup of Microsoft BI was straightforward.

    What other advice do I have?

    I would encourage others to use Microsoft BI, it is a good solution.

    I rate Microsoft BI a nine out of ten.

    Disclosure: My company does not have a business relationship with this vendor other than being a customer.
    PeerSpot user
    reviewer1792206 - PeerSpot reviewer
    Software developer
    Real User
    Stable solution, but interface could be improved
    Pros and Cons
    • "The stability is good."
    • "The interface could be improved."

    What needs improvement?

    The interface could be improved.

    For how long have I used the solution?

    I have been using this solution for three years.

    What do I think about the stability of the solution?

    The stability is good.

    What do I think about the scalability of the solution?

    The scalability is good.

    What other advice do I have?

    I would rate this solution 8 out of 10.

    Disclosure: My company does not have a business relationship with this vendor other than being a customer.
    PeerSpot user
    reviewer1330689 - PeerSpot reviewer
    Client Director, Head of Sales & Marketing, Partner at a tech services company with 11-50 employees
    Real User
    Very smooth, has matured a lot; great scalability
    Pros and Cons
    • "Implementation is very quick and the solution is very user-friendly."
    • "Automation could be improved and performance enhanced."

    What is our primary use case?

    We are a consultant company, so we use BI for project follow-up, sales and pipeline. We are partners with Microsoft and I'm the company's client director.

    What is most valuable?

    I like that implementation is very quick and that the solution is very user-friendly and easy to work with. The solution has provided us with speedy insight and faster effects on the table. It's a smooth product. 

    What needs improvement?

    I think that automation could be improved and performance enhanced. Documentation for developers could also be improved. 

    What do I think about the stability of the solution?

    The solution is stable. 

    What do I think about the scalability of the solution?

    Scalability is very good. It can be pricey to move to the P1 licenses for $5,000 a month for smaller companies, but there are workarounds using A1 to A6 licenses which are cheaper and more flexible in the pricing. We have 50 users in the company. 

    How was the initial setup?

    When we deployed five years ago, the setup was very complex. Since then, it's become much easier. 

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

    Compared to competitors like Tableau, Microsoft BI is not so expensive.

    What other advice do I have?

    I recommend this solution. Microsoft BI has matured a lot in the last year.

    I rate this solution nine 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?

    Microsoft Azure
    Disclosure: My company has a business relationship with this vendor other than being a customer. Partner
    PeerSpot user
    Buyer's Guide
    Download our free Microsoft Power BI Report and get advice and tips from experienced pros sharing their opinions.
    Updated: August 2025
    Buyer's Guide
    Download our free Microsoft Power BI Report and get advice and tips from experienced pros sharing their opinions.