The CData Power BI Connector for Microsoft Excel Online 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 Microsoft Excel Online.

Microsoft Excel Online Version Support

The connector supports connecting to Excel Services via SharePoint Online, which is supported by the Microsoft Graph API. It models spreadsheets and ranges as bidirectional tables.

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