Can G&T be used to get HTML web page content where there are no tables? G&T shows a "Document" that can be loaded into a Worksheet but when that action is taken, it just shows headers with no content. It appears it is only useful for web pages containing tables. I am familiar with the "Get External Data" feature which can be used for non-table data.
Thanks
Hello,
with pages that use javascript to load page content asynchroneously, it is very common that Power Query considers the page loaded before the javascript is done and returns a page without content.
A workaround could be to use Data > From Web, dump the page content into a worksheet, then use that Excel sheet as a source for Power Query.
cheers, teylyn
Thanks teylyn. I had not thought of that approach.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks