Power query loading PDF files wrong

[diego_martinezn]

Good morning. 

I'm working with power query for power by to do a dashboard. I get my data from a folder where all the PDFs are located. 

All the files have the same structure (2 pages with the same number of columns). However, when I upload the files I get different results. For example, from one file power query recognize 2 tables with all the data correct, but for another one, it recognizes 3 tables where there is missing data. 

Why is this happening and how can I fix it? 

Thanks

[amitchandak]

@diego_martinezn , please open and check advance editor power query, what is the main difference. or share the code to check

[diego_martinezn]

Here are some photos of what I meant, there is no code at all (yet).

Here we can see how, after loading the pdf, it detects 2 pages and 2 tables. 

Here, loading other PDF (with the exact same structure) it detects 3 tables and there is a missing column.

It should always load 2 tables as the PDF are the same tables but with different data, but I don't understand why it isn't working. The main problem is the missing column by the way, if I could solve that problem it would be fine.