- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@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
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@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
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
09-26-2022 05:59 AM | |||
08-22-2024 11:32 PM | |||
Anonymous
| 06-17-2020 09:05 AM | ||
Anonymous
| 06-11-2020 05:06 PM | ||
06-24-2023 12:11 PM |
User | Count |
---|---|
32 | |
18 | |
14 | |
11 | |
9 |