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

Kedar_Pande's avatar
Kedar_Pande
Super User
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