Forum Discussion
Performance problem with power query code refreshing a dataflow
I don't know if this is the right place to post this, but I have this code: let
SourceFiltered = Table.SelectRows(Export_Vehicles_AVX_Linked, each [ParkingLot] <> null and [ParkingLot] <> "...
I hate strongly dislike to say it but have you tested one of the standard Nested Join commands?
You may also want to move the Table.Buffer further up (assuming you have the memory)
Hi lbendlin thank you for your response.
How would I use Nested Joins here? I'm in need to calculate previous date for the same pair of parkinglot + vin code, then a date for another vin code in the same parkinglot .
On the other hand, taking further up the Buffer means going from 60k rows to 1,6M rows... I don't really know if it would change much since the table I'm referencing is a linked entity (it's the outcome table from another dataflow).
