cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

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

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

 

2 ACCEPTED SOLUTIONS
Microsoft
Microsoft

@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).
1.PNG


Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

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 @v-yuezhe-msft  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.

(I no longer have access to this account)

View solution in original post

2 REPLIES 2
Microsoft
Microsoft

@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).
1.PNG


Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

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 @v-yuezhe-msft  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.

(I no longer have access to this account)

View solution in original post

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors