No more typing reviews! Try our Samantha, our new voice AI agent.
Samar Moustafa - PeerSpot reviewer
BI Developer at AHBS
Real User
Apr 7, 2024
Provides well-organized KPI data, easy to use and offers the ability to integrate any data source
Pros and Cons
  • "Data integration is very useful in Power BI. It lets me collect data from many sources. For example, I can get data from Oracle databases and SQL Server databases at the same time."
  • "When I create measures, sometimes the error messages aren't clear. It makes me spend more time searching for solutions. I need the error messages to be more specific. So, I would like clearer error messages when creating measures."

What is our primary use case?

With Power BI, I create dashboards. We have an IT manager responsible for supply chain and CRM, including billing. I handle the supply chain module, receiving end-user requests for dashboards and reports.

I create analysis and measures in Analysis Services, then craft dashboards that meet end-user requirements.

My work involves using SQL Server Integration Services to integrate data from various sources, including Oracle and SQL Server, and then store them in Data Warehouse.

How has it helped my organization?

Power BI significantly organized our KPIs, making them accessible for immediate business decisions, like analyzing profits or losses. 

For example, in supply chain management, Power BI provides well-organized KPI data and calculated measures that aid decision-makers. Unlike before, they don't have to wait for detailed data; they get well-defined KPIs and calculated measures that offer insights into the business, allowing them to make informed decisions regarding future strategies and properties.

Power BI's collaboration functionality improves teamwork in our organization. We had a lot of entries and a lot of people who were working with Power BI. It's been four years, and some new members have less experience. We all collaborate to share information and experience, which improves collaboration.

What is most valuable?

Power BI's ability to integrate any data source, whether it's a cloud database, Analysis Services, or another type, is incredibly valuable. It allows us to make the right data available for analysis. 

Additionally, the flexibility to enhance our dashboards with new charts found online further helps with our analytical capabilities.

I also like the feature of the Page Navigator in Power BI. The Page Navigator allows users to navigate through different pages on the dashboard simply by clicking on the desired page, and Power BI will automatically open that page. 

Additionally, Power BI offers interactions where I can decide what Slicer or chart can filter another. Not all sources can filter all the others, and not all filters can be applied universally. 

I've also found Bookmarks to be a valuable feature, allowing for control over what sources are affected or whether they are visible or invisible during any interaction in Power BI. 

The dashboard and reporting features are very effective in decision-making. They enable decision-makers to determine the next steps, such as analyzing profits and losses, evaluating supplier performance, including late fees, and managing purchase timings in relation to delivery and order dates.

Data integration is very useful in Power BI. It lets me collect data from many sources, especially with IT support. I get data from tools, databases, data warehouses, and data lakes. For example, I can get data from Oracle databases and SQL Server databases at the same time.

We combine this data into a single destination—either a table or a database. This lets us analyze the combined data and create visualizations. Ultimately, we can consolidate information like customer details from different solutions into a single table. We can also change data types, clean the data, and organize it effectively.

What needs improvement?

When I create measures, sometimes the error messages aren't clear. It makes me spend more time searching for solutions. I need the error messages to be more specific.

So, I would like clearer error messages when creating measures.

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

For how long have I used the solution?

I've been working with Power BI since January 2020, so it's been four years.

What do I think about the stability of the solution?

It is very stable. I would rate the stability a ten out of ten. 

What do I think about the scalability of the solution?

It works well for a large number of users. We have almost 15 to 20 end users. 

How was the initial setup?

I would rate my experience with the initial setup a four out of ten, with one being difficult and ten being easy to set up.

It's difficult to set up. Sometimes, I need technical support to resolve issues.

We use it on-premises.

What about the implementation team?

The deployment time varies. Sometimes it takes two days, and sometimes it takes two weeks. If the dashboard has a lot of KPIs, it will take more time. Also, if the data already exists as measures, it's less complicated.

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

It's accessible with some subscriptions. We have a lot of users that we can send dashboards to daily, and that would cost a lot of money otherwise. But setting up Power BI itself is not expensive.

What other advice do I have?

