![]() ![]() Here’s what it looked like in Power Automate Desktop: Downloaded the resulting zip file to a particular location. ![]() ![]() Clicked the Download Now button on the next screen when it appeared.Checked the boxes to download crime, outcome and stop and search data for Thames Valley Police.Opened a browser and went to (quick tip: if you want to save a file from a browser you need to use the special Automation Browser, not Chrome, Edge or Firefox).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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |