Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Greetings guys!
I really wish you could help me...
When indicating the data of the cities of Pernambuco state of Brazil, for the choropleth map in the desktop power bi report server, there is a city that does not appear delimited in the Bing map in any way, city named "Nazaré da Mata".
Location data is the county name, latitude, and longitude, both classified as the corresponding data type.
In the images it is possible to see that the entire map is filled in, only that city is left unfilled and without data.
I saw that you answered a similar question this year from another user, but he didn't send you the necessary files, so the question was not resolved.
Attached files without sensitive data for analysis.
https://drive.google.com/file/d/1QvAgNfNB7S8x5M2ajmsSKiuNioCuGww9/view?usp=share_link
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Anonymous ,
Three options here:
1. Try setting just the lat/long for this particular city to null. This sounds strange but would be my first suggestion, it may trigger the geocode portion to run just for this city. I don't know if it will work but please try it out.
2. If that doesn't work, the customer can try not using lat/long at all. This will fix this particular city but may have other drawbacks:
3. If #1 doesn't work and the customer doesn't find #2 acceptable, I can go to Bing and ask them to support querying this entity as a city. This process often takes a really long time though, which is why we should try #1 first.
Best regards,
Community Support Team Selina zhu