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!
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?)
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.
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
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.
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
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!
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
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.
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,
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
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?
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 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
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
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
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?)
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?
Great clip, it helped me a lot. Thank you Bass!
;) awesome 😎 Janiszeh!
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
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.
awesome , it will help me a lot in the next dashboard of mine which is about flight timings , thanks a lot BAS
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!
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.
Is it possible to look for a property address on powerbi and use the Google maps api to plot it. Thanks for the tutorial. 😀
Thank you!
Excellent explanation! Great Work!
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
made my day, thank you!
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
Brilliant man!
thanks for watching ! ☺😀
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?
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
Would love if you would do the same type of video with the Bing Maps API key.
Very very useful! Great material. Thanks..
Great content Bas!
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.
What if we want to have a fuction that takes 2 variables (from diferent tables)?
How can I do this but with local business names instead of city names? Great video bro.
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,
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
great walkthrough as usual
Thank you! Great video. I have a question, can it work with Zip codes too?
Is it possible to put a Google Earth visualization in Power BI?
at 5:53 I am getting two rows instead of one please help
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?
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
:)
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.
There is a tutoriel about google maps visual in power bi
GOLD!
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!
Can you do it with the POBox address, please?
would be the same
no free?
SHOW SHOW SHOW