In this video I show you how to get the latitude and longitude coordinates for locations in Power BI (and also the reverse). I create a reusable custom function in Power Query (M) and call the Google Geocoding API to find the location information. You will learn about APIs, custom functions, and M – and believe me it is less intimidating than it might sound like.
Enjoy this video and subscribe to always stay updated on my favorite Power BI tricks 🙂

Download file here https://datatraining.io/powerbi-how-to

——————————–
TRAININGS
———————————
Power BI Design 4 Weeks Transformation Program https://my.datatraining.io/pages/powerbidesigntransformation

Power BI Essentials https://datatraining.io/powerbilearningpath

Business User Training https://datatraining.io/powerbi-business-users

For Custom Trainings and Consulting email directly [email protected]

———————————
️ TIMESTAMPS ️
———————————
00:00 Intro
00:36 Finding latitude and longitude coordinates manually
01:03 Getting started with the Google Geocoding API
04:12 Connecting to the API in Power BI
06:25 Creating the Custom M Function for Geocoding
10:07 Dealing with multiple results for one location
12:03 Finding addresses for latitude and longitude coordinates
18:29 End

———————————
JOIN
———————————-
Join https://bit.ly/4b453bi
Subscribe https://bit.ly/31MnQGO​
Insta https://www.instagram.com/howtopowerbi/
LinkedIn https://www.linkedin.com/in/basdohmen/
TikTok https://www.tiktok.com/@how.to.power.bi
X https://twitter.com/HowToPowerBI
fb https://www.facebook.com/groups/howtopowerbi
Threads https://www.threads.net/@howtopowerbi
Newsletter https://datatraining.io/newsletter

———————————
CHECK THIS OUT!
———————————
My gear https://amzn.to/47F21Yc
Power BI books MUST READ! https://amzn.to/3tUfFcj
General books I recommend https://amzn.to/48YNo33
Music for my videos https://www.epidemicsound.com/referral/8pjcbj
For growing on YouTube: https://www.tubebuddy.com/bas
Stuff I use daily https://amzn.to/3HqfMQ2

* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!

Thanks for being a part of this channel and all your support!

#HowToPowerBI​ #PowerBI​ #DataTraining​
#powerbidesktop​ #powerbitraining​ #powerbideveloper​ #DAX

Please take the opportunity to connect and share this video with your friends and family if you find it useful.