Try our new research platform with insights from 80,000+ expert users
Project Manager at GlaxoSmithKline
Real User
Very good toggling feature; unfortunately some performance issues and inability to aggregate
Pros and Cons
  • "The solution has a good toggling feature."
  • "Lacks the ability to copy data from BI into PowerPoint."

What is our primary use case?

I'm a project manager and we are customers of Microsoft.

What is most valuable?

I like the toggling feature, the ability to switch from one page to another. 

What needs improvement?

I have a couple of dashboards that are weekly and monthly. I was able to download the dashboard, but I cannot paste any images into PowerPoint. There are also visuals based on the brand that should automatically pop up in the graph and which should be a toggling option. And I'm having performance issues if I want to add two or three tables at a time, which I could easily do in Tableau. Copy-pasting data to PowerPoint for presentation to the executive level should be easy but we're only able to copy the visual, not the underlying data. 

For how long have I used the solution?

I've been using this solution for the past eight months. 

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

What do I think about the scalability of the solution?

The solution is scalable but we haven't yet migrated everyone to Power BI. Our users are not finding Power BI as good as Pique, which perhaps they're just more used to. They're trying but some of the features available in Pique are not there so they are not comprehensively using it. It's being used mainly for internal analysis for now. 

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

We initially used Tableau because our data was an internal data source, and now all of our data is migrated to tool environments, that the Power BI is more comfortable with. BI is also a free product which is another reason the company recommends it.

How was the initial setup?

The initial setup was straightforward, we have a Power BI admin team who take care of all that. 

What other advice do I have?

Because of performance issues and because we're unable to do all the aggregation, I rate this solution six out of 10. 

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: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Oscar Estorach - PeerSpot reviewer
Chief Data-strategist and Director at Theworkshop.es
Real User
Top 10
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
Buyer's Guide
Microsoft Power BI
April 2025
Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: April 2025.
850,671 professionals have used our research since 2012.
Esteban Fabiani - PeerSpot reviewer
Project and Consultant Manager at a consultancy with 1-10 employees
Consultant
Top 10
Offers comprehensive features, user-friendly interface, and strong community support
Pros and Cons
  • "The most valuable feature of Power BI is its ability to provide customized visualizations and insights tailored to specific business needs."
  • "Areas of Power BI that could be improved are the learning curve for developers who come from non-technical backgrounds."

What is our primary use case?

Across retail, logistics, legal, finance, and more, I use Power BI to craft custom solutions. From analyzing sales to optimizing operations, Power BI helps me extract actionable insights for informed decision-making across diverse industries.

How has it helped my organization?

I'm working with a law firm that has hundreds of professionals working across various areas for different clients. They struggle to accurately track hours worked per client and compare profitability. With Power BI, I can integrate data from their ERP systems and create insightful reports. These reports not only show the hours worked per client but also compare profitability between clients and highlight KPIs. By providing clear and actionable insights, Power BI helps the firm make informed decisions quickly, leading to improved profitability and efficiency.

What is most valuable?

The most valuable feature of Power BI is its ability to provide customized visualizations and insights tailored to specific business needs. By offering a range of visualization options and customization capabilities, Power BI enables users to quickly analyze data and gain actionable insights. Depending on the preferences and requirements of the customer, different visualization styles can be utilized, from simple and standardized views to more colorful and dynamic charts and graphs.

What needs improvement?

Areas of Power BI that could be improved are the learning curve for developers who come from non-technical backgrounds. While Power BI is a powerful tool, mastering its development aspects, including coding and formulas, can be challenging for those without a technical background. Additionally, some users find the default visualizations in Power BI Desktop to be outdated and prefer more modern and customizable options. 

One additional feature I would like to see in Power BI is tighter integration with Power Apps. This would allow for easier development without extensive coding, making it more accessible for users who aren't familiar with technical aspects like JSON files or Visual Studio Code. Simplifying the development process would streamline workflow and enhance overall usability.

