Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Team,
I have a doubt on Power bi Dataflow incremental refresh, If we enable the incremental refresh on dataflow how it will handle the updated records i.e. if suppose I have one employee and his designation has software engineer and after some days he got promoted to senior software engineer, now dataflow will delete the existing record and insert the new record or updated the existing employee record with updated designation ?
Why I have got the doubt here we do not have any primary key concept and having only dates filed, so that how dataflow will understand the records is either updated record or inserted record ?
Solved! Go to Solution.
hi @Narukkp
If the old data datetime is refresh duration, then it will be updated, otherwise, it will be inserted a new record.
For example:
If you store last 5 Years data, and refresh the rows in last 10 days (Today is 6/30/2020).
Now if the date field for "one employee and his designation has software engineer" is before 10 days(before 6/20/2020), it will be inserted a new record, if date field is in 6/20/2020 - 6/30/2020, it will be updated.
Regards,
Lin
hi @Narukkp
If the old data datetime is refresh duration, then it will be updated, otherwise, it will be inserted a new record.
For example:
If you store last 5 Years data, and refresh the rows in last 10 days (Today is 6/30/2020).
Now if the date field for "one employee and his designation has software engineer" is before 10 days(before 6/20/2020), it will be inserted a new record, if date field is in 6/20/2020 - 6/30/2020, it will be updated.
Regards,
Lin
@Narukkp , refer if this can help
https://powerpivotpro.com/2019/06/how-can-i-get-a-lookup-table-from-a-slowly-changing-dimension-scd/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |