No more typing reviews! Try our Samantha, our new voice AI agent.
Sumit_Gupta - PeerSpot reviewer
Freelancer at a tech services company with 1,001-5,000 employees
Real User
Top 10
Nov 10, 2020
Easy to use, good inquiry and visual gallery features, and the community is strong
Pros and Cons
  • "This is a self-service BI tool, so it doesn't require a huge amount of technical training, knowledge, or a background in BI in order to induct new people into it."
  • "My advice for anybody who is considering this tool is that if you want to move to a self-service BI, this is probably the best tool available right now."
  • "A lot of people work on Excel, so being able to export an Excel file as part of a subscription would be an improvement."
  • "I would like to have the capability to schedule exports in different versions."

What is our primary use case?

We primarily use Power BI for data science solutions.

How has it helped my organization?

This is a self-service BI tool, so it doesn't require a huge amount of technical training, knowledge, or a background in BI in order to induct new people into it. This is true even for business people who want to do a little bit of self-service. The whole thing has become quite simplified, as compared to what it was.

What is most valuable?

There are many good features in this product.

The most valuable features are a combination of the DAX and the inquiry capability, plus the visual gallery that we have. I think that these three things, or the combination of them, is the best that we have found.

What needs improvement?

I would like to have the capability to schedule exports in different versions. For example, if I want to schedule a subscription and attach an Excel file, we don't have this capability right now. A lot of people work on Excel, so being able to export an Excel file as part of a subscription would be an improvement.

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

For how long have I used the solution?

We have been working with Power BI for more than five years.

What do I think about the stability of the solution?

Overall, it is pretty stable. The cloud version is definitely very stable, and I have found very few flaws or areas for improvement. We have been using it for more than five years and we have every intention to continue with it.

What do I think about the scalability of the solution?

It has been pretty nice for us, in terms of scalability. There hasn't really been a problem, as such. We have approximately 300 users.

How are customer service and support?

Technical support from Microsoft gets a big thumbs up from me. They have blogs, a support page, and the community is very active. Most of the answers we need, we find them there. 

With this amount of information available, we don't need to use technical support extensively. When we do post something on the blog or in the community, the response that we get is pretty prompt.

The last time we utilized technical support was when we were investigating creating a subscription with an Excel file attached to it. We found out that it isn't yet possible with the current version.

How was the initial setup?

The initial setup is straightforward, to say that least. It took just a few days to deploy.

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

The pricing is very reasonable compared to any other tool.

What other advice do I have?

My advice for anybody who is considering this tool is that if you want to move to a self-service BI, this is probably the best tool available right now. The self-service is pretty good in terms of os user acceptance, usage, and simplicity. It is something that everybody wants and Power BI does really well in that area.

The biggest lesson that I have learned from using Power BI is that if the data is not according to what you want, that really isn't a problem. It has been a problem in the past, especially where the data is not in the form or the shape that you need, but with Power BI, that problem can be solved very easily.

I would rate this solution an eight out of ten.

Which deployment model are you using for this solution?

Public Cloud

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

Microsoft Azure
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Co-Founder at Beta Edge Technology Limited
Real User
Oct 31, 2020
Reasonably-priced and promotes collaboration through good shareability features
Pros and Cons
  • "The most valuable feature is shareability, where we can publish work to the cloud and share it with team members."
  • "In terms of stability, this product has never failed me."
  • "I think that they can add more types of charts because the selection on the desktop version is limited."

What is our primary use case?

We use this solution to analyze financial statements from our partners.

We build dashboards to see information on a product that is offered by one of our local telcos.

What is most valuable?

The most valuable feature is shareability, where we can publish work to the cloud and share it with team members. If you want to build a dashboard then you can publish it to the cloud, and then add people. This will give them access to the dashboard where they can review it, and modify it as well.

They have a mobile option that allows you to see the dashboard from your mobile phone, rather than having to look at your laptop.

What needs improvement?

I think that they can add more types of charts because the selection on the desktop version is limited.

I would like to see an option for adding audio to the visualizations. 

They need to add support for putting emojis into the dashboards.

For how long have I used the solution?

We have been using Power BI for the past two or three years.

What do I think about the stability of the solution?

In terms of stability, this product has never failed me. I have not experienced any bugs or glitches.

What do I think about the scalability of the solution?

The scalability is good. They allow for multiple types of data sources, so if you grow your databases or you change your data sources, it's easy to add them to the tool visually.

We are a startup with four people, and everybody is using it. We are proposing it to our clients in cases where we are selling analytics because it's a good option for them.

How are customer service and technical support?

