How to add dropdown menu to every row from another table

[cs_mvo]

Hi ,

I would like to create an assignment dashboard which I query from the sql database. 

Doc No	Date	Shipping Via	Shipping Info	Customer	Address	Agent	Driver
1	27/05/2022	Truck	1:00pm	ABC	123	John
2	27/05/2022	Truck	3:00pm	DEF	456	Mary

As I dont have the Driver table, I've created a table in power bi with all the drivers name. Now, I would like to add a dropdown list of the drivers name in every row created for my colleague to assign them. How do I achieve this target or if there's better way to achieve this, kindly advice.

Thanks in advance!

[lbendlin]

Power BI is a reporting tool, not a disposition tool (unfortunately - the data write back features are very minimal).

you can consider including PowerApps visuals that have this functionality but the UX will be suboptimal.