cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
WillemC Regular Visitor
Regular Visitor

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

Accepted Solutions
v-huizhn-msft Super Contributor
Super Contributor

Re: MAP showing wrong locations

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

WillemC Regular Visitor
Regular Visitor

Re: MAP showing wrong locations

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 Super Contributor
Super Contributor

Re: MAP showing wrong locations

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

WillemC Regular Visitor
Regular Visitor

Re: MAP showing wrong locations

Thank you for your reply.

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

Thank you for pointing it out to me.

WillemC Regular Visitor
Regular Visitor

Re: MAP showing wrong locations

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

Highlighted
luiz_leme Occasional Visitor
Occasional Visitor

Re: MAP showing wrong locations

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

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 64 members 1,156 guests
Please welcome our newest community members: