Try our new research platform with insights from 80,000+ expert users
Database Administrator at Gap
Real User
Top 20
Integrates with different data sources and handle large data sets
Pros and Cons
  • "One of the key benefits of Power BI is how easy it is to develop reports."
  • "We identified a couple of issues in the reports. Some reports took too long to load, particularly at the end of our data refresh."

How has it helped my organization?

We have created the reports and are continuing to work on them. We are deploying them to the proxy, and the users are utilizing them for various business processes.

I work in Tableau or Tableau and Power BI. It can handle large data sets. You can just get the raw data. When it comes to Power BI, if you have to get the raw data and want to refresh it, the refresh at a point in time would degrade performance.

What is most valuable?

One of the key benefits of Power BI is how easy it is to develop reports. Even non-technical users can easily download the report and learn to include slicers and data filters once provided with a template. The platform is very user-friendly. Another advantage of Power BI is that if the report developer encounters any issues, they can quickly find solutions through Microsoft’s help resources. You can get your assistance by visiting the Microsoft support site or posting queries. This makes developing and delivering reports much easier. Microsoft Power BI provides much support and flexibility, making it a great tool for report generation.

It can integrate with different data sources. You can connect seamlessly to Databricks, SQL Data Warehouse, third-party sites, and multiple other sources.

What needs improvement?

We identified a couple of issues in the reports. Some reports took too long to load, particularly at the end of our data refresh. To address this, we optimized the data model using multiple tables, improving performance. Now, all reports are refreshing properly using DBP, and we’ve implemented these improvements in Power BI.

For how long have I used the solution?

I have been using Microsoft Power BI for two years.

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

What do I think about the stability of the solution?


What do I think about the scalability of the solution?

The availability of Power BI is excellent. Once a user is set up, they can easily access and work with the Power BI files from the repository. There are also various modes for adding features, allowing users to combine data in different ways to make informed business decisions. 

Based on business discussions, there are 25 to 100 business users. The users work with templates, and we collect UAT feedback from them.

How was the initial setup?

The initial setup was straightforward. Based on the current requirements, I've been able to develop the reports independently. It's easy to use and allows for faster reporting.

Once we generate the reports, we schedule and publish them on the website and then share the process with the users.

We're able to refresh the Power BI reports and create data models to support the business at this stage.

What other advice do I have?

I'm working with a company that manages detailed sales data for the clothing industry. We're tracking orders, brands, seasons, and which facility handled the order, along with audits. We're focusing on metrics like fabric consumption and fiber content for reporting. 

We can develop reports in Power BI, including RxTx reports. Many of the business teams are also using Power BI. For support, we use Slack to manage tickets and TableLab for some tasks. Power BI offers a trial version, and you can get a pro license at a relatively low cost, with users having access to AV accounts. The main advantages are that it’s easy to use and more affordable compared to other reporting tools.

Overall, I rate the solution an eight 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.
Flag as inappropriate
PeerSpot user
HussainModu - PeerSpot reviewer
Senior Technical Architect at a tech vendor with 10,001+ employees
Real User
Top 10
Provides valuable DAX functions and has a simple setup process
Pros and Cons
  • "The product's most valuable features are DAX functions for formulas and calculations."
  • "I would suggest improvements in visualization standards, particularly in customization and appearance."

What is our primary use case?

I use the platform primarily to create visualizations and reports from data to gain insights. It is utilized for operational, decision-making, and managerial reports.

What is most valuable?

The product's most valuable features are DAX functions for formulas and calculations.

What needs improvement?

I would suggest improvements in visualization standards, particularly in customization and appearance, to match tools like Tableau.

For how long have I used the solution?

I have been working with Microsoft Power BI for two years.

What do I think about the stability of the solution?

I rate the platform stability a seven and a half or eight out of ten. 

What do I think about the scalability of the solution?

The product is suitable for medium-sized companies with straightforward requirements. It can handle thousands of users, but its effectiveness depends on the data volume and reporting needs.

I rate the scalability an eight. 

How are customer service and support?

The technical support team's response quality can vary based on the engineer's expertise and availability.

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

Power BI is more cost-effective, whereas Tableau provides more advanced features and higher-quality visualizations. For critical business needs and high data volumes, Tableau might be more suitable. 

How was the initial setup?

The initial setup process is simple. 

I have worked with both the cloud version and the desktop model. Each has its advantages depending on the need for high-quality visualizations or the volume of data.

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

I rate the product pricing a ten. 

What other advice do I have?

The solution supports integration from various applications well enough to meet most business requirements. 

