Forum Discussion
Get data from a password protected website
I'm struggling to find a simple way to get data from a password protected website (It doesn't have an API or anything like that!). I already tried Power Automate Desktop, using Desktop Recorder but ...
Hello @gasilva8
I worked on a similar use case like this if I got you right this can be the solution for you.
My use case - I had to download the excel data from a password-protected website and then use that excel in the power bi, as this was a manual task of downloading the excel every time and updating the excel.
solution - with the help of power automate ( selenium ) - I recorded the whole process of logging in to the website and downloading the excel, but I did the whole process in a VM as scheduled to work as per the excel and power automate extraction time, and using FTP I transferred the file to the blob storage on azure and connected my power bi report.
Regards