Reply
HimaBindhu
New Member
Partially syndicated - Outbound

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
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

Syndicated - Outbound

@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

avatar user
Anonymous
Not applicable

Syndicated - Outbound

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.

View solution in original post

2 REPLIES 2
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

Syndicated - Outbound

@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.
avatar user
Anonymous
Not applicable

Syndicated - Outbound

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.

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)