Forum Discussion

StephenF's avatar
StephenF
Icon for Responsive Resident rankResponsive Resident
3 years ago

Get CSV file from URL with password

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%3d32%257C3892%2fvars%257C%2fmethod%257Ccsvraw

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.

 

 

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
      StephenF
      Icon for Responsive Resident rankResponsive Resident

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

    • StephenF's avatar
      StephenF
      Icon for Responsive Resident rankResponsive Resident

      It doesnt support credentials for me?