Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Linking authentication-needing files

Hello!   I have a domain/website that needs a form authentication. After I authenticate, I can click on some links which will download some xls files.   I want to put these links into a Data Conn...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Ehren  thanks, I did try it and it does not work. It downloads this and it shows the login webpage:

 

 

 

I can check the headers when I visit the domain.com/download/425 link, would that help?

Ehren's avatar
Ehren
Microsoft Employee
4 years ago

Does the website maintain the login across sessions? In other words, if you login in IE and are able to download the xls files, and then close the browser, are you able to download the xls files without logging in the next time you open IE?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Ehren  indeed the website does not maintain the login session if I close the browser

     

    What can be done in this situation?

     

    I can keep IE/Edge open after I login manually, if needed!

    • Ehren's avatar
      Ehren
      Microsoft Employee
      4 years ago

      I'm not sure there's anything that can be done in this case.

       

      Does the website support any kind of non-interactive login/auth? That's probably the only way to make it work, if the cookies don't persist across browser sessions.

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Ehren thanks but cannot I make Power Query 'grab'/use the cookies from the browser's session? Can I enter the cookie details manually or can I specify the cookie folder of my browser so that Power Query (or any other way e.g. PowerShell) can pick them up?