For how long have I used the solution?

I have been working with Microsoft Power BI since 2016.

What do I think about the stability of the solution?

I would rate the stability of Power BI at around nine out of ten. It has been consistently reliable over the past year, and any bugs are quickly addressed by a supportive community.

What do I think about the scalability of the solution?

Power BI is scalable, but its scalability depends on factors like the amount of data, infrastructure, and database type. For large BI data, other tools might be more suitable. However, Power BI offers great flexibility, and its scalability varies based on specific needs and circumstances.

How are customer service and support?

The technical support for Power BI is generally good, but it can be limited in handling diverse customer needs. While Microsoft technicians are highly knowledgeable, they may provide standard solutions based on their expertise, which might not cover all possible scenarios. Finding solutions often requires additional research, practice, and exploration of community resources. Overall, I would rate the support at a nine out of ten.

How would you rate customer service and support?

Positive

How was the initial setup?

Deploying Power BI isn't difficult, but it requires time and experience. With regular updates and new features from Microsoft, staying current and understanding changes can be a continuous learning process. While it is manageable with experience, teaching someone from scratch would require significant time and effort.

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

The price of Power BI is very good. It is reasonable.

What other advice do I have?

Power BI has revolutionized our reporting and decision-making processes. Instead of spending hours manually working with static data in Excel, we now have dynamic information at our fingertips. With Power BI, we can quickly make queries, access answers, and generate reports in minutes. By efficiently extracting data from databases and creating visually appealing visuals, such as KPI dashboards, Power BI enables us to identify trends, compare data, and make informed decisions promptly. It streamlines the entire process, from data extraction to visualization, saving us time and providing valuable insights for effective decision-making.

My advice for someone looking to use Power BI would be to start with the Pro license, as it is usually sufficient for most users. If you are dealing with a large number of customers, consider consulting with a Microsoft partner to find the best licensing solution. Based on my experience, I would recommend Power BI to others. Overall, I would rate the product as a nine out of ten.

Which deployment model are you using for this solution?

Public Cloud
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
IT Project Manager at a manufacturing company with 10,001+ employees
Real User
Not user-friendly and the support could be better, but the real-time reporting is good
Pros and Cons
  • "The most valuable feature of this solution is real-time report tracking."
  • "It's not user-friendly; more tutorials, training, and better documentation would be helpful."

What is our primary use case?

We use this solution for dashboards and reporting.

We work in manufacturing and we track any incidents that we have regarding safety.

What is most valuable?

The most valuable feature of this solution is real-time report tracking. For example, we have a report for a human body and the human body is populated with injury data. In real-time, we can see where most of the injuries have occurred. 

What needs improvement?

It is a difficult tool to use and it's hard to figure it out.

It's not user-friendly; more tutorials, training, and better documentation would be helpful.

For how long have I used the solution?

I have been using Microsoft BI for three months.

We are running the latest version.

What do I think about the stability of the solution?

I don't have any issues with the stability of Microsoft BI. It's a stable solution.

What do I think about the scalability of the solution?

It's mainly used by developers. We have 10 to 20 developers who are using this solution in our organization.

How are customer service and technical support?

Technical support could be improved. If you are able to get someone it's great, but if you don't then you are left hanging. 

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

Previously, they were using BusinessObjects.

With the EA agreement, we get access to everything from Microsoft. It just made sense to switch.

How was the initial setup?

The initial setup was completed through our internal Microsoft team.

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

Licensing costs are on an annual basis. There are no fees in addition to the licensing.

What other advice do I have?

For anyone who is interested in using this solution, they should hire a dedicated Microsoft team to implement it, and get a lot of training.

