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

Microsoft Excel Version Support

The CData Power BI Connector for Microsoft Excel supports the Office Open XML spreadsheets used by Microsoft Excel 2007 and later.

Microsoft Excel File Extension Support

The CData Power BI Connector for Microsoft Excel currently supports .xlsx and .xlsm files. However, only read operations are supported for .xlsm files. Modifying data operations may cause loss of or damage to macros.

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