Forum Discussion
How to detect the changes in Historical data while after incremental refresh
Hi @all, Is it possible to detect historical data after an incremental refresh has occurred? How can we achieve this while using incremental refresh? Additionally, can we track the changes or update...
Hi AzaharoddinSk,
As far as I know, it does not inherently provide a way to track historical changes or store previous versions of the data.
You will need to either adjust the source system by implementing a historical table to track changes, or establish an intermediate process that captures a daily snapshot of the data. This way, Power BI can access both the current data and the snapshot for comparison purposes.
Best regards,
Joyce
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.