October 25, 2021
|1) I want to get the data into the web query from url https://www.screener.in/screen.....all-stock/
|2) This screen can be accessed with user is logged in
|3) but when user is not logged in this screen cannot be accessed
|4) I want to retrieve this data into the excel.
|5) Added the following code in Advance Editor and authentication type as basic
|7) Following error is thrown, attached in the xls
|8) Any help in this regards is highly appreciated.
October 5, 2010
Unfortunately Power Query doesn't have a way to login to websites that require a form to be completed via the web browser interface. If this website had an API that you could use then you could login that way, but the site doesn't appear to provide an API.
An alternative is to use something like Selenium and VBA to interact with the website, login and get the data you want.
October 18, 2018