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.
Community SupportHi 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-folder
If 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.0
If 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.
Community SupportHi 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.
- v-kpoloju-msft
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.
- v-kpoloju-msft
Hi danitskofabric,
Just wanted to follow up one last time. If the shared guidance worked for you, that’s wonderful hopefully it also helps others looking for similar answers. If there’s anything else you'd like to explore or clarify, don’t hesitate to reach out.Thank you.