Forum Discussion
How to highlight values that were loaded when refreshed?
Hello Everyone,
Is there a way where I could highlight the rows/values that were modified or appended when refreshed?
I want to be able to track and know all the updated values so it would be easier for the user to know the changes happening in the data.
Please help.
Hi H_AS
This is not supported in Power BI. Maybe you have considered adding a column with something like DateTime.FixedLocalNow() to record the refresh time in Power Query Editor. However, this time will be updated for the whole column every time you refresh the query. It cannot remain fixed for non-updated rows because in Power BI, every refresh is importing all necessary data again from the data source rather than importing the updated or new data.
You need to record the modified time in your data source. Maybe add a "Modified Time" column in the data source and record the time manually or automatically when a row is updated or appended. Then in Power BI, you can use the "Modified Time" column to filter rows to know which data is new.
Hope this helps.
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
3 Replies
- lbendlin
Super User
Power BI does not support CDC. You have to do that manually, at the data source, outside of Power BI.
v-jingzhangCommunity Support
Hi H_AS
This is not supported in Power BI. Maybe you have considered adding a column with something like DateTime.FixedLocalNow() to record the refresh time in Power Query Editor. However, this time will be updated for the whole column every time you refresh the query. It cannot remain fixed for non-updated rows because in Power BI, every refresh is importing all necessary data again from the data source rather than importing the updated or new data.
You need to record the modified time in your data source. Maybe add a "Modified Time" column in the data source and record the time manually or automatically when a row is updated or appended. Then in Power BI, you can use the "Modified Time" column to filter rows to know which data is new.
Hope this helps.
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.This solution helps,
Thank you
