How to get excel workbook name and sheet name

[Anonymous]

Hi all,

I have to build a table from several excel workbooks . Each of them have several sheets. The name of the workbook contanis the date of the evnts and the name of the sheet contanis the name of the company. 

I should want to extract these two fieds and store them in each line of my table. I suppose this has to be done during the "get data" process. But I have no idea of how to program that.

Thank you for your help.

Regards

[v-lionel-msft · Accepted solution]

Hi @Anonymous ,

You can try to get data from "Folder":

[Source.Name] column is file name; [Name]column is sheet name.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

Refer : https://community.powerbi.com/t5/Desktop/Add-custom-column-with-sheet-name/m-p/877507

https://community.powerbi.com/t5/Desktop/Add-a-column-with-the-sheet-name/m-p/537333