Retain file name in a column when using Sharepoint Folder and Excel sheet as a data source

[MGinGermany]

Hello,

Thank you in advance for taking the time to help me with the problem:

I have a subfolder in a company run Sharepoint sitethat will be updated with excel files on a regular basis. The date of the report is only contained within the file name, thus this must be included in the extracted binary. (2019-09-04_filename.xls)

I have followed the solution listed here: https://community.powerbi.com/t5/Desktop/Retain-file-name-column-when-using-Folder-as-a-data-source-... 

Unforutnately this does not seem to work with the sharepoint folder and Excel file combination (unless I am editing the code improperly?). Can someone help me understand what I am doing incorrectly? Please let me know what additional information you may require!

Thank you!

Michael

[MFelix]

Hi @MGinGermany ,

What connection are you using has the source the Sharepoint Folder or the web link?

On my experience working with sharepoint folders I was abble to save the file name by making a function to make the treatment of one file and then aplying that function to a folder of sharepoint, since the input for the function comes from the sharepoint folder data it has location, name , size and so on I just keep the file name and the columns I need after the function runs.

Regards,

MFelix

[Anonymous]

@MFelix , thx for the help, I forgot to check the Removed Other Columns applied step... 🙂