How to show sharepoint creation date for files in power bi?

[Anonymous]

I have 4 files in a folder. Not when i am combining those files and expanding them, date creation column is not coming up?

in simple words, how to show file creation date in power bi as column? 

[itskool]

In the meantime, I think, I have found a way around the problem:

When you combine Sharepoint files, Power BI automatically created "Removed Other Columns" step, which makes it only leave the Source Name. If you add "Date created" there, it's going to leave it too.

It is fast and also works if you have file with identical names (say, in different folders).

[IoannisT]

You are a legend! 

[Shubhabrata]

This is a much better solution. Simple and fast

[v-qiuyu-msft · Accepted solution]

Hi @Anonymous, 

In Power BI desktop Query Editor, after we retrieve files in SharePoint online folder, the [Date created] column displays as before before using Combine Files feature. 

After we use Combine Files feature, the table shows like below: 

To add a column returns [Date created] column values for each file, we can do it like below: 

Best Regards,
Qiuyun Yu 

[itskool]

Thanks for the solution!

Although, when I tried it, it made things really slow, subsequent grouping that I needed to perform took several hours...

Is there a way to aviod that? My data is not that big, just about 80 files....