Forum Discussion

diego_martinezn's avatar
diego_martinezn
Frequent Visitor
4 years ago

PDF loading issues with power query

I've posted this question before, but it wasn't explained properly from de beginning and I think it's a good idea to start with the right food.  So the situation is that I have a folder with some PD...
Need Help
v-jingzhang's avatar
v-jingzhang
Community Support
4 years ago

Hi diego_martinezn 

 

I'm afraid we are not able to affect How PDF connector works. The tables are detected and extracted by the connector automatically. It uses Pdf.Tables function to do that.

 

While there are some additional optional properties you can modify or add. You can find all of them in above link. For example, currently Implementation property is "1.3". You can try changing it into other valid values to see whether it would work better. 

 

I guess it detects 3 tables in some specific PDFs. Can you open those PDFs to check whether they display the column "Gross Margin B. Activity" completely? Is it possible that in some PDFs, the column is missing and the table is split into two tables? 

 

Or if you expand Page002 instead of Table002/Table003, can you see the column "Gross Margin B. Activity" in this page?

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

diego_martinezn's avatar
diego_martinezn
Frequent Visitor
4 years ago

Hi v-jingzhang, thanks very much for replying.

Your answer was very useful, I'll try changing the implementation to see if it changes something.

On the other hand, I've tried to work with the pages but it's a complete mess, every page has a different number of columns and it's very difficult to automate that. But you gave me an idea, I'll try it.

Thanks!