Dataflow gen 2 not using newst data, seems to be using old cached data

[DinDataPartner]

I have two tabels in Dataflow gen 2:

1) employee master data

2) list of the employees first employmentdate

I combine the two tabels based on an employeecode, in the preview it shows it has correctly found the match and show the correct data for the first employmentdate: 2020-01-20, when i save the combination, and go to the column and set the column preview it again shows me the correct  first employmentdate: 2020-01-20, but when i then expand the column to actually get the value it now says 2025-01-01. 

2025-01-01 was the value the 2nd tabel showed before i changed some of the logic and now it shows 2020-01-20, but i can only get the old value in the expand. And when i run the flow it is also the old value that is being saved to the lakehouse.

So i can see multiple places that it show show 2020-01-20, but when i actually expand it shows the old value: 2025-01-01

[miguel]

Please share your M code for each of your queries or a Power Query template file without sensitive or private information so we can better understand the logic behind your queries that could explain the behavior that you're seeing