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
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

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.

Top Kudoed Authors