I would definitely recommend using this solution. It's easy to use. It can get data from a lot of sources. It's user-friendly. It's easy to learn, and it's easy to search on the internet for information about it.

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

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
Sr PeopleSoft Consultant at Mahanta Solutions
Reseller
Mar 17, 2024
Offers both real-time and offline data processing and essential tool for detailed reporting across various sectors like banking and easy to use
Pros and Cons
  • "Reporting is the best thing about Power BI. And it could help improve decision-making in many ways. Power BI is flexible and easier to use compared to tools."
  • "I would like to see more AI capabilities in future releases. There's a strong interest in AI, including technologies like GPT, which facilitate real-time interactions."

What is our primary use case?

I've mainly worked within the banking sector. It is particularly useful for vertical clients. Power BI is a great tool for reporting. You can source data from any database, like Oracle or Microsoft SQL. It generates reports and provides methods to control your report's power.

How has it helped my organization?

Power BI works with both real-time and offline data. When interacting with real-time data across multiple systems, it offers a great advantage.

I've worked with real-time interactions and appreciate them, similar to how AI is increasingly being incorporated. It's fascinating to see the shift towards AI.

Using middleware technology, like web services, allows Power BI to interact with multiple systems efficiently. This request and response mechanism ensures data is transmitted from the source to the target system in real-time, which significantly benefits business operations by providing up-to-date information.

Moreover, integration capabilities were smooth. I worked on integrating Power BI with PeopleSoft, focusing on custom solutions rather than out-of-the-box features, tailoring the experience to specific needs.

Power BI is very user-friendly and easy to learn. I've even uploaded instructional videos on YouTube, which have helped many users, including some who have become long-term administrators of Power BI.

What is most valuable?

Reporting is the best thing about Power BI. And it could help improve decision-making in many ways.

Power BI is flexible and easier to use compared to tools like Crystal Reports.

What needs improvement?

It should integrate with multiple enterprise applications. For instance, integrating CRM (Customer Relationship Management) and HCM (Human Capital Management) with Power BI can be a significant advantage.

Because, organizations focus on and like software that can do multiple tasks.

The user interface is good but it should have the ability to interact with multiple systems.

I would like to see more AI capabilities in future releases. There's a strong interest in AI, including technologies like GPT, which facilitate real-time interactions.

It's all about real-time interaction between customers and the system, automated to operate under specific scenarios. This ensures it functions in real-time, leveraging AI for more dynamic engagements without needing predefined projects or setups, much like how chatbots are designed for real-time use.

In future releases, I would like to see more encrypted software, and there should be version control for Software. It will avoid pirated downloads. 

I would also like to see dynamic content. It should be an add-on in Power BI. It helps users understand reports more easily. For example, when a developer is building a report, they should consider using dynamic content to make the report more user-friendly.

For how long have I used the solution?

I've worked with Power BI for almost one and a half years, focusing on reporting and integration with Power BI.

What do I think about the stability of the solution?

Power BI is very stable, especially in sectors like banking, retail, pharmaceuticals, and telecommunications. 

Its stability is expected to increase in the future with advancements in Azure.

I would rate the stability a nine out of ten. 

What do I think about the scalability of the solution?

I would rate the scalability a ten out of ten. It's very scalable.

How are customer service and support?

I haven't needed to press for support activities, so based on my experience, it is good in general. 

How would you rate customer service and support?

Positive

How was the initial setup?

Compared to other reporting tools, it is very easy to acquire, demonstrate, and understand.

I would rate my experience with the initial setup a nine out of ten, with ten being easy. 

It is very easy to set up. Security in a private cloud is optimal, whereas public cloud lacks in security. Hybrid solutions offer some balance, but on-premises solutions have a lot of limitations.

Many customers are moving to the cloud for its ease of use, security, availability, and flexibility. Cost efficiency is also a factor. For example, Why would you use the cloud? Say you have 1000 people in your organization, and only 500 need access to Power BI. On-premises, you'd need to buy licenses for all the users. With the cloud, you only pay for what you use.

Considering cost, cloud solutions like Amazon Cloud, GCP Cloud, or Azure Cloud are preferred for their scalability and cost-effectiveness.

So, our customers mainly use cloud deployments.

What about the implementation team?

Deployment doesn't take much time, thanks to it being a Microsoft product, which makes it easy to handle compared to other software.

