New JSON theme available! Check it out here!
How can we help?

Welcome to Curbal Learning Portal. Search for answers using the search box below,
or create a request for a video or blog if you cannot find your answer.

Popular searches: DAX Glossary | Guided courses | Request a video

Print

Import tables or pages based on a word or phrase from a pdf in Power Query

Are you working with pdf’s or tables and need to import only data where a specific word or phrase is found? Then thanks to Imke, I have the perfect trick for you.

Table of contents:

00:00 Intro and explain use case
01:10 Import the document from folder
02:30 Apply Imke’s function
03:30 Filter by more than one word

Watch the tutorial:

Import tables or pages based on a word or phrase from a pdf in Power Query

Links to the mentioned resources

Link to Imke’s post: https://www.thebiccountant.com/2019/0…

Was this helpful?
Previous Keep most recent record on a table with Power Query | Improved solution – Part 2
Next Filter your Power Query columns by ANY CONDITION!

Reader Interactions

Let us know your thoughts...

Table of Contents