I rate it a nine out of ten. 

Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
Buyer's Guide
Microsoft Power BI
May 2025
Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: May 2025.
851,604 professionals have used our research since 2012.
Ammar Rajab - PeerSpot reviewer
Senior Data Analyst at NeoMedia Technologies Inc
Real User
Top 20
Crunch the data faster, good speed of building a visual and the transformation feature
Pros and Cons
  • "Power BI's integration with other tools is very good."
  • "The real-time data refresh capabilities is one of the things I had issues with"

What is our primary use case?

We use it specifically for pure data analysis. 

What is most valuable?

I like the speed of building a visual and the transformation feature where you can make changes to the data, and then revert back very fast. These features, where you make transformations and then delete that step when you don't need them, are some of the best.

Power BI's integration with other tools is very good. With Power BI, if there are other systems on the network, you can easily connect to anything like SQL Server, Oracle, Amazon, Salesforce, SAP...anything you can easily connect. I have not faced difficulties with that.

What needs improvement?

The real-time data refresh capabilities is one of the things I had issues with. The refresh sometimes doesn't really work very well because there are two ways of connecting: direct and import. 

When it's direct, it's refreshed, but then you have limitations. But when you import the data, I feel there is always a limitation in the refresh. It is kind of like a room for improvement for Microsoft Power BI to work more on these real-time data refresh capabilities.

Microsoft Power BI changes almost every month; make changes regularly. I sometimes even see features that disappear, change, and update. So, I'm not keeping up. They are already doing a lot of changes. They keep updating regularly.

For how long have I used the solution?

I have been using it for six to seven years. 

What do I think about the stability of the solution?

It's quite stable. Power BI is very stable.

What do I think about the scalability of the solution?

It is very scalable. Almost everyone in our company uses it. 

I personally use it daily. 

How are customer service and support?

I don't usually deal with customer service and support. It's our technical team that deals with them, but I don't see them complaining.

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

I used Excel. Power BI can crunch the data faster, and you can build a dashboard nicer and faster. Building a visual in Power BI is always easier, quicker, and simpler than Excel. It's Excel on steroids. 

I used to use Excel pivot tables a lot, but with Power BI, it's faster. It's easier to play with the data. If I want to make a list or put some formulas and stuff, Excel is good. But if I want to visualize the data, crunch it properly, and build measures quickly, Power BI is better.

How was the initial setup?

I would rate my experience with the initial setup an eight out of ten, with ten being easy and one being very difficult. 

It is deployed both on-premises and the cloud. 

The deployment time varies and depends on the company. Every company is different. Here, internally, we have Microsoft Power BI Cloud, so it's easy. 

But in the previous company, we did not have Microsoft Cloud. So, to install, we had to install Microsoft Reporting Server and then Power BI internally. That took quite a while. 

But if you have Microsoft Cloud in your company, that's easy. And it's quicker on the cloud than on-premises.

What about the implementation team?

Maybe a third party helped with the deployment. 

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

Downloading Power BI Desktop is free. But when you want to use the cloud, this is where I think it's per user payment. I'm not really very familiar with the licensing because I think they have more than one level. 

But to use Power BI internally for yourself, it's free. You download it. It's a free application.

What other advice do I have?

I would recommend Power BI to other people. Overall, I would rate it an eight out of ten. 

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Deepak Sahu - PeerSpot reviewer
Senior Consultant at a tech vendor with 10,001+ employees
Real User
Top 20
Provides data manipulation and visualization with built-in AI capabilities
Pros and Cons
  • "The data manipulation and data cleaning tasks are handled in the backend by Power Query in Microsoft Power BI."
  • "As Copilot and further integrations continue to develop, they will enhance Power BI's functionality."

What is our primary use case?

We use Microsoft Power BI for both data manipulation and visualization, with a strong emphasis on data-driven storytelling. It allows you to clean and transform data. You can connect to various data sources, such as Excel, SQL databases, and SharePoint files, and clean and prepare your data using Power Query. Additionally, you can write DAX to create powerful measures for diverse use cases. Power BI enables the creation of highly insightful dashboards to convey information.

What is most valuable?

The data manipulation and data cleaning tasks are handled in the backend by Power Query in Microsoft Power BI.

Integrating data from multiple sources in Microsoft Power BI is very easy. For example, you can connect to SharePoint, various SQL servers, and other platforms. Power BI also offers a range of connectors and libraries for integrating data from various sources, including databases, online services, and cloud-based platforms. It saves a lot of time by handling large datasets. It can process millions of rows of data and allows users to create visualizations and analyze trends quickly. Power BI is effective for various types of data analysis and can adapt to complex data needs.

