Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
andersthyme
New Member

Table based on header from multiple PDFs in a folder

Dear all,

 

I am new to this forum, and therefore apologize in advance if I am missing anything, but I really hope you can assist.

 

I have a folder with PDF files all containing multiple tables. For each file there is a table with header "event assessment". It will not be the same table number each time, why I need to to look for the header instead of just "TABLE009" etc.

 

Also each file-name contains the item number. 

 

What I need is for my PowerBI to read all the PDFs, open the table for each of these with header "event assessment" and add a column with the file name (i.e. item number).

 

Is this possible?

 

Thanks in advance!

 

Kr Anders

1 ACCEPTED SOLUTION
Daryl-Lynch-Bzy
Resident Rockstar
Resident Rockstar

Hi @andersthyme - I am going to say maybe, but it is very difficult to trouble-shoot in this forum. 

To understand the problem, you need to import the PDF files manually to understand the difference between each PDF from in the Advanced Editor screen.  Eventually, if you are lucky, a pattern will appear.  This pattern can be turned into a Power Query function.  The function will open the PDF file, then try to do the conversion.  If the first approach (e.g. find table named "X") fails, it tries the second (e.g. find table with field name "abc"), and so on until if reports the PDF as an error.

View solution in original post

3 REPLIES 3
andersthyme
New Member

Thanks Daryl and KNP. I'll give the approach you describe a go (i.e. import one by one and examine the advanced editor screen); it will be quite difficult to recreate these PDF's which at the moment are confidential/contains sensitive data. Thanks for taking your time to assist!

KNP
Super User
Super User

If possible, please provide a link to one of the PDF's, if data is sensitive then you could recreate a sample PDF or two for us to work with. As @Daryl-Lynch-Bzy said, it is difficult to solve this without something to work with.

 

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).
chrome-9xf-Zagzel-B

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.
KIfp67uy-Sr
Proud to be a Super User!PBI-Super-User-Rank-30x30-1x
Daryl-Lynch-Bzy
Resident Rockstar
Resident Rockstar

Hi @andersthyme - I am going to say maybe, but it is very difficult to trouble-shoot in this forum. 

To understand the problem, you need to import the PDF files manually to understand the difference between each PDF from in the Advanced Editor screen.  Eventually, if you are lucky, a pattern will appear.  This pattern can be turned into a Power Query function.  The function will open the PDF file, then try to do the conversion.  If the first approach (e.g. find table named "X") fails, it tries the second (e.g. find table with field name "abc"), and so on until if reports the PDF as an error.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.