Need to keep File Name and date modified

[wilster98]

I create a report weekly. I use Power Query to get the data from a number of new Excel files (Dimension reports). Each file has a number of records. When I load to the spreadsheet, I lose the file name and modified date. I can't really create a one to many relationship (I think?) because it is new data every week.

Is there a way to keep the identifying information with the data?

Thanks
Willy

 

[sandy666]

maybe select Content, Name and Date modified then remove other columns and then expand Content

 

[wilster98]

maybe select Content, Name and Date modified then remove other columns and then expand Content

Good idea, thanks. But it didn't work

 

[sandy666]

what does that mean

it didn't work

any error, improper result or... ?

 

[wilster98]

what does that mean

any error, improper result or... ?

No change. I get the data but not the file name or date.

 

[sandy666]

after expand go to the Applied Steps and remove this step (after Invoke step)

and then remove Content column