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