So, it takes just a few hours.

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

It's about balancing cost and value. Although Power BI is cost-effective compared to other reporting tools, its pricing should be more adaptable based on the size of the organization to ensure it remains cost-effective for both small and large entities.  For example, if the organization has a million end-users, it should be cost-effective. 

This is important when considering the scalability of solutions like Kronos or Banner ERP systems, ensuring the cost is aligned with the organizational needs.

The pricing is very low and competitive. Microsoft could consider adjusting the price according to the size and needs of the organization, balancing demand with supply.

What other advice do I have?

Power BI is an essential tool for any kind of detailed reporting. It's efficient and effective. 

I would definitely recommend using this solution. Overall, I would rate the solution a ten out of ten. 

Disclosure: My company has a business relationship with this vendor other than being a customer.
PeerSpot user
Buyer's Guide
Microsoft Power BI
July 2026
Learn what your peers think about Microsoft Power BI. Get advice and tips from experienced pros sharing their opinions. Updated: July 2026.
908,877 professionals have used our research since 2012.
Edwin Matodzi - PeerSpot reviewer
Head of Strategy & Architecture at Auditor General
Real User
Sep 6, 2023
A tool that is useful for building reports and dashboards but needs to improve its integration capabilities
Pros and Cons
  • "The most valuable feature of the solution is that it is an easy-to-use tool."
  • "Microsoft BI lacks integration capabilities, so it needs to consider increasing its integration capabilities."

What is our primary use case?

My company uses Microsoft BI for reporting purposes. In my company, we extract data from different sources, put it in the staging area, and then use Microsoft Power BI to build the reports and dashboards.

What is most valuable?

The most valuable feature of the solution is that it is an easy-to-use tool.

What needs improvement?

Microsoft BI lacks integration capabilities, so it needs to consider increasing its integration capabilities. Microsoft BI needs to improve its mobile application compatibility so that people view their reports and dashboards through a mobile app since, nowadays, people move towards tools that are in the digital transformation phase.

For how long have I used the solution?

I have experience with Microsoft BI. I recently joined a new organization where I see Microsoft BI being used extensively.

What do I think about the stability of the solution?

Considering that most people in my organization use Microsoft BI, I can say that it is a stable solution.

What do I think about the scalability of the solution?

Microsoft BI is a part of Microsoft Power Platform, because of which Microsoft can increase its capacity based on the needs and licenses of its users.

Around 20 people in my company use Microsoft BI.

My company plans to increase the use of Microsoft BI.

How was the initial setup?

The initial setup of Microsoft BI is straightforward since it comes along with Microsoft Power Platform.

The solution is deployed on the cloud.

I am unsure about Microsoft BI's deployment process since it was already deployed when I joined the organization.

In my company, we have two developers and two testers to look after the deployment and maintenance of the solution.

What about the implementation team?

The company's in-house team did the installation process of Microsoft BI.

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

When my company compared the price of Alteryx to Microsoft BI, we found Alteryx's price to be higher than Microsoft BI's price.

In general, Microsoft BI's price is lower compared to Alteryx.

What other advice do I have?

I am not a user of the solution at the moment. I am an architect taking time to evaluate and see how my company can use Microsoft Power BI.

Our company hardly finds a tool where we can say one size fits all, so we need to use other tools for larger amounts of data and data cleansing.

It would be effective for those planning to use the solution to find the best solution that suits their requirements.

I rate the overall solution a seven out of ten.

Disclosure: My company has a business relationship with this vendor other than being a customer. Partner
PeerSpot user
Alexander Roussekov - PeerSpot reviewer
Solution Architect at Seqwater
Real User
Sep 4, 2023
Provides considerable flexibility in creating reports, dashboards, and various types of analytics
Pros and Cons
  • "Power BI stands out because it provides considerable flexibility in creating reports, dashboards, and various types of analytics to meet those dynamic requirements. It is lightweight and easy to use with good support."
  • "Microsoft BI typically connects to a database, often SQL Server, but it's also capable of connecting to multiple databases, pulling data from them, and allowing for data consolidation. You can then aggregate and generate dashboards and reports from this combined data. Personally, I wouldn't claim to have the expertise to suggest significant changes or additional features, as it functions quite well as is."

What is our primary use case?

It’s not just a specific tool I use when providing solutions. In these scenarios, clients often have a significant Microsoft presence with servers for data collection, whether it's in a data lake, data warehouse, or a data lake house. Their users typically require reporting, dashboards, or ad-hoc queries based on their specific business needs. However, most vendors tend to offer inflexible solutions, focusing on predefined reports.

What is most valuable?

Power BI stands out because it provides considerable flexibility in creating reports, dashboards, and various types of analytics to meet those dynamic requirements. It is lightweight and easy to use with good support.       

What needs improvement?

Microsoft BI typically connects to a database, often SQL Server, but it's also capable of connecting to multiple databases, pulling data from them, and allowing for data consolidation. You can then aggregate and generate dashboards and reports from this combined data. Personally, I wouldn't claim to have the expertise to suggest significant changes or additional features, as it functions quite well as is.

For how long have I used the solution?

I have been using this solution for the past five years. 

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?

It's a cloud-based platform, and it scales seamlessly based on your usage, which is one of the key advantages of cloud services. You pay according to your usage, without worrying about licenses or ownership. However, there are some limitations to consider. While it's a front-end tool for visualization and analytics, it lacks extensive customization options. If you require complex reports or queries, Microsoft offers support to help you achieve those goals. In my experience over the past five years, I haven't encountered any use case that couldn't be addressed with Power BI. On the contrary, I faced performance issues with other tools like Spotfire, which prompted us to explore different solutions. The effectiveness of Power BI also depends on factors like architecture, deployment, and network quality. If network configurations aren't optimized, it can lead to slow data transfer. However, being a cloud-based solution, the cloud infrastructure often manages these issues. Nevertheless, if you want the best performance, you might need to invest in improving your network infrastructure.

How are customer service and support?


The support is good. It's quite satisfactory. While no tool is perfect, especially when compared to others, Microsoft's commitment to maintaining a strong reputation and their substantial investment in full support means I have little to complain about.

How would you rate customer service and support?

Positive

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

I'm not very familiar with the licensing aspect, as it operates in the cloud as a SaaS (Software as a Service) model. Essentially, you pay based on cloud cost models, which might include hourly rates or similar billing structures introduced by Microsoft. Many organizations utilize it and pay for its services, somewhat like Office 365. It's a cloud-based platform that provides the necessary services, including support, for development, and you pay accordingly for the usage.

What other advice do I have?

 would recommend the solution, rating it eight out of ten. There’s no such thing as an ideal product. In my perspective, perfection remains an unattainable goal. However, I can't rate it lower than eight because Microsoft actively invests in BI's development and expansion. They have a roadmap and allocate resources to it, which is evident in the growing user base. This continuous growth adds value to the product and benefits its users.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Deepak Sahu - PeerSpot reviewer
Senior Consultant at a tech vendor with 10,001+ employees
Real User
Jul 31, 2024
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
PeerSpot user
Administrator at a tech vendor with 10,001+ employees
Real User
Top 20
Jul 30, 2024
Integrates with other solutions and used for reporting purposes
Pros and Cons
  • "You can integrate Microsoft Power BI with various other solutions like Intune."
  • "The solution should increase the API functionality so that we can use Microsoft Power BI for other purposes and aggregate things."

What is our primary use case?

We mostly use Microsoft Power BI for reporting. We are going to build some solutions. We are going to deploy the scripts from Intune so that it can pull some data, which we can aggregate and show the projections on Power BI.

What is most valuable?

I really like the solution's integration part. You can integrate Microsoft Power BI with various other solutions like Intune. You can push the Intune data warehouse to Power BI. I really like the custom-built solutions that are available in Power BI.

What needs improvement?

I really wanted to send the inventory data to Power BI. I don't know whether the feature is available because I'm working on it and still need to look into it. The solution should increase the API functionality so that we can use Microsoft Power BI for other purposes and aggregate things.

I recently used Microsoft Power BI reporting for Windows Update. I wanted to understand where the reporting data came from, but I couldn't find it. It could be because I had fewer privileges. It would be good to know the data source for the solution's reporting part.

For how long have I used the solution?

I have been using Microsoft Power BI for the past six months.

What do I think about the stability of the solution?

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

