Help Keeping Metadata

[Anonymous]

I'm extracting and combining CSV files from a SP list - I've pretty much got it down, but don't know how to keep my meta dates after combining. Please help!

BinaryToCSV = Table.AddColumn(Path, "CSV", each Csv.Document([Content])),
    KeepCtdModDate = Table.SelectColumns(BinaryToCSV,{"CSV", "Date created", "Date modified"}),
    ExpandAll = Table.Combine(KeepCtdModDate[CSV]),
    #"Promoted Headers" = Table.PromoteHeaders(ExpandAll, [PromoteAllScalars=true]),

[mahoneypat]

You can just expand your column of tables, or see this video on how to keep your metadata with the Table.Combine approach you've started with.

The BEST way to combine files in Power BI so you don’t lose columns - YouTube

Pat