Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
RanbirSB
New Member

Date created of Excel file in Data set

Hi

Hoping someone can assist?

I want to add the "Date Created" in my data set. This is the date the file was added to the Sharepoint folder so can track when the data was from, as to the below screen shot.

RanbirSB_2-1736778319990.png

However, once I have cleaned up the data, I am unable to pull this data through as its not part of the data set. I have tried to pull it though the Metadata but still is not an option.

RanbirSB_1-1736778230146.png

Does anyone know how I can apply the Datee createed of the file in my data set please?

Thanks

1 ACCEPTED SOLUTION
SamWiseOwl
Super User
Super User

Hi @RanbirSB 

 

Go to the step Removed Other Columns 1 and click on the cog.

Then tick the column you want to keep.

SamWiseOwl_0-1736780781790.png

 


If you are happy with this answer please mark as a solution for others to find !

Kudos are always appreciated! Check out our free Power BI video courses.

View solution in original post

2 REPLIES 2
RanbirSB
New Member

Thank you so much. This has resolved the issue.

SamWiseOwl
Super User
Super User

Hi @RanbirSB 

 

Go to the step Removed Other Columns 1 and click on the cog.

Then tick the column you want to keep.

SamWiseOwl_0-1736780781790.png

 


If you are happy with this answer please mark as a solution for others to find !

Kudos are always appreciated! Check out our free Power BI video courses.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.