Forum Discussion
How to highlight values that were loaded when refreshed?
- 5 years ago
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.
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