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. 🙂
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!
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
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?
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.
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?)
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.
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?
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?
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.
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
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
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
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!
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,
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
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
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
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
![Noob To Max With DRAGON REWORK In Blox Fruits [FULL MOVIE]](http://i.ytimg.com/vi/LnBMOinoOvA/mqdefault.jpg)
Thanks! This is really amazing how easily you explained it!
thank you so much for supporting the channel!!! 😊 I'm very glad to hear it helped
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. 🙂
Gracias, Gracias, Gracias!!!! Excelente... Seguí cada paso y logre hacerlo con 1200 datos de prueba, necesito hacercon con 160.000... Congratulation
genial, feliz de escuchar eso - gracias por ver martin
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!
Dude, your are AWESOME! Super helpful, you have taught me alot. TY Sir
you save my day, thank you very much!
Thank you so much for the video, it helped me a lot
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
Great Material Gman..
Excellent! Very well explained. Thank You!
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?
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.
Excellent explanation! Great Work!
Great clip, it helped me a lot. Thank you Bass!
;) awesome 😎 Janiszeh!
You are a genius!
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?)
awesome , it will help me a lot in the next dashboard of mine which is about flight timings , thanks a lot BAS
Brilliant man!
thanks for watching ! ☺😀
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
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.
made my day, thank you!
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?
at 5:53 I am getting two rows instead of one please help
Great content Bas!
Very very useful! Great material. Thanks..
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?
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.
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
great walkthrough as usual
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
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
Is it possible to look for a property address on powerbi and use the Google maps api to plot it. Thanks for the tutorial. 😀
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!
I am also running into the same issue with the "null" values. How can we bypass?
What if we want to have a fuction that takes 2 variables (from diferent tables)?
Thank you! Great video. I have a question, can it work with Zip codes too?
Thank you!
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,
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
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
@@ahmadbutt1472 no I haven't, I just stopped as I was only trying out the google api for learning purposes.
Is it possible to put a Google Earth visualization in Power BI?
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
hello Johann! did you get a reply somewhere else for this question? I have the same problem
great! thanks
:)
How can I do this but with local business names instead of city names? Great video bro.
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
Yes!
Would love if you would do the same type of video with the Bing Maps API key.
There is a tutoriel about google maps visual in power bi
GOLD!
Can you do it with the POBox address, please?
would be the same
no free?
SHOW SHOW SHOW