I don't know it well but I would rate it a five 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: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
reviewer1516839 - PeerSpot reviewer
Information Architect at a government with 10,001+ employees
Real User
A simple, flexible, low-code, and scalable solution for data integration and modeling
Pros and Cons
  • "It is a pretty straightforward and flexible solution for data integration and modeling. It is a low-code solution. When you are doing data integration, you can use the GUI, which is very simple and straightforward. You can also do very intricate custom queries and model it at different levels. It is very easy to use and scalable."
  • "It is kept very current, and there is an update literally every month. However, the interface changes quite randomly with no documentation, which is difficult at the domain and architectural level where you're planning things and engaging the business. Things change frequently, and you wonder where has the button for the new report gone. They should provide better documentation on interface changes. It should be better optimized. It is supposed to be a data integration tool, but it is doing relatively simple queries. It has its limitations. For example, you can only pull a number of columns. So, there is room for optimization on its ability to integrate multiple data sources. The desktop tool is very memory-intensive, and again, this is not documented clearly. It requires a heavy CPU and memory use, and it causes your operating systems to become unstable. I would like to see the ability to create datasets within Power BI. Microsoft is promoting Azure as a cloud solution, but it is dependent upon a desktop component, which seems a little bit deceptive. Data set is the basic element that you report from, but it has to be created on the desktop and then published to the cloud. So, you're in the cloud, and you create a data structure or the data flow, but you can't report from that. You have to leave the cloud, go to your desktop, create the data set on your desktop, and publish it to the cloud. You go back to the cloud and create your report by using that published data set, which is very non-intuitive. If you go to the Microsoft Power BI community, this is a common complaint across the entire community."

What is our primary use case?

We are using it for reporting, analytics, and data science. We have its latest version.

How has it helped my organization?

Microsoft's CRM platform has very limited reporting capabilities. Power BI was able to meet the business requirements for reporting and more in-depth analytics. It is a part of the Microsoft Ecosystem, and there is a straightforward connection from Power BI to CRM. 

What is most valuable?

It is a pretty straightforward and flexible solution for data integration and modeling. It is a low-code solution. When you are doing data integration, you can use the GUI, which is very simple and straightforward. You can also do very intricate custom queries and model it at different levels. It is very easy to use and scalable. 

What needs improvement?

It is kept very current, and there is an update literally every month. However, the interface changes quite randomly with no documentation, which is difficult at the domain and architectural level where you're planning things and engaging the business. Things change frequently, and you wonder where has the button for the new report gone. They should provide better documentation on interface changes.

It should be better optimized. It is supposed to be a data integration tool, but it is doing relatively simple queries. It has its limitations. For example, you can only pull a number of columns. So, there is room for optimization on its ability to integrate multiple data sources. 

The desktop tool is very memory-intensive, and again, this is not documented clearly. It requires a heavy CPU and memory use, and it causes your operating systems to become unstable.

I would like to see the ability to create datasets within Power BI. Microsoft is promoting Azure as a cloud solution, but it is dependent upon a desktop component, which seems a little bit deceptive. Data set is the basic element that you report from, but it has to be created on the desktop and then published to the cloud. So, you're in the cloud, and you create a data structure or the data flow, but you can't report from that. You have to leave the cloud, go to your desktop, create the data set on your desktop, and publish it to the cloud. You go back to the cloud and create your report by using that published data set, which is very non-intuitive. If you go to the Microsoft Power BI community, this is a common complaint across the entire community.

For how long have I used the solution?

I have been using this solution for about 18 months.

What do I think about the stability of the solution?

It is pretty stable. I haven't determined any major issues.

What do I think about the scalability of the solution?

It is very scalable. It fits perfectly with the larger Azure Data Lake reference architecture. Power BI platform is a fundamental piece, and it becomes scalable to use with other components within that reference architecture.

We're in the process of laying out a three-phase approach. Over the next year, its usage will increase from 50% to 75%. In terms of the number of users, we have around 150 users who are data scientists and data analysts. We have around 5,500 desktop users, and it is a part of 365, which is on every desktop. 

How are customer service and technical support?

