Automate Reports From External Datasources (Power Platform)

How to automate routine reports from data collection to visualization using Power Automate Cloud Flows, Power Automate Desktop Flows, SharePoint, and Power BI.
Works across any site, supported or unsupported in Power BI, and does not require any APIs.

Download The Template Report Automation Flows (Improved Version 2 Now Available)
https://powerusers.microsoft.com/t5/P...

Change CSV Delimiter Information
https://powerusers.microsoft.com/t5/P...

TachyTelic.Net Blog & Videos
Batch Create Flow
Blog: https://www.tachytelic.net/2021/06/po...
Video:    • How to use Power Automate and the Sha...  


If you are not familiar with Desktop flows, this flow requires a Power Automate license with RPA/UI Flow capabilities. Also my set-up here is using a virtual machine that is accessible from the cloud in a remote-viewer. The machine is always logged in so it can run an attended Desktop flow at any time.

**If the site you are working with only has Excel, not CSV download options, then go to my comment on the flow download page to see how to adjust this process for Excel documents.**
https://powerusers.microsoft.com/t5/P...


Venmo
https://venmo.com/u/Tyler-Kolota

PayPal
https://www.paypal.com/paypalme/takol...

Buy Me a Coffee
https://www.buymeacoffee.com/takolota


Thanks for any feedback,
And reach out on LinkedIn (  / kolota  ) if you want to hire me to consult or build more custom Microsoft solutions for you.