Adding date in combination with outlook

[Anonymous]

Hi All,

I have connected BI to my outlook and every day it's now uploading my data files from a specific folder in Outlook.

The filename itself and the data within this file have no date. I would like BI with every daily update to add a column with the date from the new upload, so every daily upload has his own date in Power BI. Does anyone know if this is possible? Please let me know if you have any questions or you need some more clarification.

Thanks,

Paul 

[Anonymous]

I just learned that I can add a Timestamp during importing the data fil, can anyone tell me how?

[v-lili6-msft]

hi, @Anonymous 

You could refer this two blog:

https://www.kasperonbi.com/show-the-refresh-datetime-in-a-power-bi-report-and-dashboard/

https://www.excelguru.ca/blog/2016/06/08/display-last-refreshed-date-in-power-bi/

Best Regards,

Lin

[Anonymous]

Thanks, but this is not adding a time stamp to my data set, it just shows when the data last has been refreshed

[v-lili6-msft · Accepted solution]

hi, @Anonymous 

If you want to add current date column when refreshing (during importing the data file), It is Infeasible in power bi for now.

Regards,

Lin