

The Microsoft Power Automate, previously known as Microsoft Flow until 2019 is a cloud-based platform (SaaS), for automating recurring tasks by creating automated workflows between different apps and services. Microsoft Power Automate (Cloud) and Power Automate Desktop (PAD) are both on-code/low-code applications that can help you work smarter by automating your repetitive, manual processes like clicking and various events on Outlook and Excel. Our data source will be cloud-based on Microsoft SharePoint, the visualization tool used is Microsoft Power BI, the automation tool used is Power Automate Desktop and lastly a cloud-based schedule trigger is created using Power Automate (Flow) to activate the entire process. This entire process needs to be automated with little or no human effort. Let us use a case study, you are a data analyst for a Pizza🍕 distribution company all over Europe, and you want to see the latest report on your Power BI desktop at exactly 9:00 AM (UTC +1) but you resume work at 8:45 AM (UTC + 1). It should be noted that Power Automate Desktop works for only Windows 10 and 11(Including future releases). You should also have Power Automate Desktop already installed on your PC, this will be a vital part of the entire project. To follow along with this article, you must have basic knowledge of Power BI Desktop and Power Automate. The introduction of Power Automate Desktop in 2019 by Microsoft was designed to help employees automate repetitive and time-consuming tasks by creating various workflows to perform them. Organizations all over the world are beginning to adopt different forms of AI and Automation in their daily activities. The year 2022 can be said to be the rise of Artificial Intelligence such as ChatGPT, and with the ever-growing capacity, the world is heading to an era of quick and fast decision-making.
