Forum Discussion
PDFs from Sharepoint to Fabric
Hi danitskofabric,
Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to tayloramy, for those inputs on this issue.
I understand the challenge, you have got PDFs sitting in SharePoint that you would like to work with directly inside a Fabric Notebook, but Power Automate isn’t an option due to policy restrictions.
Use the SharePoint/OneDrive connector in Fabric to pull the PDFs into your Lakehouse. Once they’re there, you can process them in your Notebook with Python libraries like PyPDF2 or pymupdf.
https://learn.microsoft.com/en-us/fabric/data-factory/connector-sharepoint-folder-overview
https://learn.microsoft.com/en-us/fabric/data-factory/connector-sharepoint-online-list
https://learn.microsoft.com/en-us/fabric/data-factory/connector-sharepoint-folderIf your org allows API access, you can use the Microsoft Graph API inside your Notebook to read the files directly from SharePoint. Here’s a starting point:
https://learn.microsoft.com/en-us/graph/api/resources/onedrive?view=graph-rest-1.0If this is a one-off, you can also manually upload the PDFs into your Lakehouse and process them from there.
Hope this clears it up. Let us know if you have any doubts regarding this. We will be happy to help.
Thank you for using the Microsoft Fabric Community Forum.
Super UserHi danitskofabric,
Are you able to copy them into a Lakehouse using a Pipeline?
If you found this useful, consider giving Kudos. If I solved your problem, mark this post as the solution.
Hi tayloramy,
As I saw that only supports Sharepoint-Online-Lists, but I need to copy Files that are inside Sharepoint-Online Folders.
- tayloramy
Hi danitskofabric,
When you select a SharePoint Online List connection in the Pipeline, you are able to select a connection type of SharePoint Online File. This is currently in preview.If you found this useful, consider giving Kudos. If I solved your problem, mark this post as the solution.
Thank you, I didn't saw that! I now created a Service Principal and gave it access to the Sharepoint Site. If I test the connection for Sharepoint Online List it works, but if i choose Sharepoint Online File and test the connection it doesn't. Does the SP needs more Permission?
- tayloramy
Hi danitskofabric,
How was the service principle granted access to the site?
I've noticed some workloads in Fabric require permissions to be granted the legacy way on the site itself, not in Azure. This needs ot be done through the https://[your_site_url]/_layouts/15/appinv.aspx page on your site.
If you found this useful, consider giving Kudos. If I solved your problem or answered your question, mark this post as the solution.