Connect To Web Page Power Query. For security reasons youll need to use an on-premises data gateway with this connector. Lastly click on Data Source Settings on the Main tab in Query Editor and then Edit Credentials.
Build a query to get data from one web page. And now you have a username and password prompt. The data will disappear.
To load data from a web site with Power Query Online.
Note how Power Query was unable to identify the tabular structure of the core content of the page and instead offers a single object Table 1 revealing the data from the Sections table of the footer contents. What I did I use Chrome as default browser and login the web with the password. Note how Power Query was unable to identify the tabular structure of the core content of the page and instead offers a single object Table 1 revealing the data from the Sections table of the footer contents. Click edit now you have a open file as option select html then click ok.