Use the CData ODBC Driver for Azure Data Lake Storage from SharePoint Excel Services
This article demonstrates how to use the CData ODBC Driver for Azure Data Lake Storage to connect to Azure Data Lake Storage from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Azure Data Lake Storage in Excel.