How to use the Google Geocoding API in Power BI | Quickly find Longitude and Latitude Coordinates

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 :)

--------------------------------
📊 TRAININGS 📊
---------------------------------

---------------------------------
⏱️ 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 😍
----------------------------------

---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------

* 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

[donnaknapp]

You're brilliant. I followed your steps, but had to tweak a few things. The good news is that I got the Latitude and Longitude for over 2, 000 records. This saved me a ton of time. 🙂

[unnikrishnansanthosh]

awesome, it will help me a lot in the next dashboard of mine which is about flight timings, thanks a lot BAS

[PavanBidani]

Excellent! Very well explained. Thank You!

[janiszeh]

Great clip, it helped me a lot. Thank you Bass!

[dmor]

I have work orders on an airport. There are no physical addresses so it would be nice to click on a GE location on a tablet that will enter a GPS location (lat/long) in PowerBi map. Store it until a work order is done.

[jasper]

Thank you for the excellent content. Is there a way to access the API only when necessary? Consider a scenario where I'm adding new customers to my table, and I don't want to geocode the addresses that have already been processed. The issue I'm facing is that every time I update my table in Power Query or load it into Power BI, the engine attempts to access the Maps API. This can be both costly and time-consuming

[MrDcarroll]

This is very usefull thanks. Is there a similar one to use google maps to calculate distance between two post codes, using long and lat, but not as accurate as google directions

[markhenderson]

Thank you for your content and your easy-to-follow instructions! I saw your video on the quadrant chart as was enlightened by your use of x and y axis lines. I have a scatter plot that shows my approved exposure on the x axis and my actual exposure on the y axis for multiple borrowers. When the actual exposure exceeds the approved exposure, that is not good. I want to put a diagonal line in the scatterplot so that I clearly show all instances where the actual exposure is greater than the approved exposure. (Note: I am already using colors to delineate another variable.) Can you show how to do this?

[music-hnjv]

That's really great Bas. I could retrieve the data from API, but when I finally try to apply the modifications I've got the following message:

OLE DB or ODBC error: [Expression.Error] We cannot convert the value null to type Text

Indeed there are a few data that are returning "null" values. What should I do ? Thanks in advance!

[OleksandrPolosmak]

great video! I added few lines to your code giving me a postal code and administrative centres. Thank you!
Do you have a plan to make video on how to create own shapemap from A to Z?)

[amarkhaliq]

at 5:53 I am getting two rows instead of one please help

[antique-bsbb]

Hi - love your stuff. In this I can't find the download - I registered, got access to all the "How to Power BI" vids and links, but this one is not there (yet?).
I'll try later.

[ngeraidine]

hi, Could you make a video how to connect the power bi to a kmz source where this data source contains several cities with their latitudes and longitudes? It is possible? Rugs,

[alejandracastellanos]

Thank you! Great video. I have a question, can it work with Zip codes too?

[martingodoy]

Gracias, Gracias, Gracias!!!! Excelente... Seguí cada paso y logre hacerlo con 1200 datos de prueba, necesito hacercon con 160.000... Congratulation

[cromeromail]

Dude, your are AWESOME! Super helpful, you have taught me alot. TY Sir

[jaggyjut]

Is it possible to look for a property address on powerbi and use the Google maps api to plot it. Thanks for the tutorial. 😀

[Licianalice]

Is it possible to put a Google Earth visualization in Power BI?

[path_ethics]

What if we want to have a fuction that takes 2 variables (from diferent tables)?

[JohannSteynJr]

Great video. Is there any way to limit the Google API call to only update for new addresses? Currently when I refresh the database it calls the API for all addresses, which 1- takes long and 2- uses credits each refresh. Please help! :) And thanks again