Get data from a password protected website

[Anonymous]

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 it's both annoying and inefficient to use that, since I wanna the process running in the background.

(I didn't find a way of doing that using the web version of Power Automate!)

All I have to do is to access the website (using my username and password), and load a second URL which directly downloads a .xlsx file to my computer (I also would like to move the file from Downloads folder to an specific folder or even download directly to the SharePoint).

The generic URL below has the same format the original URL, without any kind of file extensions (i.e. .xlsx, etc.). I have no idea on how that URL actually works, I just know that when the URL is loaded a .xlsx file is downloaded.

https://generic_url.com/generateexcel

Does anyone have a guess on what is the best approach to do that?

Thank you!!

[SickStigma]

I can't find this panel;

All I get is:

What am I doing wrong?

Sick

[NimaiAhluwalia]

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

[Anonymous]

Hi @Anonymous ,

Did you try the web connector?

Also I found this idea, maybe you need to vote for it: Microsoft Idea .

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.