What do I think about the scalability of the solution?

Microsoft Power BI can be used by all company sizes because it's all about aggregating and visualizing data. Any organization needs to have a broader perspective on what is happening. It could be useful for both large and small applications. All ranges of companies can utilize Power BI.

I rate the solution a nine out of ten for scalability.

How are customer service and support?

The support engineers are not ready to schedule the calls or understand the issues and are very eager to close the cases. I have previously worked at Microsoft as a support engineer. I know they may have workloads and may need to handle multiple cases in a day.

However, I'm not finding even the basic courtesy of handling the issues from the engineers' perspective. Except for a few, many engineers are not willing to help the customers. They focus more on their limitations, saying that they don't deal with such issues or that they are out of their scope.

I rate the solution’s technical support a six to seven out of ten.

How would you rate customer service and support?

Neutral

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

Informatica is a competitor to Microsoft Power BI. However, Microsoft Power BI is very easy to use, and even a nontechnical person can implement it. Other solutions are a bit complicated when compared to Microsoft Power BI.

How was the initial setup?

The solution’s initial setup is very simple. The solution's deployment takes less than 15 to 30 minutes.

What other advice do I have?

Microsoft Power BI is deployed on the cloud in our organization. I would recommend the solution to other users.

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

Disclosure: My company has a business relationship with this vendor other than being a customer. Partner
PeerSpot user
reviewer2352276 - PeerSpot reviewer
Lead Support Engineer at a financial services firm with 10,001+ employees
Real User
Jul 24, 2024
Allows users to see reports on mobile devices but has limitations on data volume
Pros and Cons
  • "The tool's most valuable features are slicer and Microsoft Copilot integration. It also allows users to see reports on mobile devices. The solution can also integrate with various data sources."
  • "The limitations within Microsoft Power BI include the volume of data it can handle, as there's a cap on the number of rows you can keep. When you pull your data and build your models, you're restricted by this row limit. Additionally, certain SSRS features are deprecated, which can be a drawback for users who rely on those capabilities."

What is our primary use case?

We use the solution for data analysis. 

What is most valuable?

The tool's most valuable features are slicer and Microsoft Copilot integration. It also allows users to see reports on mobile devices. The solution can also integrate with various data sources. 

What needs improvement?

The limitations within Microsoft Power BI include the volume of data it can handle, as there's a cap on the number of rows you can keep. When you pull your data and build your models, you're restricted by this row limit. Additionally, certain SSRS features are deprecated, which can be a drawback for users who rely on those capabilities.

For how long have I used the solution?

I have been working with the product for three to four years. 

What do I think about the stability of the solution?

I rate the solution's stability a seven out of ten. It has limitations on rows, datasets, and the things that can add to the memory. 

What do I think about the scalability of the solution?

I rate the product's scalability a ten out of ten. It is resilient and scalable. 

How are customer service and support?

I am a technical supporter and can support myself. 

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

Before Microsoft Power BI, we used Reporting Services. We switched to it because it is part of Microsoft's ecosystem, and Microsoft has mapped the roadmap for visualization from SSRS to Microsoft Power BI.

How was the initial setup?

I rate the solution's deployment ease a ten out of ten. It is easy and can take around 14 hours to complete. 

What about the implementation team?

Microsoft Power BI's deployment was done in-house. 

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

The solution's pricing is medium.

What other advice do I have?

I would recommend Microsoft Power BI based on the use cases. I rate it a seven out of ten. 

Which deployment model are you using for this solution?

