Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
masplin
Impactful Individual
Impactful Individual

Scraping web pages

Hi

 

I used to be able to extract data from a website https://www.contractresearchmap.com/places/netherlands, but guessing they have tighteneed up their security. 

 

Inspecting the web page looks like this

Capture.JPG

 

However when I dril lthe tree in power query I get this

 

Capture.JPG

 

i'm sure its that last DIV I need ot get into to see the data, but there is no way forward. I dont know anything about website design, but can I assume they have closed off the abilty to access this part of the tree? 

 

Thanks for any advice

Mike

2 REPLIES 2
amitchandak
Super User
Super User

@masplin , There is expand icon near to child (the icon on the corner)

 

Same what I have done for JSON

How to import JSON Data: https://youtu.be/MPYfEetvFH4

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
masplin
Impactful Individual
Impactful Individual

But that doesnt expand the last DIV. I was expecting a table on the last row of the Chidlren column. Clicking expand just goes nowhere useful 

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.