Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Resolver
New Member

Flow map route error

Hello, I've created a flow map for displaying top n routes by order count. The problem is that not all routes are visible on map. For data I am using city, state, country and zip code, all locations were checked on map and there were no error with data itself, but whenever I put it as a full route in flow map, some and even top 2 lanes are not displayed.

1 REPLY 1
johnbasha33
Super User
Super User

@Resolver 

1.Double-check your Top N calculation outside the map first.

  • Create a separate table visual showing exactly which Source-Destination pairs and counts are top.

  • Ensure that Flow Map is getting exactly those pairs.

2. Try to simplify the geography a bit.

  • Use City + Country or State + Country only.

  • Sometimes adding Zip Codes confuses the geocoding engine and causes routes to disappear.

3. Lower the Top N if possible.

  • Try Top 20 or Top 50 first.

  • Flow Map can choke if you push too many routes at once.

4. Check for duplicates or rounding issues.

  • If two routes have almost the same counts, and you have a Top N filter, sometimes minor rounding can push the expected routes out.

5. Try using Source Latitude/Longitude and Destination Latitude/Longitude directly.

  • If you can add lat/lon to your data, you bypass some of the geocoding guesswork.

6. Adjust settings inside the Flow Map visual

  • There is often an option like:

    • "Route smoothing"

    • "Avoid overlapping lines"

    • "Force show all routes" (depends on the visual version)

7. (Last resort) Use an alternative visual

  • If Flow Map keeps failing, try the Route Map custom visual or even ArcGIS for Power BI.

They're heavier but more reliable for lots of paths.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors