Web Scraping - Web.BrowserContents / Html.Table Errors
Hello All -
I managed to create a PowerQuery in PowerBI to scrape the contents of a webpage, and it does exactly what I need it to do, except that I'm realizing it would better suit me if I was doing this in Excel (I ultimately want the info in a spreadsheet for my use). However, copying the query over to Excel produces errors - notably a couple of expressions that aren't recognized: Web.BrowserContents and Html.Table. I changed Web.BrowserContents to just Web.Contents and that was fine, but I'm not sure what to replace Html.Table with to make this work. Most of the time, queries are interchangeable between Excel and PBI, but it seems using Web as source produces different results. Any easy workarounds, or will I have to rebuild my query from scratch?