What needs improvement?

Additional features can enhance Power BI's capabilities in predictive analysis. Currently, Microsoft Fabric is integrated with Power BI. As Copilot and further integrations continue to develop, they will enhance Power BI's functionality.

It offers a range of formatting options for reports and dashboards. For example, if you have multiple headers and change one header's color, all the subheadings can automatically adopt the same color. This feature allows for extensive customization and formatting, which is important because leaders often prefer color-coded information presented in a specific manner.

For how long have I used the solution?

I have been using Microsoft Power BI for seven years.

What do I think about the stability of the solution?

I rate the solution’s stability a ten out of ten.

What do I think about the scalability of the solution?

More than 400 people utilize it. It is suitable for small and medium businesses.

You can create dashboards using Power BI Desktop and share the Power BI Desktop file itself. However, for larger organizations, Power BI offers a web-based solution through Power BI Service, where you can publish reports and dashboards.

I rate the solution’s scalability a ten out of ten.

How are customer service and support?

Microsoft offers excellent products, and its community provides many options and support. If users encounter specific issues, they can find solutions in various Microsoft communities.

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

I have experience with both Microsoft Power BI and Tableau. Working with Tableau posed multiple challenges, such as data integration and ETL, which can be quite complex. Additionally, Tableau's measures and visualizations can be somewhat intricate. However, the flexibility in Power BI is comparable to that of Tableau.

I used Tableau for about five years before switching to Power BI, so I have a total of around eleven years of experience with these tools. As an advanced Tableau user, Power BI is simpler in comparison. Additionally, Tableau requires a paid license, whereas Power BI does not require a purchase unless you deploy it.

How was the initial setup?

The initial setup is simple. You can start in about twenty minutes. However, you'll need to thoroughly understand the application to gain deeper and more critical insights. While you can learn the basics within a few hours, mastering the more advanced features involves a steeper learning curve.

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

Compared to other solutions, it can be relatively expensive, while the cost can be more manageable for organizations, considering the scale and the benefits.

What other advice do I have?

Power BI offers several built-in AI capabilities. For instance, it includes features for sentiment analysis, generating word clouds, pattern recognition, and trend analysis. While Power BI integrates well with various external data sources and services, including advanced AI models, many analytical functions are available directly within the Power BI suite.

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

Disclosure: My company has a business relationship with this vendor other than being a customer: Partner
PeerSpot user
Alyosh Agarwal - PeerSpot reviewer
Managing Director/ Consultant at Applaud GmbH
Reseller
Top 20
Used to build business intelligence dashboards and provides good graphic representation
Pros and Cons
  • "The solution's most valuable feature is the graphic representation."
  • "The dynamic browsing tables could be better in Microsoft Power BI."

What is our primary use case?

We use the solution to build business intelligence dashboards.

What is most valuable?

The solution's most valuable feature is the graphic representation.

What needs improvement?

The dynamic browsing tables could be better in Microsoft Power BI.

For how long have I used the solution?

I have been using Microsoft Power BI for three years.

What do I think about the stability of the solution?

I have not faced any issues with the solution’s stability.

I rate the solution an eight out of ten for stability.

What do I think about the scalability of the solution?

I am satisfied with the solution’s scalability. Our customers for Microsoft Power BI are enterprise businesses in the engineering sector.

I rate the solution’s scalability ten out of ten.

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

Microsoft Power BI is a simpler solution than Tableau.

How was the initial setup?

The solution's initial setup is easy. The solution can be deployed in a few hours.

On a scale from one to ten, where one is difficult and ten is easy, I rate the solution's initial setup ten out of ten.

What was our ROI?

Microsoft Power BI is a comparable tool that provides very quick ROI, and it's as good as or better than other products like QlikView or Tableau.

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

Microsoft Power BI is not an expensive solution. The solution’s pricing is reasonable.

What other advice do I have?

The solution's real-time data processing feature benefits our organization because most managers want to have real-time data compilations. They want to integrate SQL and expect the data to be current. Different clients have different environments. Sometimes, the tool is deployed on the local server, and sometimes in the cloud.

Microsoft Power BI is worth trying because it's very popular and easily adopted by organizations. It's easier to adopt than third-party products. Microsoft Power BI provides good graphical overviews, good graphic preparation of data, good integration with SQL, and good data integration.

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

Disclosure: My company has a business relationship with this vendor other than being a customer: Consultant
PeerSpot user
Rohit Patel - PeerSpot reviewer
Generative AI Developer at Rack Ai Private Limited
Real User
Top 10
Useful for creating reports and dashboards
Pros and Cons
  • "What I liked most about the tool is that we can use text queries to create projects and modify columns according to our needs. There are hundreds of YouTube courses on how to use it."
  • "I found data cleaning in the solution to be quite difficult. If I could add a feature, I'd include Excel's Flash Fill function. This allows you to set a formula for one row and column and automatically apply it to thousands of rows, making data sorting much easier."

What is our primary use case?

During my internship, I used Microsoft Power BI to create reports for a project we were working on. I also made a dashboard to help a company grow its business.

What is most valuable?

What I liked most about the tool is that we can use text queries to create projects and modify columns according to our needs. There are hundreds of YouTube courses on how to use it. 

What needs improvement?

I found data cleaning in the solution to be quite difficult. If I could add a feature, I'd include Excel's Flash Fill function. This allows you to set a formula for one row and column and automatically apply it to thousands of rows, making data sorting much easier.

What do I think about the scalability of the solution?

I found the tool to be a stable product. One of my favorite features is connecting a SQL database to the tool to generate real-time reports. I was part of a group of 80+ students, but only five of us, including me, were offered internships and could use Microsoft Power BI.

How are customer service and support?

I haven't contacted the solution's support yet. 

How was the initial setup?

Installing Power BI is easy—there are free and paid versions available. I used the free version, which you can download from the Microsoft Store and install, similar to installing an app on your phone.

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

I used the tool's free version. 

What other advice do I have?

I'd recommend Microsoft Power BI for report generation - it's great software. I rate it a nine out of ten. 

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
reviewer1576593 - PeerSpot reviewer
Data Scientist at a energy/utilities company with 501-1,000 employees
Real User
Top 5
Provides data visualization and insights but needs data refresh functionality
Pros and Cons
  • "Power BI pricing is generally considered more affordable than Tableau."
  • "An area for improvement is data refresh functionality"

What is our primary use case?

We have a lot of data, which we process and analyze using Python. Once the data is processed, we feed it into Power BI. In Power BI, we build dashboards and visualizations. Our team or customers can then view these dashboards.

What is most valuable?

Data visualization is crucial because while some people understand data, many find raw numbers or text difficult to interpret. Visualization makes patterns and insights clearer and easier to understand. Tools like Microsoft Power BI and Tableau are excellent for creating these visualizations, helping users grasp better and analyze large datasets.

What needs improvement?

For example, the variety of chart types available in Power BI is somewhat limited. While you can choose from various charts like dial gauges, bar charts, and line charts, there aren't as many diverse options as you might need. Sometimes, you might look for additional chart types and find that they're not available for download from the Internet.

Another area for improvement is data refresh functionality. Even with a premium license, the refresh rate is limited to every 30 minutes. This can be restrictive if you need more frequent updates, such as every 10 or 15 minutes, or at specific times, like every Monday at 4:25 PM. The current options are typically every hour, every 30 minutes, or daily. This limitation can lead to inefficient resource use if your data only needs to be refreshed at specific times.

For how long have I used the solution?

I have been using Microsoft Power BI for four years.

How was the initial setup?

Initially, Microsoft Power BI can be quite complex. The Microsoft website does not always provide clear guidance, so you might need to watch numerous YouTube tutorials. The initial setup can be challenging, but using Power BI becomes much easier once you become familiar with the process.

Once you use Power BI, you must install or subscribe to the software and spend time exploring and working with your data. Becoming fully proficient and deploying your solutions effectively may take a few months.

What was our ROI?

ROI is really great.

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

Power BI pricing is generally considered more affordable than Tableau. There is a free version available for Power BI, and the Pro version costs around $20 per user per month. In contrast, Tableau's pricing can be higher, with a Creator license costing around $70 per user per month.

Which other solutions did I evaluate?

Compared to Tableau, Power BI is considered more affordable. While Tableau is often seen as more versatile and professional, making it suitable for advanced and complex data visualization needs, Power BI is a more accessible option for beginners or organizations starting with data visualization.

What other advice do I have?

Microsoft Power BI is a user-friendly tool for creating dashboards and visualizations. It allows you to easily import data from Microsoft Excel or CSV files, which are common data storage formats. Once your data is imported into Power BI, you can create a variety of visualizations, including line charts, bar charts, and gauges, to present it effectively.

Many people turn to resources like Google searches and YouTube tutorials to learn how to use Power BI. Microsoft also offers extensive learning materials.

Power BI has some AI capabilities, but it's primarily a tool for data visualization. For more advanced AI and machine learning tasks, such as those involving neural networks or complex algorithms, many data scientists prefer to use Python and integrate their results into Power BI for visualization.

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

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