Forum Discussion

diego_martinezn's avatar
diego_martinezn
Frequent Visitor
4 years ago

Power query loading PDF files wrong

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

Need Help

2 Replies

    • diego_martinezn's avatar
      diego_martinezn
      Frequent Visitor
      4 years ago

      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.