Hello. We are using Azure Databricks and would like to ingest data from a specific M365 SharePoint Online Site/List. I was originally trying to use this recommendation, https://learn.microsoft.com/en-us/answers/questions/2116616/service-principal-access-to-sharepoint-o... however; get errors on the last step using a Service Principal which was the original recommendation. I am reaching out here as I'm looking for a better way to ingest/pull in the Data from SharePoint into Databricks.
Has anyone does this successfully? What method did you use?
Any assistance is appreciated.
Thanks in advance.
