SharePoint Document Library
Bring a spreadsheet stored in a SharePoint document library into DataOS
This guide brings a spreadsheet stored in a SharePoint document library (an Excel file, read sheet by sheet and row by row) into DataOS.
microsoft.com
?
What you need
A Microsoft Entra app (client ID and secret), your tenant ID, and your SharePoint address
Who can get it
Your Microsoft 365 administrator
Where data lands
A governed table in your DataOS lakehouse
Connection type
Object storage
How the connection works
?
Source
SharePoint Document Library
DataOS connector
Keeps it up to date
DataOS lakehouse
Governed data product
The connector signs in to Microsoft 365 with your app details, downloads the file you name from your SharePoint site, and refreshes the table in DataOS. It only reads one file.
What's next
Ready to bring this data into DataOS?
