Forum Discussion

unknown917's avatar
unknown917
Helper IV
5 months ago
Solved

Dynamic route creation?

Is it possible for PBI to create a dynamic route plan if given a set of criteria?   Building blocks would be something like:   Shipping Depot Capacity of Container Hours of service min and max ...
Need Help
Tips and Tricks
  • Kedar_Pande's avatar
    Kedar_Pande
    5 months ago

      

    No, Power BI can't solve vehicle routing optimization natively.

     

    Alternatives:

    Python visual with NetworkX or PuLP (import your criteria, export routes as table)

    Call Azure Maps/Google OR-Tools API via Power Automate

    Embed route visuals (like Route Map custom visual) but optimization happens externally

     

     

    If this answer helped, please click 👍 or Accept as Solution.
    -Kedar
    LinkedIn: https://www.linkedin.com/in/kedar-pande

     

    unknown917

krishnakanth240's avatar
krishnakanth240
Super User
5 months ago

Hi unknown917 

 

Not directly. Power BI is mainly a data visualization and analytics tool and not a route optimization engine.

You can analyze routes, schedules, and capacity but creating dynamic route plans based on constraints (capacity, service windows, and balancing) requires an optimization algorithm.

 

You can use tools like Python, Azure Maps, or route optimization APIs to generate the route plan.