Geocode Addresses for Power BI Excel — Without Uploading the List
Updated September 2026 | By Excel Distance Calculators
You exported stores or customers to Excel, opened Power BI, and dropped Address on a map. The visual has Latitude and Longitude buckets for a reason. Microsoft tells you to put those fields in the semantic model. This is how to geocode addresses for Power BI Excel in the file you already keep — then load the two extra columns and pin the report.
Why the PBI map visual wants lat/long
Microsoft's map tips page is one sentence: add latitude and longitude to your semantic model. That removes any ambiguity and returns results more quickly. Both fields have to be Decimal Number. If those columns exist, use them — drag them into the visual's Latitude and Longitude wells.
On Bing-backed bubble maps, supply lat/long and Power BI does not send Location values to Bing. Skip the coordinates and the Location bucket goes to Bing for geo-coding. Microsoft's word for that lookup is a best guess when the text is thin.
Azure Maps — the visual Microsoft is migrating reports toward — locates places with a lat/long coordinate system. Addresses can go in Location. Microsoft is explicit that addresses work, and that the address controls the granularity: a city versus a specific street. The Location bucket is described as country/region, state, and city. That's a territory map, not store pins on the correct door.
ArcGIS for Power BI can geocode from Location. Esri's FAQ is the tell: use the lat/long wells and no data is passed to Esri for geocoding — but you have to convert addresses to coordinates before you add them to the map. Guest users are capped at 3,500 locations per map and 10,000 per month; a signed-in ArcGIS account gets 10,000 per map. The Location well takes one concatenated value, not your Street / City / State / Zip columns.
Power BI can try to geocode. A street-level store map from an Excel dump is where that try stops being enough. Pre-geocode in the spreadsheet. Then the visual plots.
How a BI Analyst Uses This: A business intelligence analyst building a store or customer map from a weekly Excel export has addresses and no coordinates. Dropping Address into Location puts pins on the wrong city or hits Esri's 3,500-point guest cap on an 8,000-row file. They paste the export into the Excel Latitude/Longitude Generator (GeoCoder), keep Latitude and Longitude in that workbook, Get Data from Excel, and drag the two fields into the map visual's lat/long wells. The list never went to an upload form.
Paste addresses in Excel
Open the Excel Latitude/Longitude Generator (GeoCoder) — $97 single user / $187 multi-user, one-time. Paste the address column from the export. Full street, city and state, or zip all run. Click once. Latitude and longitude write into the sheet. Save. In Power BI Desktop, Get Data from that workbook, set both columns to Decimal Number, and drag them into the visual's lat/long buckets.
Microsoft still wants a Location field on some map visuals so the points don't aggregate up to state. Use Store ID, Customer ID, or the original address there. The pins come from the coordinates.
- Paste the address column — street, city/state, or zip, one location per row.
- Click to geocode — coordinates fill in the same workbook. Your Google API key stays in your Google account.
- Get Data in Power BI — point at that Excel file. Decimal Number on both coordinate columns.
- Drop lat/long into the visual — Azure Maps, Bing map, or ArcGIS lat/long wells. Put an ID in Location if the visual still asks for one.
Need the click-by-click paste-and-run walkthrough? Use the existing How to Batch Geocode Addresses in Excel post. This article is the Power BI side: get the two columns the map visual consumes. Reverse geocoding is in the Excel geocoding tools collection if you start from coordinates.
Real-World Example: A retail operations analyst refreshes a 2,400-store Excel extract every week for a Monday Power BI map. Putting Address in Location clustered half the chain on the state capital. After one GeoCoder pass, Latitude and Longitude are in the extract. The next Get Data refresh pins each store on the lot. Same workbook. No list uploaded anywhere.
Zip-only lists
A lot of CRM exports are zip, not street. In ArcGIS for Power BI, a ZIP column in Location is typically a polygon — the zip boundary — not a store pin. Nonresidential PO-box zips often have no boundary; Esri's GeoEnrichment path errors if you ask for Boundaries. Azure Maps' Location field is built for country, state, and city. A zip-only list in Location lands on a centroid, not a storefront.
The GeoCoder still accepts zip codes. You get a lat/long pair per row, which the visual plots as a point. Treat that point as the zip, not the storefront. When the export has a street, paste the street.
Data stays in the file
The reason this is a $97 Excel file and not another website is the list. Customer addresses belong in the workbook you already control. The GeoCoder runs in Excel. Addresses stay in that file. The API key stays in your Google account. We never host the rows. Power BI then reads the same workbook.
If the report also needs driving miles between those pins and a warehouse, that's a second job on the same list. Use the Excel Driving Distance Calculator for To/From miles after the map is honest. Don't start with an upload for either step.
Frequently Asked Questions
Will Power BI map a table of Excel addresses without lat/long?
Sometimes, at city or zip grain, if you categorize fields and feed Location. Microsoft still tells you to add lat/long when you have them, and calls the text lookup a best guess. Azure Maps Location is country/state/city granularity. ArcGIS guest maps cap geocoding at 3,500 points per map. For a store or customer pin map, geocode in Excel first.
How do I geocode addresses for Power BI Excel if I only have zip codes?
Paste the zip column into GeoCoder and take the lat/long it writes back. That's a centroid point the visual can plot. It is not a rooftop. When the export has a street, paste the street instead.
Do I have to upload the customer file to get coordinates?
No. Paste into the GeoCoder workbook, let the columns fill, and point Power BI at that file. The list stays in Excel.
Ready to Stop Doing It the Hard Way?
Get the Excel Latitude/Longitude Generator (GeoCoder) — $97 single user / $187 multi-user, one-time. Paste the Power BI export, click once, keep lat/long in the file, then drop those columns on the map visual. Free Zoom to set the API key. Questions? Call (801) 243-8350.
Excel Distance Calculators builds Excel-based tools that connect directly to Google Maps for driving distances, geocoding, route optimization, and more. Used by logistics companies, trucking fleets, healthcare providers, field service teams, and thousands of businesses worldwide. No coding required — just paste your data and click.
