Forum Discussion
Map visualation show wrong locations after update
After the update, I start to see sites from the netherlands in USA, I never had that before. I was using the full address and it's tottaly stopped working after the upgrade.
I found a previous post they show how to set data category, it's a bit better but still show sites are the wrong location.
As shown in the video from Herbert, I added a column called Country PostalCode = Portal[Country]&" "&Portal[ZipCode] and I set this data category as place. Dragging Country and ZipCode with proper Data Category doesn't help as well.
The maps were working so well before the update ... Something changed with the last update.
Now, all the sites you see in the picture are in the nederlands but they are showing in USA. I have 2000+ sites showing correctly in the Nederlands. If I put the same information in Bing map, it shows a location in the netherlands.
At then end of the day, I'm trying to display a bubble for each full address that I have in my system like I use to do before the upgrade.
Hi jdoyon,
I'd like to suggest you create custom hierarchy and use drill down to instead the concatenate columns. Actually, after the update of bing map control, the concatenate feature is not fully support on map.
Reference:
Power BI Desktop June Feature Summary
The Bing Maps team is forcing a two-fold change for Power BI; they are deprecated the Bing Maps v7 Control, and are also switching to a new geocoder. The target date is June 30th.
At this time, please download Jun release desktop and define GEO hierarchy. To take full advantage of this, you'll need to set the Data Category for each column correctly.
You can try to setting the concatenate column to 'place' catagory to work throuth it.Notice: this solution not works on some of senarios.(some contcatenate locations still not suport)
Regards,
Xiaoxin Sheng
Hi,
Thanks Xiaoxin it's working now.
In case someone else run in the same situation, here are the details steps I did:
1 - Upgrade to June 30th
2- In the datasource query editor, I created a custom column with this formula =Text.Combine({[Address],[City],[Country]}, ", ")
3 - In the Modeling Tab of PBI Desktop, I configured the data category for the new custom Column as type Place.
4 - I used the new custom column as location for the Map Control.
I also published it on Power BI Online and the maps renders properly the different locations now.
Jo
2 Replies
Hi jdoyon,
I'd like to suggest you create custom hierarchy and use drill down to instead the concatenate columns. Actually, after the update of bing map control, the concatenate feature is not fully support on map.
Reference:
Power BI Desktop June Feature Summary
The Bing Maps team is forcing a two-fold change for Power BI; they are deprecated the Bing Maps v7 Control, and are also switching to a new geocoder. The target date is June 30th.
At this time, please download Jun release desktop and define GEO hierarchy. To take full advantage of this, you'll need to set the Data Category for each column correctly.
You can try to setting the concatenate column to 'place' catagory to work throuth it.Notice: this solution not works on some of senarios.(some contcatenate locations still not suport)
Regards,
Xiaoxin Sheng
Hi,
Thanks Xiaoxin it's working now.
In case someone else run in the same situation, here are the details steps I did:
1 - Upgrade to June 30th
2- In the datasource query editor, I created a custom column with this formula =Text.Combine({[Address],[City],[Country]}, ", ")
3 - In the Modeling Tab of PBI Desktop, I configured the data category for the new custom Column as type Place.
4 - I used the new custom column as location for the Map Control.
I also published it on Power BI Online and the maps renders properly the different locations now.
Jo