Full Address doesn't plot on Bing Filled Map

[rajulshah]

Hello All,

I am trying to plot a full address on Bing Filled map, but it is unable to plot it. I have categorized each column accordingly.

• I also have separate columns for Country, State/Province, City, Zip/Postal Code, Street Address, and I have tried to plot them in Map separately. It could plot till the City hierarchy but wasn't able to plot Zip/Postal Code.
• I have also tried the Full Address as 104 St NW, Edmonton, AB T5R 0L9, Canada
  and tried to categorize as 'Place' & even 'Address', but was not successful in plotting it.
• I also tried '[ZipCode] [Country]' and categorized as 'Place' & also 'Address', but was not successful in it either.
• As in this community post, I also tried the address components as in 'hierarchical order' as said in the post, but it didn't work either.

Also, I only want to use Bing Filled Map and don't want to use ArcGIS maps.

Anyone if you could help me as soon as possible. The example, if anyone would want to try, is mentioned above in bold.

Thanks in advance.

[v-lionel-msft]

Hi @rajulshah ,

"I also have separate columns for Country, State/Province, City, Zip/Postal Code, Street Address, and I have tried to plot them in Map separately. It could plot till the City hierarchy but wasn't able to plot Zip/Postal Code."

As tested, the zip code can be used in Filled map:

   

"I have also tried the Full Address as 104 St NW, Edmonton, AB T5R 0L9, Canada
and tried to categorize as 'Place' & even 'Address', but was not successful in plotting it."

There may be a problem with the format of your full address, or your full address may be too detailed to display. you can refer to this case:

Full addresses not plotting on map  

"I also tried '[ZipCode] [Country]' and categorized as 'Place' & also 'Address', but was not successful in it either."

If you want to display a detailed address, you don't have to use the full address, it is enough to use the smallest address and set the data category, for example, use only international zip codes.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rajulshah]

Thank you for the response @v-lionel-msft.

I tested that addresses don't work on Filled maps and ZipCodes do work on Filled Maps.
However, I have ZipCode as 'T5R 0L9', which is not plotted on the map. I tried to plot 'T5R' on the map and it detects the area.

So, if I have ZipCode as 'T6J 3A5', the ZipCode isn't detected; but if I plot only 'T6J', the area is plotted on the map.

I don't know what might be the issue, or what should be the solution. Please guide.

[v-lionel-msft]

Hi @rajulshah ,

As tested, the problem you described does exist.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rajulshah]

@v-lionel-msft, yes it does exist. 😞

[Greg_Deckler]

Hmm, I don't believe that filled map works with addresses. I was able to get the following to plot on the global map.

104 St NW, Edmonton, Canada

I'm not super familiar with Canadian addresses, what part is considered the "zip code"? I attached a test PBIX. Apologies for the meme reference.

[rajulshah]

Hello @Greg_Deckler,

Thank you for the response. I want a filled map that works with Addresses. 
Also, Zipcode is the bold part here: 104 St NW, Edmonton, AB T5R 0L9, Canada

Do you have any other idea to make it work?

Apologies, I didn't get your meme reference!😅

Thanks again!

[Greg_Deckler]

So filled map won't work with addresses because there is essentially nothing to "fill". If I am correct, I believe you can go down to zip code with the filled map. I did get the following address to plot on globe map:

104 St NW, Edmonton, T5R 0L9, Canada

[rajulshah]

@Greg_Deckler, filled map doesn't work with the addresses & zipcodes.

Anyways, thanks for the help.

[Greg_Deckler]

Thanks for confirming @rajulshah . But, just so we are clear, Filled Map works with just zip codes (no address). See attached.

[PaulDBrown]

@rajulshah 

If all esle fails, you can use Google Sheets to extract LAT/LONG coordinates from addresses:

Lat/Long coordinates from addresses 

[rajulshah]

Hello @PaulDBrown,

Thank you for the response, but as long as possible I don't want to include any other datasource here.
Do you have any idea about doing that in Power BI?

Thanks again!