Forum Discussion
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...
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.
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?