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  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?

  • Ehren's avatar
    Ehren
    Microsoft Employee
    4 years ago

    Web.Contents shares cookies with Internet Explorer (but not with Edge). But beyond that there's no way to share cookies, and if the site you're accessing doesn't persist logins across browser sessions, there's no way to make this work in PQ.

     

    EDIT: One other thing you could try would be to use the legacy Web data source in Excel, which pops an interactive browser. If you sign in via that and then try refreshing in PQ, that may work.