Power BI Connector for Google Sheets

Build 20.0.7587

Getting Started

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 describes how to install the CData Power BI Connector for Google Sheets.

Creating a Data Source Name (DSN)

Creating the Data Source Name describes the process to authenticate and connect to Google Spreadsheets

Connecting from Power BI

Getting Data shows how to connect to the DSN and build a query to Google Spreadsheets from the Get Data window.

Google Spreadsheets Version Support

The connector leverages the Google Drive API to enable bidirectional access to Google Sheets.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587