Forum Discussion

Pmorg73's avatar
Pmorg73
Icon for Post Patron rankPost Patron
7 years ago

Bing Maps in MS Teams?

Hi I have two quick queries using the built in Maps   I am based in NZ and Bing often thinks that the address is in USA. Our address field often includes a post code, but can I direct the report to...
Need Help
Pmorg73's avatar
Pmorg73
Icon for Post Patron rankPost Patron
7 years ago

Could you expand? Where would I put the Custom Value?

 

I added a "measure" column to my table that entered Location New Zealand for every entry. Blue cross in image. I then added it to the field list for the map. But as you can see it is not making the addresses move from across the globe?

 

If I individually google the address then it finds most of them where I would expect, but the Bing map is not looking locally to us in NZ.

 

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hey Pmorg73 

Not sure why you have created a measure.

I have created a column that looks like:

Full Address = 
CONCATENATE (
    Table[Address],
    CONCATENATE (
        ", ",
        CONCATENATE (
            Table[City],
            CONCATENATE (
                ", ",
                CONCATENATE (
                    Table[State],
                    CONCATENATE (
                        ", ",
                        Table[Country]
                    )
                )
            )
        )
    )
)

You can create something similar, maybe simpler.

And in the country just hard code NZ.

 

Or give a sample of your data, and we'll try to sort this issue out.

 

Cheers!
A

  • Pmorg73's avatar
    Pmorg73
    Icon for Post Patron rankPost Patron
    7 years ago

    thanks for helping.

     

    I added a concantenate measure so address plus " New Zealand"

     

    Is it me or is Bing is useless? See the image. The Location clearly says what I want. Address plus NZ. But Bing puts in near Copenhagen? If you google the address. Perfect Map. 

     

    Suggestions?

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hey Pmorg73 

      Are you using the correct field?
      Looks like you are using Job Info while you need First Location.

      Cheers!
      A

      • Pmorg73's avatar
        Pmorg73
        Icon for Post Patron rankPost Patron
        7 years ago

        yes the map is only looking at "Location" field. In the image I had selected a table just to cross check the measure was adding the address correctly.

         

        If I google that address I get a map straight away on the correct street. I then went to Edge and used Bing and it does not load any maps.

         

        As I am sharing this report in MS Teams I find the map does not work at all in there anyway. Do you know if it should work in Teams?

         

        I know that the ArcGIS map type only works in the BI desktop environment so does not work in Teams, so not an option.

         

        So I am concluding that my map may be something to remove from the report?