WebScrape HTML

[NSCJPN]

I am unable to download the data from below site using Power Query:
NGOs Raising Over A Crore of FC Annually – AccountAble Handbook on FCRA
The PQ result shows only Document and not Table
Is it possible to download the tables from this page?

 

[Dan_W]

I use VBA rather than PQ for webscraping, but my understanding is that, like VBA, PQ retrieves the HTML code and parses that code when scraping data. Unfortunately, the table on this site is not actually contained with the HTML code as such; rather, it relies on Javascript to subsequently retrieve the data and populate the table. That being the case, you would need to use a headless browser in order to allow the site to render the table before then scraping the page. For this, you could possibly use VBA + Selenium.