Hybrid Cloud
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Peter Phillips - PeerSpot reviewer
Owner at PJP Consultants limited
Real User
Jul 24, 2024
A business analytics solution for interrogating financial data and as the primary reporting tool by using Power Query directly from Excel
Pros and Cons
  • "The most effective feature of Microsoft Power BI for data analysis is the ability to use Power Query directly from Excel. Power BI's integration capabilities impacted our data management by allowing us to push all reporting down to the end user, giving them the capability to perform "what if" scenarios and discover and validate their own data without needing to refer to IT. Additionally, it provided insights that we couldn't get from Oracle Cloud. We wrote an extract routine to transfer our Oracle Cloud database to Power BI, which was a game changer in terms of giving people confidence in the finances."
  • "It was easy to implement Microsoft Power BI into our existing infrastructure, but integrating it with Oracle Cloud was very difficult. The integration with Oracle Cloud required us to build a sophisticated database replication process because the APIs for Oracle Cloud are very restricted in terms of volume, depth, and complexity of queries. However, the part of implementing Power BI into our infrastructure was very easy. It required almost no tech input because it was all part of Office 365. To overcome the integration issues, we developed an extract and update process, although it was quite complicated and involved a lot of IP. Power BI excels in integrations and its ability to handle various data sources. It would be beneficial if it could integrate more seamlessly with cloud interfaces like Oracle Cloud, although I understand the challenges with Oracle's policies on database access. Another area for improvement would be enhancing error messaging, especially when working with Dataverse and M Code for automation."

What is our primary use case?


Microsoft Power BI is primarily used in our customers' organizations for interrogating financial data and as the primary reporting tool.

How has it helped my organization?

In terms of impact, Power BI significantly improved decision-making and instilled confidence in our data. It also resulted in cost savings by avoiding the purchase of expensive Oracle integration tools like ODI. These savings were crucial for our fast-growing company, allowing scalability without increasing expenditure.

What is most valuable?

The most effective feature of Microsoft Power BI for data analysis is the ability to use Power Query directly from Excel. Power BI's integration capabilities impacted our data management by allowing us to push all reporting down to the end user, giving them the capability to perform "what if" scenarios and discover and validate their own data without needing to refer to IT. Additionally, it provided insights that we couldn't get from Oracle Cloud. We wrote an extract routine to transfer our Oracle Cloud database to Power BI, which was a game changer in terms of giving people confidence in the finances.

What needs improvement?

It was easy to implement Microsoft Power BI into our existing infrastructure, but integrating it with Oracle Cloud was very difficult. The integration with Oracle Cloud required us to build a sophisticated database replication process because the APIs for Oracle Cloud are very restricted in terms of volume, depth, and complexity of queries. However, the part of implementing Power BI into our infrastructure was very easy. It required almost no tech input because it was all part of Office 365. To overcome the integration issues, we developed an extract and update process, although it was quite complicated and involved a lot of IP.

Power BI excels in integrations and its ability to handle various data sources. It would be beneficial if it could integrate more seamlessly with cloud interfaces like Oracle Cloud, although I understand the challenges with Oracle's policies on database access. Another area for improvement would be enhancing error messaging, especially when working with Dataverse and M Code for automation.

For how long have I used the solution?

I have been using Microsoft Power BI for the past ten years.

How are customer service and support?


We received great help from Power BI's technical support, especially since we were early adopters back in 2013. The forums and user groups were particularly valuable for us.

What other advice do I have?

I would rate Power BI overall as an eight. It's a very powerful tool for users, which I appreciate. However, there are some areas that could be improved.

As for AI-driven decision processes, I believe Power BI supports them, although we haven't utilized those features ourselves.

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Harry Murdani - PeerSpot reviewer
Manager, IT Security at Averis Sdn Bhd
Real User
Top 20
Apr 4, 2024
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: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Sakiru Dosumu - PeerSpot reviewer
Head, Development Chapter (DevOps) at First Bank of Nigeria Ltd.
Real User
Mar 27, 2024
Flexibility and usefulness of the data are good features, but dashboards could be improved
Pros and Cons
  • "The initial setup is straightforward."
  • "Trend data and dashboards need improvement."

What is our primary use case?

I've been using it for financial data.

What is most valuable?

Flexibility and usefulness of the data.

 

What needs improvement?

Trend data and dashboards need improvement.

For how long have I used the solution?

I have been using Microsoft Power BI for some time. 

What do I think about the stability of the solution?

The stability is a seven out of ten. 

How was the initial setup?

The initial setup is straightforward. 

What other advice do I have?

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

Disclosure: My company does not have a business relationship with this vendor other than being a customer.
PeerSpot user
Buyer's Guide
Download our free Microsoft Power BI Report and get advice and tips from experienced pros sharing their opinions.
Updated: July 2026
Buyer's Guide
Download our free Microsoft Power BI Report and get advice and tips from experienced pros sharing their opinions.