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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
TH_2342
New Member

Extracting tables from multiple PDFs

Hello,

 

I am trying to extract the same table from multiple PDFs within Power BI. These PDF's are stored in a SharePoint Folder, and whilst the tables are in the same format in each PDF, they are not on the same page or table number. 

 

I have been able to connect Power BI to the appropriate SP folder and load in the PDF files I need, but I'm strugglign to figure out a way to automatically extract the relevant tables (other than going through each file and filtering through manually). 

 

Is there a way I can extract specific tables based on certain criteria within the tables, i.e. every data table I want to extract has the first column titled 'example'. 

 

Thank you in advance for any help. 

3 REPLIES 3
christinepayton
Super User
Super User

You might want to look into Power Automate Desktop. It will let you run actions with regular expressions on PDFs and extract tables to Excel. The regular expressions are what you use for things like "get this thing wherever you see the word xyz or where the text fits this pattern". 

 

It's usually used for files on your PC, but you could probably sync the library from SharePoint or something to run it local (make sure to check in settings and tell it to pull it all down vs storing in cloud). 

Hey Christine, 

 

Thanks for the advice, sounds like a great idea. Something new to learn too!! 

Sure! There's all kinds of AI solutions in the cloud too with AI Builder/Syntex, PAD is kind of the budget option. I only mention it because it's got a low barrier to entry because there's no need to request a license for it - usually it's already installed with Windows. 

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors