Missing Data Rows when Importing pdf from folder

[Anonymous]

Hi,

I have several pdf files stored in the folder. When I connect to the folder, PowerQuery miss some rows which are inside one of pdfs when loading the data.

I tried to import data striclty from this one pdf file, so I connect to pdf instead of folder. PowerQuery in Navigator has showed Table001 Table002 Table003 and Page001.

Page001 is what I need, however I cannot select it when I'm trying to connect to the folder. It takes Table001 by default. 

Is there any option to pick Page001 from this pdf instead of Table001 when I'm connected to the folder?

Any help much appreciated

[v-eqin-msft · Accepted solution]

Hi @Anonymous ,

Based on my test, when you click Combine & Transform , you could choose Page type .

The rest pdf files will be in the same format as well.

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[smpa01]

@Anonymous give pdftools a try through R.