Extract the file name / data source

[Syndicate_Admin]

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

[ChrisMendoza · Accepted solution]

@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 first

Filter then click:

Result after helper queries / transformations:

[Source.Name] contains the file name

[Syndicate_Admin]

Thank you very much for the example!!!