Forum Discussion
Dataflow gen 2 not using newst data, seems to be using old cached data
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
1 Reply
- miguel
Community Admin
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