Advanced Power Query - Get Data from Web

Extracting data from the web is quite easy with Power BI as it has some advanced features that recognize both the HTML and JavaScript tables. However, with Power Query in Excel, the task is easy only if the website has a static HTML table. As more and more websites now have dynamic JavaScript tables, Power Query in Excel does not recognize them and we need to get creative to extract the table by following the HTML tags structure of the document. #powerbi #powerquery #webscraping #dataanalytics #dataanalysis