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

DinDataPartner — Fri, 21 Feb 2025 12:23:52 GMT

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

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

miguel — Sat, 22 Feb 2025 17:12:15 GMT

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

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

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

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