The CData Power BI Connector for Google Sheets 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 Google Sheets.

Google Sheets Version Support

The connector leverages two APIs: the Google Sheets API v4 for reading and writing spreadsheet cell data, and the Google Drive API v3 for file-level operations such as listing, uploading, downloading, and deleting files, moving files to the trash, and managing sharing and visibility.

For an introduction to Visualizing Data using the CData Power BI Connector for Google Sheets.