frithjof_v's avatar
frithjof_v
Community Champion
1 year ago
Status:
Need Clarification

Dataflow Gen2 Fast Copy: Add timestamp column

When ingesting data, we wish to add a "IngestedDateTimeUtc" column.

 

So we can keep track of when the data was ingested.

 

Currently, this is not possible with Dataflow Gen2 Fast Copy. Please make it possible 🙂 Thanks!

2 Comments

  • miguel's avatar
    miguel
    Community Admin
    Status changed:
    New
    to
    Need Clarification

    You can do this today by adding a custom column that leverages the function below:

    DateTime.LocalNow - PowerQuery M | Microsoft Learn

     

    You should be able to leverage this even when FastCopy is at play. Would you mind giving this a try and share with us your findings? 

Recent ideas