Now I’m not a UI Flows expert by any stretch of the imagination, but within an hour I was able to create a UI Flow that: Basically, if you’re still doing lots of manual downloading, clicking, moving files etc before you can load your data into Power BI then Power Automate UI Flows can do all this for you automatically by recording and replaying everything you do. I’ve been a fan of Power Automate for a while now but it was only the release of the new Power Automate Desktop preview last week that I decided to check out its Robotic Process Automation (RPA) capabilities. You can’t click a button in Power Query.Įnter Power Automate UI Flows. This site allows you to download crime data for England and Wales, but to do so you need to check some boxes and then click the “Generate file” button at the bottom (yes I know there’s also an API, but this is only an example).
I can get data from tables on web pages, I can get data from web services, but when confronted with a website where you have to click a button to download a file there’s a problem.
As a Power BI developer I know how Power Query makes it easy to get data from web sources, but I also know there are limits to what it can do.
0 kommentar(er)
