Get CSV file from URL with password

[StephenF]

I wish to extract a CSV file using a URL sitting in a powerbi table record:

The Url is sitting in a cell in my current table and appears as follows.

https://adintel.ie.nielsen.com/adintelui/login.aspx?redirect=%2fadintelui%2freports.aspx%3fexport%3d...

How can I extract this file with my username and password? In a web browser it takes me to a login screen if im not logged into account already.

[Anonymous]

Hi @StephenF ,

You may try the web connector in Power BI Desktop.

Select the Basic and enter your user name and password to access web content.

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.

[StephenF]

It doesnt support credentials for me?

[StephenF]

Can you send me on the code in the advanced edit portion?