Forum Discussion
Helper IIMapping in Malaysia
I am trying to map the distance between the locations of prospects and dealers/outlets.
For prospects, I have columns relating to partial address, postcode and state in a dataset. No gps though.
How do I generate their location in Power bi using these data?
Hi, flintstone
You can use google maps , enter the postcode to get the latitude and longitude of the member's approximate location. Another method: Google Maps API V3: Get Location (Latitude and Longitude) from Zip Code (Pin Code) using JavaScript (aspsnippets.com)
Although this may be a bit cumbersome, it may not be recognized without a specific location.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- amitchandak
Super User
flintstone , do you have long, lat information? because using that you can easily get the distance.
flintstoneSorry, I had mentioned before. No gps data => no long nor lat
- v-janeyg-msft
Community Support
Hi, flintstone
You can use google maps , enter the postcode to get the latitude and longitude of the member's approximate location. Another method: Google Maps API V3: Get Location (Latitude and Longitude) from Zip Code (Pin Code) using JavaScript (aspsnippets.com)
Although this may be a bit cumbersome, it may not be recognized without a specific location.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
