Hi Mynda,
I am trying to scrape the page from link https://www.azbpartners.com/people/ filtering Practice area "Private Equity & Venture Capital" in Power BI.
However, I am not able to view the specific profiles under the said Practice area. The page list down all the profiles.
Also, the web view comes with the disclaimer information so i am unable to proceed into the page.
Kindly support how to extract the profile of Private Equity & Venture Capital in Power BI.
Thank you.
Hi Sheela,
Websites like this are difficult to scrape data from because they use JavaScript to serve up the data. You can tell this is the case because when you apply the filter, the URL doesn't change.
You can open the website in another browser and type in the examples you see to get around the splash screen that displays in the Power Query preview, but even then, the CSS of the web page does not provide the information Power Query needs to see the data filtered by the Practice Area.
Unfortunately, some sites are still not able to be scraped. The best you can do is get a list of all names listed and their 'blurb' from the tables that appear when you connect to the page in Power Query. You cannot get the Office, Practice Area, Sector information etc.
Mynda
