Extract JPG and PDF metadata

[Thesaurus]

Dear Forum Members,

is it possible to extract JPG and PDF metadata to use it later in Power BI report? That would be a version number for comparison reasons.

Thank you

[lbendlin · Accepted solution]

Depends on where that information is stored in each file and if it is compressed and/or encrypted.

You can create record libraries to describe the structure of a binary file, then ingest that binary file and "read"  the values according to the defined records.  Much like what you do when reading ZIP files in Power Query.