Power Query - Extract PDF Tables by the Table's Content

[@kkravch]

Great job! Clear explanation with attention to details that matter. Professor!

[@bcti-bcti]

Thank you!!!!

[@ronaldagee7417]

Just when I thought I had it all figured out, you showed me an easier way. Thank you for the Power Query videos; they have saved me a significant amount of time.

[@bcti-bcti]

So glad to hear that the video improved your workflow. Thanks for watching.

[@IvanCortinas_ES]

As always, clarity and complete control of the situation. Extremely pro. I love these types of examples and your way of telling them, always to the point. Thanks, Bryon!

[@bcti-bcti]

Wow, Ivan! Such nice compliments. I'll try to keep up the work. Cheers.

[@jazzista1967]

Great study case. I just had the same issue yesterday when i was building a data model that had the same error when trying to refresh my changes in PQ . You pointed me in the right direction. Thanks for posting

[@bcti-bcti]

Perfect timing!!! Glad it helped. Thanks for watching.

[@jazzista1967]

@@bcti-bcti Yes Indeed. And it was exactly a prior step that i applied ( Covert dates from text to real dates) like you showed in the video. Thanks again! Man, you content is gold

[@robbe58]

As always, a tutorial at the top of the bill. Magnificent work, dedication, and explanation. 💯 👍

[@bcti-bcti]

Thank you so much. I'm glad I was able to meet your high expectations. 😁

[@chrism9037]

Great video, thanks for explaining this so well!

[@bcti-bcti]

Thank you. As always, your support does not go unnoticed.

[@kebincui]

Brilliant as always 👍

[@bcti-bcti]

Thank you!!!! That's very nice of you to say.

[@tonybatty504]

Lots of interesting and useful elements. Thanks

[@bcti-bcti]

Glad you found it useful. Thanks for watching.

[@sujanmdsiful]

Awesome 😂. I am proud of you brother

[@bcti-bcti]

Thank you! That means a lot to me.

[@sharmarudra]

Awesome Video.

[@bcti-bcti]

Thank you. You support is greatly appreciated.

[@anpham7108]

The way you teach is SUPER as always, thank you. I have a question in mind, how do you deal with tables that span across pages?

[@bcti-bcti]

THAT is a fantastic question. I hadn't though about that. I will do some testing and let you know. Cheers.

[@ahmedshalaby9343]

i have a problem in an append query , I append folder contain many sheets inside the sheets there are different format like mm-dd-yy or dd-mm-yy what do you suggest ?

[@bcti-bcti]

My guess is that you will have to find something on each sheet that indicates the country of origin to determine the correct date format. You can't really use the dates because January 2nd (01/02/2025) could be validly read as February 1st. Can you send a sample file so I can perform a more in-depth analysis? ([e-mail])

[@ahmedshalaby9343]

@@bcti-bcti thanks for your quick reply