Forum Discussion
PDFs from Sharepoint to Fabric
So I have PDFs that are uploaded to Sharepoint and I need to access them inside a Notebook. I cant copy them via Power Automate doing to policys. Any ideas on how to handle this?
Thank you!
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.
12 Replies
Hi 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.
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.
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.
Hi danitskofabric,
Just checking in to see if the issue has been resolved on your end. If the earlier suggestions helped, that’s great to hear! And if you’re still facing challenges, feel free to share more details happy to assist further.Thank you.
Hi danitskofabric,
Hope you had a chance to try out the solution shared earlier. Let us know if anything needs further clarification or if there's an update from your side always here to help.Thank you.
Use graph apis in Fabric notebook and save the PDFs to lakehouse files section using Python file writing methods. Make sure to mount the desired lakehouse using notebookutils and use the returned mount path for Python file write methods. Works like a charm.
