In this video, we’re going to look at how we can extract data from PDF files with Power Query in Power BI.
We can then copy and paste the data into Excel. 👇
Check out my full courses and ebooks here
👉
DOWNLOAD the example workbook here
📖
SUBSCRIBE & get my 3 FREE eBooks
📧
CONNECT with me on social
Facebook:
Twitter:
LinkedIn:
Thanks for all your support!…(read more)
Convert Word 2 PDF: Word to PDF Converter
Convert PowerPoint 2 PDF: PPT to PDF Converter
Convert Excel 2 PDF: Excel to PDF Converter
Convert an Image 2 PDF: Image to PDF Converter
Convert HTML 2 PDF: HTML to PDF Converter
More Tools: PDF Converter
Very clear video and straight to the point. One question: is there any way to automatically open pdf files that are created on a monthly basis (provided they have the same format and table names, and perhaps they are located on the same page numbers) without having to go and open/link them one by one?
is there a way to import the data from a pdf that is password protected? (I have the password)
I'm having issues invoking custom functions in Power BI to combine multiple tables across multiple reports. For example, I get a weekly call report via PDF. I've written power query to extract Table001 from each PDF and format accordingly. Last week a larger PDF came across and the data encompassed 2 tables (Table001 & Table002) or 2 pages. The invoke custom format function will only pull data from Table001. Therefore, it's not pulling additional data from Table002 that I also need. Any idea on how to fix this? I've tried for hours and can't get anywhere….Thanks!!
I'm looking for a free tool of some sort, that can simply unwrap and list all the files contained in a normal unencrypted PDF. The reason being I found a PDF (a less than 200 pages book with very few pics) that's more than 250MB's. There's definitely something else going on than just bad compression or formatting. I would like to just see a simple list of all the different files, fonts and whatever the PDF contains. Every single item, not just text or pics that has a lot of free apps and can also be done in Acrobat Reader.
Nice.. did not know PBID could do this. Thumbs up!
I love Power Query…Thank you.
Power query is magical. ..thanks for the video