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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Giulianna
Helper I
Helper I

Data from multiple pdf files on sharepoint

l am trying to create a tool that extracts information from multiple pdf files from a folder on Sharepoint using 

Source = SharePoint.Files(CurrentDirectory),

where my CurrentDirectory is the sharepoint website with the path to the subfolder I want to get my date from, however it shows me this error below:

DataSource.Error: SharePoint: Request failed: The remote server returned an error: (400) Bad Request. (Bad Request)
Details:
DataSourceKind=SharePoint
DataSourcePath=
SPRequestGuid=8fa061a1-d04d-a000-6acb-9cf255b6c7a4
Url=Documents/Labor Calculation Tool/_vti_bin/ListData.svc

 

------------------------------------------------------------

When I try to use Source = SharePoint.Contents(CurrentDirectory) instead with CurrentDirectory being the main folder, not subfolders, I have to use Helper Queries to be able to transform my binary data into table, which I dont want to because I would need to create too many helper queries which makes my tool extramely heavy and slow.

 

Can anyone help me fix the error using either Source = SharePoint.Contents(CurrentDirectory) or Source = SharePoint.Files(CurrentDirectory)

9 REPLIES 9
lbendlin
Super User
Super User

SharePoint.Files requires the Site URL, not the "current directory" .  You need to do the folder navigation in a subsequent step.

Even when I use the site url it does not work either.

Please elaborate what "does not work" means. Do you get an error message?

 

 

 

when asked to specify the Site URL you should only use

 

https://sidel.sharepoint.com/sites/SPMNAMContinuousImprovement

When I use this URL I have to use Helper Queries to be able to transform my binary data into table, which I dont want to because I would need to create too many helper queries which makes my tool extramely heavy and slow. Do you know any  way around it?

No. This is the correct way to do it. You only need a single helper query and you can craft that one yourself.  No need to use the default option offered via the "Combine binaries"  button.

Can you help me crafting it? I am not sure how to create one myself that will convert the binary data to table

would you be able to post two sample PDF files and indicate what you want to extract from it?

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

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

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.