A step-by-step walkthrough of querying OpenStreetMap data using the Overpass API and Overpass QL to retrieve wild swimming locations in Portugal and Spain, then loading that data into Power BI to build an interactive map with photo tooltips. Covers OSM fundamentals (nodes, ways, relations, tags), building Overpass QL queries with area filtering and CSV output, importing the data via Power BI's Web connector, transforming it in Power Query, and adding Azure Maps visuals with tooltip pages showing location photos.

16m read timeFrom towardsdatascience.com
Post cover image
Table of contents
OpenStreetMap 101Overpass API/Overpass QLGetting Openstreetmap data in Power BIContributing to my own project

Sort: