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

[@garp125]

Thanks! This is really amazing how easily you explained it!

[@HowtoPowerBI]

thank you so much for supporting the channel!!! 😊 I'm very glad to hear it helped

[@donnaknapp1610]

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. 🙂

[@martingodoy6821]

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

[@HowtoPowerBI]

genial, feliz de escuchar eso - gracias por ver martin

[@sukoi2113]

Indeed this is very useful. Both in terms of geo coordinate solution and Power Query learning as well. You are making Power BI beautiful with every such content here. God Bless you, Bass!

[@cromeromail]

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

[@michellemarighetti6722]

you save my day, thank you very much!

[@luizhenriquecostacastro7925]

Thank you so much for the video, it helped me a lot

[@dmor3359]

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.

[@markhenderson3771]

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?

[@cherylkeniston4043]

Great Material Gman..

[@rodrigo77rocha]

You are a genius!

[@PavanBidani]

Excellent! Very well explained. Thank You!

[@jasper4063]

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

[@datamatrix7]

Excellent explanation! Great Work!

[@janiszeh]

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

[@HowtoPowerBI]

;) awesome 😎 Janiszeh!

[@a_ob97]

Hi, Thank u for this video I have a question there is some calculation for the distance between two cities by using these steps behind

[@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?)

[@unnikrishnansanthosh]

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

[@antique-bs8bb]

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.

[@nikonino1899]

made my day, thank you!

[@MrDcarroll1975]

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

[@kuzog5737]

Brilliant man!

[@HowtoPowerBI]

thanks for watching ! ☺😀

[@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. 😀

[@quadrivium3272]

Thank you!

[@landonman3959]

great content. What would you suggest if have thousands of coordinates in this format: 11.11111°N, 11.11111°W? As it will give error in returning address in that format

[@daviddecastro9653]

Great content Bas!

[@joaquimcosta952]

Very very useful! Great material. Thanks..

[@phillipk9891]

How do you hide those 3 options incl the three dot ellipsis when hovering a dashboard on some visuals like card, slicers, textbox, tables, etc. Are there any fancy or creative way of hiding those settings?

[@Arrow-999]

You can select the particular visual and turnoff visual headers in settings of that visual but it will only reflect while on PBI service and not on PBI desktop.

[@rahulkumarbhagat2424]

Hi Bas.........i am having data for lat and long. I want to make clustering of that lat and long if am doing zoom in and zoom out in PowerBI Map visual. How can we achieve this? Kindly Advice

[@WillSteffen-t5i]

Awesome tut thanks. I'm running into some problems on a reverse lookup with the plus_code not always being there which I'm trying to figure out a solution to somewhere between power bi and Jupyter - how would you handle errors being returned from the geocode api here?

[@path_ethics]

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

[@music-hn2jv]

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!

[@YamaDude99]

I am also running into the same issue with the "null" values. How can we bypass?

[@amarkhaliq5020]

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

[@mcnater]

great walkthrough as usual

[@Licianalice]

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

[@alejandracastellanos6308]

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

[@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,

[@amarkhaliq5020]

what should we do to avoid extra charges as a single row is giving one request I have 23,000 rows so I will have 23,000 requests should I cancel my refresh for this report for just the api maybe I wil refresh once every 6 months

[@ahmadbutt1472]

hello @amarkhaliq5020 did you find the solution for your problem? because im facing the same the issue. it is sending atleast 2000 request whenever i press refresh

[@amarkhaliq5020]

@@ahmadbutt1472 no I haven't, I just stopped as I was only trying out the google api for learning purposes.

[@nseworld5521]

great! thanks

[@HowtoPowerBI]

:)

[@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

[@karlaksixtos6294]

hello Johann! did you get a reply somewhere else for this question? I have the same problem

[@gunruna20]

Would love if you would do the same type of video with the Bing Maps API key.

[@FamilyPlays22]

How can I do this but with local business names instead of city names? Great video bro.

[@youssefhouiet6421]

There is a tutoriel about google maps visual in power bi

[@andrecampos4252]

GOLD!

[@Arrow-999]

What will happen if I refresh the dataset on service. Will the charges apply again every time I refresh? What will happen if the data set is in direct query mode and not import mode

[@c_urrutia]

Yes!

[@deboracastanheira1844]

Can you do it with the POBox address, please?

[@HowtoPowerBI]

would be the same

[@4l3xm4r]

no free?

[@edsonteixeira6057]

SHOW SHOW SHOW