Forum Discussion
Power Query and PDF files
...when the block of information I need runs onto several pages, I end up with multiple worksheets (as PQ is treating each page as a separate query) in Excel when I've loaded it
If you get n queries it's probably because you select multiple Tables/Pages in the Navigator, ex.:
Instead, you should uncheck Select multiple items > Click on the file name (what I squared in green), then at the bottom of the Navigator click Transform Data. You then get a single query with all the Tables/Pages found in the PDF, ex.:
From there Combine & Transform as you expect
Re. issues with column headings missing after the first page
This is +/- expected, this mainly depends on how the PDF is structured. In principal that's manageable...
Difficult to say more without an actual PDF sample. Hope this helps a bit
...when the block of information I need runs onto several pages, I end up with multiple worksheets (as PQ is treating each page as a separate query) in Excel when I've loaded it
If you get n queries it's probably because you select multiple Tables/Pages in the Navigator, ex.:
Instead, you should uncheck Select multiple items > Click on the file name (what I squared in green), then at the bottom of the Navigator click Transform Data. You then get a single query with all the Tables/Pages found in the PDF, ex.:
From there Combine & Transform as you expect
Re. issues with column headings missing after the first page
This is +/- expected, this mainly depends on how the PDF is structured. In principal that's manageable...
Difficult to say more without an actual PDF sample. Hope this helps a bit
Thank you this, I'll try you suggestion - Thanks again.