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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Syndicate_Admin
Administrator
Administrator

Extract the file name / data source

Good afternoon, I'm looking for information on how to extract the name of the Excel file so that it appears in a column. I was looking for information on the forum/Google and the only thing I found so far is the "From Folder" function. In this case it is a single file so the option from folder is not viable to me since I could not save another Excel file in that with a different format because it would give error the PBI.

Thank you so much for the help!

Frederick

1 ACCEPTED SOLUTION
ChrisMendoza
Resident Rockstar
Resident Rockstar

@Syndicate_Admin -

No problem. Technically, you can still use 'From Folder' you would just need to filter to the file you're looking trying to load.
From my Desktop Folder:

Transform Data to filter to the file firstTransform Data to filter to the file first

 

 

Filter then click:

image.png

Result after helper queries / transformations:

image.png

 

[Source.Name] contains the file name






Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!



View solution in original post

2 REPLIES 2
ChrisMendoza
Resident Rockstar
Resident Rockstar

@Syndicate_Admin -

No problem. Technically, you can still use 'From Folder' you would just need to filter to the file you're looking trying to load.
From my Desktop Folder:

Transform Data to filter to the file firstTransform Data to filter to the file first

 

 

Filter then click:

image.png

Result after helper queries / transformations:

image.png

 

[Source.Name] contains the file name






Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

Proud to be a Super User!



Thank you very much for the example!!!

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.