Extracting Contents of CSV Attached to PDF

[StephenK]

Hey all,

Not sure if there is any good solution to this, but we receive some monthly reports via PDF attachment in an email. Apparently, you can also attach files within PDF's themselves, so inside these PDF's there are .csv files attached. You can access these by clicking on a paperclip icon within the PDF document. Note that the csv files are not external URL's, the files are attached directly within the PDF.

Does anyone have any thoughts or ideas on accessing attachments within a PDF via power query?

Thanks!

[edhans]

I recommend you ask this in the Power Automate forum. I do not think Power Query can extract files from inside other files without a custom connector. Power Automate though can work with PDF files - see this documentation.

So you'd let Power Automate look for the emails, grab the PDF, then extract the CSV and save it where you wanted it.