Forum Discussion
Get from web - behind login screen
Hi,
I did a lot of searches on this but I didnt find much of a solution except for enabling Web Legacy mode in Excel which can do it.
Heopfully there is a way to do this in PBI now but I cannot find much recent.
Anyway, I have a table in a webpage I need to pull into Power Query. The problem is you need to login to the webpage before you can access it. Is there anyway to do this in Power Query?
In a browser, I goto the page, and get directed to another to login, then I can get the page I need.
Report is here:
https://webpage.server.net/group123/QuickReport/Action/View/23236
Redirects to here until you login:
https://webpage.server.net/group123/
2 Replies
Hi Anonymous ,
When you connect to the web with login, you will be asked to enter your credentials to connect.
Once you’ve typed in (or pasted) the URL, select OK. It prompts you to specify how you want to access the 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.