Is Data in error or mapping in error?

[mysorian]

I am using US Census Data to map land and water regions in the Hawaiian Islands. I get that information in the report correctly. But I also get results from regions that are not in Hawaiian Islands although the iinformation is related to Hawaii.

Where is the problem?

http://hodentekhelp.blogspot.com/2018/03/arcgis-powerbi-is-data-wrong-or-mapping.html

[Anonymous]

@mysorian,

ArcGIS Maps for Power BI uses the Esri World Geocoding Service to locate point features (such as addresses, United States cities, and world cities) and the Esri GeoEnrichment Service to locate boundary features (such as ZIP Codes, states, provinces, and countries).

When you directly drag name field to Location in ArcGIS map of Power BI Desktop, it is not enough for ArcGIS map to correctly guess your intent as some names may be ambiguous for ArcGIS.

In your scenario, please change location to one country as below, and if the issue still persists, I would recommend you add the latitude and longitude values in the table so that ArcGIS map  gets exact places for you.


Reference:
https://doc.arcgis.com/en/maps-for-powerbi/get-started/prepare-your-data.htm


Regards,
Lydia

[mysorian]

I do not seem to use the same version of Power BI as you do. I am unable to test.

[Anonymous]

@mysorian,

I use March update of Power BI Desktop, in your scenario, click "..." on the map and then "Edit", you should see Location Type .



Regards,
Lydia

[mysorian]

Thanks for the kind reply.

You contend that
"it is not enough for ArcGIS map to correctly guess your intent as some names may be ambiguous for ArcGIS."

I feel that, "Kakaina-Kumuhau Hawaain Home Land" cannot be very ambiguous.

The other thing I notice is that probably you are using the full-blown Plus subscription. If such is the case, I think what you are saying may be true.

I am only using the free version as I do not see the screen shot you are showing. I do not have the Location Type submenu item.