Mapping in Malaysia

[flintstone]

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?

[v-janeyg-msft · Accepted solution]

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

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.

[amitchandak]

@flintstone , do you have long, lat information? because using that you can easily get the distance.

[flintstone]

Sorry, I had mentioned before. No gps data => no long nor lat