The time of getting data

[Anonymous]

Hi  I would like to confirm if PowerBI supports to Get datasource time.

I have the existing data, when I get new data from other resources and combine them together,

I woud like to confirm what data is the newly added one.

Is there any way to realize that?

When  refresh dataset, I think Power BI will load the new data and replace the old data.

Since they are coming from different data sources at different time, so how to set, please kindly give me some tips. Thank you!

[v-jayw-msft · Accepted solution]

Hi @Anonymous ,

You could simply add a custom column by using DateTime.LocalNow function after a table being loaded.

Once the table is loaded or refreshed, this column records the current time, which is the most recent refresh time.

Best Regards,

Jay

[AUDISU]

@Anonymous 

Hi,

What is your data sorce (Excel, PDF, Sharepoint List ext)?

Thank you