The CData Power BI Connector for Microsoft SharePoint Excel is built on top of an ODBC driver. This section discusses how to install the connector, create a DSN, and connect from Power BI.

Installing the Connector

Installing the Connector is a step-by-step guide for how to manage the installation process.

Creating a Data Source Name (DSN)

Creating the Data Source Name describes the process to authenticate and connect to Excel Services.

Excel Services Version Support

The connector supports retrieving Excel data from SharePoint On-Premises through the REST API and through the OData API introduced in SharePoint 2013. Excel files must have the .xlsx format used in Excel 2007 and later.

Note: Microsoft has stated that they plan to sunset the Excel Services API for SharePoint Online in February 2022. Please consider migrating to the CData connector for Excel Online for future access to your SharePoint data.

For an introduction to Visualizing Data using the CData Power BI Connector for Microsoft SharePoint Excel.