Excel file name in excel data column

Help
, , , , ,
1

Hi People,

Please share that how I can do the brlow task.

  1. I have 300 excels in a folder
  2. I have appended the data through power query.

Is their any way I can add excel files name as a new column in individual excels from the folder