How to create query function for adding latitude and longitude to my data

[HimaBindhu]

I my data i am provided with country and provinces.

I dont have latitude and longitude of provinces in my dataset. I wanted to integrate bing maps with my data for pointing out provinces in maps.

How can i add lat and long to my data view and create query for pointing location.

Fast replies will be much thankful.

Regards,

Hima Bindhu

[Anonymous · Accepted solution]

@HimaBindhu,

You would need to prepare latitude  and longitude data in your data source, then refresh  in Power BI Desktop to bring new columns.

In your scenario, why not directly create map visual using country and province fields? You can set data category for your fields to proper category(country or province).



Regards,
Lydia

[Anonymous · Accepted solution]

@HimaBindhu,

You would need to prepare latitude  and longitude data in your data source, then refresh  in Power BI Desktop to bring new columns.

In your scenario, why not directly create map visual using country and province fields? You can set data category for your fields to proper category(country or province).



Regards,
Lydia

[Anonymous · Accepted solution]

As Lydia said, you will need to prepare your Lat/Long coodorindates in your data sources, even if that is a simple spreadsheet you can import and merge with your data.

To answer your question @Anonymous  the State/Province selection is problematic as it often gets the completely wrong place in the world.  A good example is the data point "Orange" which is a city in New South Wales in Australia.  Power BI commonly gets it confused with Orange County in America.  Often Lat/Long is the only method of guarenteeing the expected outcome.