How can i read Share point excel files in azure databricks notebook?

Question

Handling sharepoint files in databricks notebook to perform some transformations.

Answer 1

Hello @Naveen Suvvada ,

Welcome to the Microsoft Q&A platform.

Unfortunately, you cannot read Share point excel files in Azure Databricks.

Reason: Share point is not supported source in Azure Databricks.

For more details, refer to Azure Databricks - Data sources.

Are there any alternatives?

Yes, there are couples of alternatives to read share point excels files in Azure Databricks.

Option1: Copy excels files to Azure Storage and then mount the storage account to Azure Databricks and read from storage account.

You may checkout the SO thread addressing: Reading Excel file from Azure Databricks.

Option2: I found a third party articles which explains - Process & Analyze SharePoint Data in Azure Databricks.

Disclaimer: This response contains a reference to a third-party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any

Hope this helps. Do let us know if you any further queries.

---------------------------------------------------------------------------

Please "Accept the answer" if the information helped you. This will help us and others in the community as well.