push file datasource info to binary content

[jagostinhoCT]

Is there a way that I can push the creation date of a file I am using as a datasource to show as a column after I combine the file's binary data?

Thanks

J

[v-yulgu-msft · Accepted solution]

Hi @jagostinhoCT,

Please try the solution mentioned in below link to see whether it works in your scenario.

Create a date custom column by file date

Best regards,

Yuliana Gu

[parry2k]

IN edit queries under Transform thers is option calld "Fill" which can be used to fill down or up.

[jagostinhoCT]

Thanks @parry2k.

I could not find how to do it the way you mentioned. I found a workaround, however.

1. Combine the Binaries column
2. PBI will add new query steps automatically
3. Delete all steps after the Invoke Custom Function one. But keep this one.
4. There will now be a new column available, at the end of the datasource table, called “transform file from [DataSourceName][FileName]”
5. Click the button to expand it and you will have both file metadata and combined binaries as different columns

Not entirely sure on the caveats for this but it seems to work. Any thoughts?

Joaquim

[jagostinhoCT]

hmmm...

I am getting an error....

I understand it might be due to the workaround described above.

You reckon it is fixable?

let
Source = AuditsLog,
#"Added Index" = Table.AddIndexColumn(Source, "Row Number" ,1),
#"Kept Errors" = Table.SelectRowsWithErrors(#"Added Index", {"Name", "Extension", "Date accessed", "Date modified", "Date created", "Folder Path", "RevitVersion", "SourceFilePath", "SourceFileName", "DetailLineCount", "FilledRegionCount", "MaskingRegionCount", "TextNoteCount", "SelectedElementCount", "SheetCount", "PurgeableGroupTypeCount", "FileLength", "ElementCount", "JobFolderName", "LiveFiles", "RecordFiles"}),
#"Reordered Columns" = Table.ReorderColumns(#"Kept Errors", {"Row Number", "Name", "Extension", "Date accessed", "Date modified", "Date created", "Folder Path", "RevitVersion", "SourceFilePath", "SourceFileName", "DetailLineCount", "FilledRegionCount", "MaskingRegionCount", "TextNoteCount", "SelectedElementCount", "SheetCount", "PurgeableGroupTypeCount", "FileLength", "ElementCount", "JobFolderName", "LiveFiles", "RecordFiles"})
in
#"Reordered Columns"