Forum Discussion

WillemC's avatar
WillemC
Resolver I
9 years ago
Solved

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?

Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    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

  • WillemC's avatar
    WillemC
    9 years ago

    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%

4 Replies

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    9 years ago

    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

    • WillemC's avatar
      WillemC
      Resolver I
      9 years ago

      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's avatar
        WillemC
        Resolver I
        9 years ago

        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%

    • luiz_leme's avatar
      luiz_leme
      New Member
      8 years ago

      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