PL-300 Geocoding Practice Question
You have a report with a map visual showing store locations by city. However, some cities are not displaying on the map. You verified that the city names are correct. What should you check first?
⚠ Common exam trap
A common trap is to assume that city names alone are sufficient for accurate mapping, but Power BI's geocoding may fail for less-known cities.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Add latitude and longitude fields to the map visual.
The correct option is B: add latitude and longitude fields to the map visual. Power BI's built-in map relies on geocoding city names, and ambiguous or duplicate city names across regions often fail to plot, so supplying explicit latitude and longitude values gives the visual unambiguous coordinates to render each store location. Option A is unnecessary because switching to the ArcGIS Map visual does not resolve missing geocoding data. Option C is irrelevant since a filled map still depends on the same geocoding and would not fix missing points. Option D is not the issue because the scenario already confirms the city names are correct, and a text data type is expected for city fields anyway.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Use ArcGIS Map visual instead of the built-in map.
Why it's wrong here
The ArcGIS Map visual, while it provides a slightly different geocoding engine and more styling options, still performs name-based geocoding when coordinates are absent. It does not guarantee that more cities will be recognized, and in fact, it may require you to enable geocoding or use the same underlying location fields. Therefore, simply swapping the visual does not address the underlying issue that store locations lack reliable spatial coordinates—adding latitude and longitude remains the definitive fix.
- ✓
Add latitude and longitude fields to the map visual.
Why this is correct
Adding latitude and longitude fields (both numeric) gives the map visual exact coordinate pairs for each store, bypassing the geocoding service entirely. This is the only option that directly addresses the root cause of a map failing to place points—the geocoder may fail on ambiguous or non-standardized city names, whereas coordinates are unambiguous, instantaneous, and always render at the correct location regardless of how the address or city is formatted.
- ✗
Change the map visual to a filled map.
Why it's wrong here
Switching to a filled map changes the visual from point-based markers to shaded region polygons, but it still relies on geocoding to match the city field against a spatial dataset of region boundaries. Without latitude and longitude, a filled map will still fail to display data for unmatched cities, and it can even obscure the problem by rendering a whole region incorrectly (e.g., placing data for 'Springfield' into the first state match), so it does not solve the accuracy issue.
- ✗
Ensure the city column is set to the Text data type.
Why it's wrong here
The city column being set to the Text data type is actually the expected state for Power BI geocoding—Power BI automatically recognizes text fields like City, State, and Country/Region. Changing the data type to Text does not help because the geocoder already accepts text; the failure occurs when a city name is missing, ambiguous (multiple cities with the same name), or not recognized by the geocoding service, not because the field is not text.
Visual reference
About these practice questions
Courseiva writes every PL-300 question from scratch — 524 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This PL-300 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PL-300 exam.