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