i have 2 tables, one is a list of vehicles, the other is a regularly updated(2 minutes) list of their coordinates, with a timestamp of the coordinate, and a reference ID. i am having a bit of trouble ...

As I described here, Power BI can send SQL queries in parallel in DirectQuery mode and you can see from the Timeline column there is some parallelism happening here – the last two SQL queries ...

I know this one is gonna be pretty simple... I'm just not sure of the exact syntax. I know it has something to do with "distinct" but I'm not sure the context to use ...