There is a lot of online support. We also have Microsoft consultants on contract, and the support comes through them. Their support is very good.

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

We also have IBM Cognos. We haven't switched. They're being used in tandem. There are different sets of requirements for two different solutions. 

How was the initial setup?

I wasn't part of the deployment, but my understanding is that it was pretty straightforward.

What about the implementation team?

We used a Microsoft consultant for implementation. Our experience was good. We don't have any maintenance crew.

What other advice do I have?

I would rate Microsoft BI a nine 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: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
reviewer1415637 - PeerSpot reviewer
IT Analyst at a consultancy with 10,001+ employees
Real User
Provides easy data analysis and creates a visual representation of data from different data sources
Pros and Cons
  • "Microsoft Power BI is an easy tool for data analysis."
  • "We face multiple issues, and the connection drops off multiple times while integrating Microsoft Power BI with OAC and pulling in the data."

What is most valuable?

Microsoft Power BI is an easy tool for data analysis. It's easier to get the data from different data sources and then create a visual representation. Using the tool comes easily and naturally to people proficient with Excel. You need to have an understanding of data modeling and how the data works. Once you work with Power Pivot, I think Power BI will be a better upgrade than other tools in the market.

What needs improvement?

There are some issues with Microsoft Power BI's integration with OAC because it's currently in the beta phase. We face multiple issues, and the connection drops off multiple times while integrating Microsoft Power BI with OAC and pulling in the data. The solution's integration capabilities have created some issues for us, especially while retrieving data.

For how long have I used the solution?

I have been using Microsoft Power BI for over seven years.

How are customer service and support?

The solution's technical support has not been very helpful. I have solved my issues by myself and found a workaround for it.

How would you rate customer service and support?

Neutral

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

I have worked with multiple data visualization tools, such as SAP One and SAP BusinessObjects, where you had different tools for data visualization. I think each tool has its own unique capabilities. The biggest advantage of Microsoft Power BI is its integration with Excel and how it is an upgraded version of Excel. We all know how Excel is used in the market, so Power BI has a strong advantage over its competitors.

What other advice do I have?

I use the solution for myself, and I recommend it to my customers. I would recommend the solution to other users.

The selection of the visualization tool clearly depends on the data sources. I would recommend Microsoft Power BI if I worked for Microsoft. Otherwise, I would recommend other better tools available in the market. It completely depends on the data source and the data volume. I would not recommend Microsoft Power BI if the data volume is very high because it will tend to freeze your report.

Overall, I rate the solution an eight out of ten.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Harry Murdani - PeerSpot reviewer
Manager, IT Security at Averis Sdn Bhd
Real User
Top 5Leaderboard
Easy to visualize our data through dashboards and modify views based on our requirements
Pros and Cons
  • "It has greatly improved our reporting capabilities."
  • "There are certain features that are only available in the cloud version. It would be beneficial if they could be brought down to the on-premise version without the necessity of using the enterprise SQL database, as that can be very costly. We need more cost-effective features that are available in the cloud to be accessible on-premise."

What is our primary use case?

We use it to create dashboards. We input our data and visualize it as dashboards.

How has it helped my organization?

While it hasn't significantly enhanced collaboration, it has greatly improved our reporting capabilities. It allows us to present visually appealing dashboards to management.

Our main focus with Power BI is dashboarding rather than collaboration.

What is most valuable?

Power BI makes it easy to visualize our data through dashboards. It is quite dynamic. We can easily modify views based on our requirements, which helps us see the data more clearly and makes it visually appealing for management.

Moreover, the integration of Power BI with other Microsoft products is quite easy. 

What needs improvement?

There are certain features that are only available in the cloud version. It would be beneficial if they could be brought down to the on-premise version without the necessity of using the enterprise SQL database, as that can be very costly. We need more cost-effective features that are available in the cloud to be accessible on-premise.

For how long have I used the solution?

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

