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

lbendlin's avatar
lbendlin
Super User
5 months ago

Power BI is a reporting tool.  It has limited modeling capabilities but it is definitely not a resource planning tool. It also lacks route planning features - all it can do is show maps and locations on maps  (and straight distances between those locations, which is pretty useless in the real world of transportation).

 

I would think that there are applications available that suit your industry specific requirements.