cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
WillemC
Resolver I
Resolver I

MAP showing wrong locations

Hello all,

 

I'm from the EU and have different zip-codes in our system.

Our customers and suppliers are based in different EU-country's,

 

When I create a MAP, I can use a combination of place name, zip-code and streetname.

Most locations pop-up correctly, but some don't.

When I look at the specific locations that don't show up correctly, I don't see any strange values.

For example the Location Bakel in the Netherlands, is put on a place called Bakel somewhere in Africa.

But in my data I addes the placename, zip-code and streetname.

 

When I search for the location on the Bing Maps itself (bing.com/maps) then the correct location show, so the combination placename, zip-code and streetname is correct.

 

Is there any way to solve this, or is this a flaw in Power BI?

2 ACCEPTED SOLUTIONS
v-huizhn-msft
Microsoft
Microsoft

Hi @WillemC,

 As I tested, I use Bakel as location, it also disply in Africa. While I add country, use "Bakel, Netherlands" as location. It can work correctly. I suggest you add country to the combination, then check if works fine.

In addition, please review this blog, which provide several tips to increase the likelihood of correct geo-coding.


Thanks,
Angelia

View solution in original post

Some additional information for anyone who encounters the same problem.

I really helped to create a new column with the streetname, city and country concatenated.

Make sure that there is a , between the city and country.

so i.e.: Streetname,Bakel, Netherlands

Then it pop ups correctly.

The shortcut "NL" won't work for 100%

View solution in original post

4 REPLIES 4
v-huizhn-msft
Microsoft
Microsoft

Hi @WillemC,

 As I tested, I use Bakel as location, it also disply in Africa. While I add country, use "Bakel, Netherlands" as location. It can work correctly. I suggest you add country to the combination, then check if works fine.

In addition, please review this blog, which provide several tips to increase the likelihood of correct geo-coding.


Thanks,
Angelia

View solution in original post

In case of Data records are coming from Azure (automatically), how can I proceed? I'm not able to include a column, right?

 

Any ideas?

 

Thanks

Thank you for your reply.

Offcourse I could have think of adding the country value also.

Thank you for pointing it out to me.

Some additional information for anyone who encounters the same problem.

I really helped to create a new column with the streetname, city and country concatenated.

Make sure that there is a , between the city and country.

so i.e.: Streetname,Bakel, Netherlands

Then it pop ups correctly.

The shortcut "NL" won't work for 100%

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!