Microsoft Power Automate vs. Microsoft Power BI

If you are in a team that needs to develop automated solutions but have no coding experience and no access to a developer, Power Automate is one of the best places to start. It is incredibly flexible and likely has triggers and actions that can connect with your platforms, especially if you use the Microsoft stack. Additionally, using webhooks, you can connect to many different endpoints to get systems working together.

Incentivized

Has significantly improved collation of data and visualisation especially with business across Europe. Has given me the ability to see the Site availability at the click of a button to see which Site is in the "money" and seize opportunities based on Market data

Incentivized

• Sending confirmation email to clients and user once the flow is triggered.
• Fetching or Dumping files from one location to another if the flow is triggered.
• Schedule flow helps to send alerts and triggers the flow at a specific interval of time to carry out the required task.
• Power Automate also be used to convert any file format to a specific file format and save it to the required location

Incentivized

• Options for data source connections are immense. Not just which sources, but your options for *how* the data is brought in.
• Constant updates (this is both good and bad at times).
• User friendliness. I can get the data connections set up and draft some quick visuals, then release to the target audience and let them expand on it how they want to.

Incentivized

• I REALLY wish I could just drop in a block of python or PowerShell code sometimes. The visual low-code things are great for moving around data but sometimes it would be faster if I could just tap out some code.
• The DOM (Document Object Model) is not entirely apparent and takes a lot of trial and error, and sometimes it's even different between different connectors. I would love to be able to just see the path to access some specific variables from earlier processes.

Incentivized

• It would be easier for users could Microsoft Power BI and Excel used the same programming languages.
• Would like to see the online version of Microsoft Power BI be as powerful as the desktop version.
• Publishing a Microsoft Power BI file online and then having to save the file is somewhat redundant.
• Would like to export each page or chart as an image.

Incentivized

The tool is very useful when used with its various native connectors, taking great advantage of the integration between the components and systems of the Office365 universe. However, its cost is still high, and automation using more advanced components containing AI resources becomes unfeasible for some companies. Due to the financial crisis that many companies are currently experiencing, investment in automation systems or tools is taking a back seat.

Incentivized

Microsoft Power BI is an excellent and scalable tool. It has a learning curve, but once you get past that, the sky is the limit and you can build from the most simple to the most complex dashboards. I have built everything from simple reports with only a few data points to complex reports with many pages and advanced filtering.

Power Automate features a clean and intuitive user interface that allows users to create, manage, and monitor workflows easily. The UI is designed to be accessible to both technical and non-technical users, with drag-and-drop functionality for building workflows. Power Automate supports integration with a wide range of Microsoft and third-party applications. This flexibility in integration allows users to automate workflows across various systems, enhancing overall productivity and efficiency.

Incentivized

Automating reporting has reduced manual data processing by 50-70%, freeing up analysts for higher-value tasks. A finance team that previously spent 20+ hours per week on Excel-based reports now does it in minutes with Microsoft Power BI's automated Real-time dashboards have shortened decision cycles by 30-40%, enabling leadership to react quickly to sales trends, operational bottlenecks, and customer behavior.

Incentivized

both Community support and Microsoft official support typically respond to (and resolve) reported issues in a VERY expedient manner, usually going above and beyond for education and bugfixing. I have been thoroughly impressed with the level of support I had been provided in the past.

Incentivized

It is a fantastic tool, you can do almost everything related with data and reports, it is a perfect substitutive of Power Point and Excel with a high evolution and flexibility, and also it is very friendly and easy to share. I think all companies should have Power BI (or other BI tool) in their software package and if they are in the MS Suite, for sure Power BI should be the one due to all the benefits of the MS ecosystem.

Incentivized

after reviewing the main features of Power Automate, the Microsoft trainer focused on some of our real life use cases implementation, from simple to more advanced.

Incentivized

although it was productive, it is more difficult to stay focused and in a 7 hours a day online training (including screen share issues and the fact that the trainer just can't precisely show the exact location of your mistake)

Incentivized

I was part of the migration of classic SharePoint workflows and Nintex workflows. We didn't spend much time learning the new platform because of its user-friendly interface and intuitive drag-and-drop functionality. We have mostly O365 E1 and E3 licensed users, so they can participate in our Citizen Development program and utilize Power Automate to build day-to-day business processes.

Incentivized

It was integrated with our erp easily and was accessible on cloud.

Incentivized

I have many years of experience with Nintex applications and it stands up very well against Microsoft Power Automate. I hope Microsoft Power Automate can become the better workflow application. With the Integrated AI builder and continuous updates I expect they can become the better one in a few years.

Incentivized

Microsoft Power BI is free. If I didn't want to create a custom platform (i.e. my organization insisted on an existing platform that I *had* to use), I'd use Microsoft Power BI. For any start-up or SMB, I'd just use Claude & Grok to build it quickly, also for free. Would not pay for Tableau or Sigma anymore. Not worth it at all.

Incentivized

I have not done any participations

Incentivized

Microsoft's professional services provide hands-on support throughout the implementation lifecycle of Power Automate.This includes initial setup, configuration, integration with existing systems, testing, and deployment. They ensure that workflows are correctly designed, optimized for performance, and aligned with security best practices.

Incentivized

• It has encouraged everyday users to get a feel for low code no code without the detailed technical programmings skills
• This has encouraged the use of Power Automate to replace what was once an excel filled with complex macros and VBA!
• It has significantly saved time for someone like myself from chasing people for information and now I can create an auto alert using PA

Incentivized

• Power BI usage reduced the effort of analytical reports creation by about 80%
• Empowered all the level of employee to be more vigilant of the data and business insights, gained the profit of 8% overall.
• AI-powered predictive analytics improved forecasting accuracy by 17%, that topped the overall sales.

Incentivized