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