Forum Discussion
Missing address in Map visual
This visual use to show all addresses in the data table, but now it's only showing 6 of the 66 addresses.
I searched an address that is not showing a yellow dot in the map and it finds it, why would it not show the yellow dot?
How do I get the missing addresses to show on the map like they use to?
This typically happens in ArcGIS for Power BI or the standard Power BI map visuals when some addresses fail to plot, even though they are searchable individually.
- Check your data
- Make sure all 66 addresses are present in your table and not filtered by a slicer, page filter, or visual-level filter.
- Look for extra spaces, spelling inconsistencies, or duplicates — clean your address column in Power Query if needed.
- Validate geocoding
- Sometimes ArcGIS stops plotting certain addresses if:
- The format is inconsistent (missing city/state/ZIP).
- The location type isn’t fully recognized (e.g., abbreviations like "St" vs "Street").
- Try standardizing addresses, e.g.:
5619 W 16TH ST, GREELEY, CO 80634- Check location settings
- In the Fields pane, ensure the data category is set correctly:
- Address = Address
- Or, if you have coordinates, use Latitude and Longitude fields for better accuracy.
- Data limit or rendering issue
- Some visuals (like ArcGIS Maps for Power BI) limit rendering by default, often around 3,500 points, but your count (66) is low, so this usually points to a data mismatch instead.
- Refresh the dataset or clear your browser cache if it’s a cached rendering glitch.
- Test in a new visual
- Add a fresh ArcGIS visual or even a basic Map visual to see if the missing addresses plot correctly there.
- If they do, the issue is with the visual settings in your original map.
- Check filters and layers
- In your screenshot, only two layers are present. Ensure your address layer is visible and not filtered.
- Use the zoom out option — sometimes addresses plot but are hidden due to map scale or clustering.
- Re-run the geocode
- If addresses still don’t appear, copy them into a separate file, import again, and let the map geocode them fresh.
I hope it will help
5 Replies
This typically happens in ArcGIS for Power BI or the standard Power BI map visuals when some addresses fail to plot, even though they are searchable individually.
- Check your data
- Make sure all 66 addresses are present in your table and not filtered by a slicer, page filter, or visual-level filter.
- Look for extra spaces, spelling inconsistencies, or duplicates — clean your address column in Power Query if needed.
- Validate geocoding
- Sometimes ArcGIS stops plotting certain addresses if:
- The format is inconsistent (missing city/state/ZIP).
- The location type isn’t fully recognized (e.g., abbreviations like "St" vs "Street").
- Try standardizing addresses, e.g.:
5619 W 16TH ST, GREELEY, CO 80634- Check location settings
- In the Fields pane, ensure the data category is set correctly:
- Address = Address
- Or, if you have coordinates, use Latitude and Longitude fields for better accuracy.
- Data limit or rendering issue
- Some visuals (like ArcGIS Maps for Power BI) limit rendering by default, often around 3,500 points, but your count (66) is low, so this usually points to a data mismatch instead.
- Refresh the dataset or clear your browser cache if it’s a cached rendering glitch.
- Test in a new visual
- Add a fresh ArcGIS visual or even a basic Map visual to see if the missing addresses plot correctly there.
- If they do, the issue is with the visual settings in your original map.
- Check filters and layers
- In your screenshot, only two layers are present. Ensure your address layer is visible and not filtered.
- Use the zoom out option — sometimes addresses plot but are hidden due to map scale or clustering.
- Re-run the geocode
- If addresses still don’t appear, copy them into a separate file, import again, and let the map geocode them fresh.
I hope it will help
At work, we don't rely on addresses but on geo coordinates. Addressess sometimes aren't plotted correctly (being in a different location due to a similarity in the name) or not plotted at all.
Hi inglexjc ,
Big thanks to Ilgar_Zarbali for sharing those detailed troubleshooting steps. They really hit the key areas filters, data category settings, and address standardization which often resolve this type of issue in ArcGIS for Power BI.
Were you able to try these suggestions yet? Specifically:
- Checking for any active visual/page filters.
- Making sure your address field is categorized as address.
- Refreshing the dataset and re-running geocoding after standardizing addresses.
These steps usually bring back all the points on the map. If you’ve already tried them and still see missing locations, let us know we can dive deeper or explore danextian suggestion about using coordinates for long-term accuracy.
Looking forward to hearing how it goes.
Regards,
Akhil.If I remove the GIS aspect and use the regular map then all points show up.
In the data we don't have the State listed. I'm going to update the code to include this and see if that helps the GIS visual show all points. We didn't need the State before, it was working fine last month. But I'll make this change and see if it helps.
Thank you.
Ilgar_Zarbali and or danextian I've added State and Zip code to the data. The GIS layer for the address is still not showing. I've tried Mergeing the columns of address, City, State, Zip and making sure the merge column has Data category of "Address". This did not work. I've also tried creating a new column using DAX coding of = Table.AddColumn(dbo_TR_Emergency_Map, "Full Address", each [Address] & ", " &[City] & ", " &[State] & ", " &[Zip]) Made sure this enw column has data category of "Address" and this does not work.
This use to show the address points, why would it stop? I need to use GIS maping for this dashboard and can't use the PowerBI map which does show the address with no issues.