What do I think about the stability of the solution?

It is a stable product for me. I would rate the stability an eight out of ten. There are less than ten end users in my company using this solution. 

What do I think about the scalability of the solution?

I would rate the scalability an eight out of ten.

How are customer service and support?

The customer service and support are okay.

How would you rate customer service and support?

Positive

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

We're essentially a Microsoft house. We use a wide range of Microsoft products and are very happy with them. So far, we have no plans to switch, as we haven't found alternatives for essentials like Office or Windows.

Azure DevOps is something we're starting to explore to enhance our desktops. We also work with Microsoft Dynamics, DPM, Hyper-V, and Microsoft Exchange.

Cost was a decisive factor when opting for Power BI. 

How was the initial setup?

I would rate my experience with the initial setup an eight out of ten, with ten being easy to set up. 

The deployment process took one to two days. 

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

I would rate the pricing an eight out of ten, with one being cheap and ten being expensive. 

What other advice do I have?

I would recommend it, especially the Pro or Premium versions. They are better.

Overall, I would rate the solution a seven out of ten. 

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Mohammed Ghonaim - PeerSpot reviewer
Senior Oracle Application Consultants at Saudi Telecom Company
Real User
Top 5
Easy to set up with good functionality and an easy initial setup
Pros and Cons
  • "Like all Microsoft products, it is very easy to set up initially."
  • "We need more integration capabilities."

What is our primary use case?

Currently, it is used in our financial reporting and financial consideration reports.

What is most valuable?

It is stable.

It has good functionality and is fully integrated with Microsoft products. If you have already a direct connection or direct integration with Microsoft products, it is very good actually. In some cases, we just developed our BI dashboard and sent it to PowerPoint, for example. It'll be published as the power BI format, which is very good as a feature, to have that capability to just easily populate everything in PowerPoint.

Like all Microsoft products, it is very easy to set up initially.

It's pretty user-friendly.

The product can scale.

What needs improvement?

Our main concern with Power BI is it doesn't have a connection with the finance application. Power BI is used to present some financial data. However, if there is no direct connection or a ready API to be connected either to Oracle ERP or SAP or a different ERP, it won't be very useful. We need more integration capabilities. 

For how long have I used the solution?

We've been using the solution for five years. 

What do I think about the stability of the solution?

The stability is good. There are no bugs or glitches. It doesn't crash or freeze. It's reliable. 

What do I think about the scalability of the solution?

The scalability has been great. If a company needs to expand it, it can.

In my organization, there are about 10 to 20 users. The majority have shifted to Qlick.

How are customer service and support?

I haven't contacted technical support in the past. The product has been so stable we haven't needed assistance. 

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

We have multiple BI tools. We previously worked with Oracle BI. Our expectations were not met, and therefore we moved over to Microsoft BI.

In my sector, currently, we are using Qlik Sense. We started using it one year ago.

We are shifting from Microsoft to Qlik due to the fact that we have Oracle ERP as a back end. We are trying to find a technology or BI, which already has a direct connection with this ERP. We went into Qlik Sense for that reason.

How was the initial setup?

The initial setup is straightforward, actually. It is like any other Microsoft product. All of Microsoft's products are straightforward. It isn't complicated. This is one of the main benefits.

I'm not sure how long the deployment process was. I can't speak to how big the technical team was that handled the rollout.

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

We pay an annual licensing fee. 

What other advice do I have?

I would recommend the solution if they already have a Microsoft ERP system. If they have already Microsoft and they have already their financial system in place and if they don't have data movement, Power BI will be very powerful. If a company has different financial systems, they have to track all these data points first, build the business model and then import it to Power BI. 

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

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
Download our free Microsoft Power BI Report and get advice and tips from experienced pros sharing their opinions.
Updated: April 2025
Buyer's Guide
Download our free Microsoft Power BI Report and get advice and tips from experienced pros sharing their opinions.