I have not had a reason to speak with technical support, although I've looked at the community. They do have additional features that you can download from the site, as well. I have not a problem in terms of support.

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

I used Tableau in 2016, but I decided not to use it in this startup company because they don't have a free option. They do have a trial version, but that expires and I would have to then look for another solution.

With Microsoft BI, they have a free desktop version. 

I have also used Cognos BI before, although it was a bit complicated. This is another reason that I settled on Microsoft BI.

How was the initial setup?

The installation is direct and quite easy to do. The instructions are available online and they are easy to follow.`

What about the implementation team?

I completed the deployment myself.

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

We are using the free desktop version of this product.

Once the trial period for the BI service is over, the cost is approximately $10 USD per user, per month, so it's quite reasonable.

What other advice do I have?

My advice for anybody interested in using Microsoft BI is to set up the desktop version. It's good to start off with, it's easy to learn, and they get the trial period for the BI service. Then, once they're done with the trial period, I think the licensing per month is quite affordable.

In summary, this is a good solution. It is not perfect, although if they added audio, emojis, and more types of graphs, then it would be.

I would rate this solution a nine out of ten.

Which deployment model are you using for this solution?

Hybrid 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
June 2026
Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: June 2026.
902,270 professionals have used our research since 2012.
reviewer1159494 - PeerSpot reviewer
Advisory Software Engineer at a tech services company with 1,001-5,000 employees
Real User
Oct 29, 2020
Interactive, user friendly, and efficient in terms of performance
Pros and Cons
  • "The best thing about this solution is that it is very user friendly. It is interactive in terms of visualizations. It is very eye-catching, and it attracts users. There are a lot of options to visualize the data in different drafts and views. I have used different visualization tools, and I found Power BI to be more efficient in terms of performance, user-friendliness, and ease of use."
  • "A few features available in Tableau are not available in Power BI. For example. Tableau has the ability to make up the physical layer and all other stuff at runtime. In Power BI, we have to develop a proper physical layer to connect it. The limitation that we normally face is related to the direct query mode. When it comes to the direct query mode, most of the functionality is not working, which is an issue for us. We have to use the direct query mode frequently because the client needs real-time data. They should work on this limitation. There are a lot of other technical things that need to be improved. I am also following the Power BI platform and Microsoft Support Center platform on the web where users have put their requirements. Microsoft is also working on improving this solution. In every update, they add new features to this solution."
  • "The limitation that we normally face is related to the direct query mode. When it comes to the direct query mode, most of the functionality is not working, which is an issue for us."

What is most valuable?

The best thing about this solution is that it is very user friendly. It is interactive in terms of visualizations. It is very eye-catching, and it attracts users. There are a lot of options to visualize the data in different drafts and views. 

I have used different visualization tools, and I found Power BI to be more efficient in terms of performance, user-friendliness, and ease of use.

What needs improvement?

A few features available in Tableau are not available in Power BI. For example. Tableau has the ability to make up the physical layer and all other stuff at runtime. In Power BI, we have to develop a proper physical layer to connect it.

The limitation that we normally face is related to the direct query mode. When it comes to the direct query mode, most of the functionality is not working, which is an issue for us. We have to use the direct query mode frequently because the client needs real-time data. They should work on this limitation.

There are a lot of other technical things that need to be improved. I am also following the Power BI platform and Microsoft Support Center platform on the web where users have put their requirements. Microsoft is also working on improving this solution. In every update, they add new features to this solution.

For how long have I used the solution?

I have been using this solution for more than four years.

What do I think about the stability of the solution?

It is stable. I haven't found it hanging. It consumes a lot of memory on the local system but not while developing the reports. It also depends on the data on which we are working, but generally, it is light and stable.

How are customer service and technical support?

My overall experience with Microsoft is actually quite good. We have contacted their technical support once or twice. It was something related to the Power BI visualization, where we needed to visualize some data, but they had some kind of limitation in personalization. We also wanted to connect Power BI with other servers, but we were facing some performance issues. The reports were not working fine. I don't think they managed to solve our issues.

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

I have worked on SiteSense and Oracle OBIEE. I feel more satisfied when I'm working with Power BI. It is more convenient as compared to other solutions.

How was the initial setup?

The initial setup is easy. I didn't find any complexity in it. It can be difficult if the end users don't know how to use it. If they are trained on it, then after a week or a month, it gets easier for the end users. 

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

Its cost seems to be unreasonable if you have many users, but for a lesser number of users, it is reasonable. It is $10 per month. Clients easily accept this option, so they must think it is reasonable. 

It is quite cheap as compared to other tools, such as Tableau. One of the best things about this solution is that it has a trial version.

What other advice do I have?

I would 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
reviewer1413633 - PeerSpot reviewer
Head of Digitalization at a mining and metals company with 5,001-10,000 employees
Real User
Oct 27, 2020
Seamlessly integrates with Microsoft products, but can be made simpler to operate
Pros and Cons
  • "Its seamless integration with Microsoft products, such as Microsoft SQL Server or Microsoft Excel, is the most valuable."
  • "They can provide a user-friendly and easy way to use this tool for people who don't know about programming or technical things. It will be quite good if they can improve the look and feel and make it simpler to operate. They can make it easier to create some of the reports. They can also include predefined templates that you can directly use."

What is our primary use case?

It is mostly used for monthly cost reports for our department. We are also using it as a dashboard for giving some overview for management purposes. We are using the latest version.

What is most valuable?

Its seamless integration with Microsoft products, such as Microsoft SQL Server or Microsoft Excel, is the most valuable.

What needs improvement?

They can provide a user-friendly and easy way to use this tool for people who don't know about programming or technical things. It will be quite good if they can improve the look and feel and make it simpler to operate. 

They can make it easier to create some of the reports. They can also include predefined templates that you can directly use.

For how long have I used the solution?

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

What do I think about the stability of the solution?

Stability is quite good as long as you have proper sizing from the beginnings. If you do the right sizing keeping in mind the current usage as well as future growth, it is good.

What do I think about the scalability of the solution?

It is scalable. We have around 65 seniors managers who use it on a weekly or monthly basis. Some reports are done weekly and some monthly.

How are customer service and technical support?

I have not contacted them so far. I am from the user side. We contact our centralized IT department for any issues. If they have a technical issue that requires further escalation, they will directly contact Microsoft technical support.

How was the initial setup?

The initial setup is quite simple, but for the product use, you need to have people who have got experience of at least three to six months in using these applications. It took us two months to deploy across the company.

What about the implementation team?

We have a core team that gets training from a Microsoft partner. We then deploy it ourselves. After six months of using this solution, some of the key users get advanced training. 

We also maintain it ourselves. We have around ten people for its maintenance.

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

It is somewhere in the middle in terms of price. Licensing is quite clear.

Which other solutions did I evaluate?

We reviewed some other intelligence tools, and we just used them for trials.

What other advice do I have?

I would recommend this solution, especially for the companies that mostly use Microsoft products and ecosystem. I would rate Microsoft BI a seven out of ten.

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
Business Intelligence Developer at Kathmandu
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
PeerSpot user
Consultor at Pricewaterhousecoopers Auditores Independentes
Real User
Apr 12, 2020
Integrates data onto dashboards to help managers make better decisions
Pros and Cons
  • "PowerBi is used to import our production data and generate dashboards, then integrates other Excel sheets to provide managers dashboards. This helps them get insights to make better OEE improvement decisions, mainly where to focus resources. We became able to see indicators from any time frame (day, week, month, or year), then could make better decisions."
  • "Real-time updating needs improvement."

What is our primary use case?

Daily updated production indicators dashboard: We get production data (Number of pieces, downtime, and downtime reasons) from the shopfloor and input them on an Excel sheet. 

How has it helped my organization?

PowerBi is used to import our production data and generate dashboards, then integrates other Excel sheets to provide managers dashboards. This helps them get insights to make better OEE improvement decisions, mainly where to focus resources. We became able to see indicators from any time frame (day, week, month, or year), then could make better decisions.

With this solution, we were able to know which problems were critical and chronic. Once we used Power BI for production management, we realized that we could also use it for quality assurance, finance, and others types of management.

What is most valuable?

Interactive graphs are its most valuable feature.

What needs improvement?

Real-time updating needs improvement.

For how long have I used the solution?

Two years.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Vice President - HSE Engineering at Reliance Industries Ltd
Real User
Feb 25, 2020
Identifies customer purchasing patterns and provides good visualization
Pros and Cons
  • "It has provided customer purchase patterns and great visualization."
  • "This solution has provided an accurate analysis of our customers repurchasing the same plan for telecom Jio, providing customer purchase patterns and great visualization."
  • "This solution needs integration with SAS and more deep analysis functionality."

What is our primary use case?

Our primary use for this solution is geospatial analysis.

How has it helped my organization?

This solution has provided an accurate analysis of our customers repurchasing the same plan for telecom Jio. It has provided customer purchase patterns and great visualization.

What is most valuable?

The most valuable features are the visualization and integration with Office365.

What needs improvement?

This solution needs integration with SAS and more deep analysis functionality.

For how long have I used the solution?

I have been using Microsoft BI for five years.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Data Scientist at Packen SAS
Real User
Jan 15, 2020
Automation of real-time and batch analytics are fast and help us to better explain our data
Pros and Cons
  • "This solution has improved our ability in making decisions and explaining data."
  • "We would like to have better SQL support for queries."

What is our primary use case?

Our primary use is real-time & batch analytics on Postgres databases in combination with MS Excel.

How has it helped my organization?

This solution has improved our ability in making decisions and explaining data.

What is most valuable?

The most valuable features are the automation of analysis and already prepared tools to do the analytic work rapidly.

What needs improvement?

We would like to have better SQL support for queries. It means to have a kind of development environment trying to correct bad sintax in SQL query, or having an intellisense like style for code completion being aware of table's fields and having a preview of the query response without needing to run the whole procedure. 

For how long have I used the solution?

We have been using Microsoft BI for two months.

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

Previously we used MS Excel but continue using it mainly for prototyping.

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

Power BI free layer is attractive and second stage with Power BI online is not expensive.

Which other solutions did I evaluate?

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?

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
BI Analyst at eVision Industry Software
Real User
Dec 8, 2019
Easy to use, good self service functionality, facilitates collaboration with other users
Pros and Cons
  • "If you are not very technical this tool could be very useful."
  • "Power BI is a great tool for analytics; it is useful if you have a requirement to create a dashboard with self-service capability, along with KPIs, and you want to drill down to the data details."
  • "Adding paginated reports to this tool could be of great help for users who want to move away from SSRS."

What is our primary use case?

Power BI is a great tool for analytics. It is useful if you have a requirement to create a dashboard with self-service capability, along with KPIs, and you want to drill down to the data details.

How has it helped my organization?

I have tried SSRS and later moved to Power BISSRS requires every analytical feature to be implemented separately. However, with the appropriate granularity of data, you can drill down and drill up easily which gives you a different view of the dashboards. Now with having on-premises availability, it makes this tool even more powerful.

What is most valuable?

If you are not very technical this tool could be very useful.

The most valuable features are:

  • Self service
  • Inbuilt analytics
  • Custom visualization
  • Printing of dashboard helps a lot
  • Dashboard scheduling
  • Easy collaboration with other users on Power BI
  • Learning curve for this tool is small
  • Dashboard refresh rate can be configured
  • Power BI works both on-premises and cloud

What needs improvement?

Adding paginated reports to this tool could be of great help for users who want to move away from SSRS. 

I would like to see built-in Git support, incremental loading of data, and a machine learning model for predictive analysis.

Custom colouring from the dashboard itself would be helpful.

For how long have I used the solution?

I have been using Microsoft BI, SSRS, and Power BI for four years.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
it_user1212726 - PeerSpot reviewer
Microsoft Dynamics Specialist at a computer software company with 51-200 employees
Real User
Oct 27, 2019
Good reporting, and provides data insights that help to improve efficiency and profit
Pros and Cons
  • "The feature I find most valuable is the ability to publish Power Bi reports, using an embedded link, directly onto a website."
  • "The most significant implementation was to reduce the Financial consolidation time for one hundred and twenty companies into one shareholder report, from thirty days to four minutes."
  • "I would like to see Machine Learning for Power Bi Pro users or an intermediate license to enable Machine Learning if you don't have access to a Premium account."

What is our primary use case?

I have developed and deployed more than twenty separate customer solutions. I am a Business Intelligence Deployment Specialist. The most significant implementation was to reduce the Financial consolidation time for one hundred and twenty companies into one shareholder report, from thirty days to four minutes.

How has it helped my organization?

We help customers deploy and analyze sophisticated analytics models. These models have helped them all to get a better insight into their data and many of them have found very valuable insights that made them more profitable, more efficient, and in some cases changed the direction of the business.

What is most valuable?

The feature I find most valuable is the ability to publish Power Bi reports, using an embedded link, directly onto a website. Data that is not classified as confidential can very easily be exposed to customers, vendors, or even just visitors to the web site.

What needs improvement?

I would like to see Machine Learning for Power Bi Pro users or an intermediate license to enable Machine Learning if you don't have access to a Premium account.

The minimum embedded capacity for Machine learning is currently an A3 capacity, and this should be reduced to include A1 level licenses.

For how long have I used the solution?

I have been using this solution for three years.
Disclosure: My company has a business relationship with this vendor other than being a customer. Microsoft Gold 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: June 2026
Buyer's Guide
Download our free Microsoft Power BI Report and get advice and tips from experienced pros sharing their opinions.