Power BI Connector for Google Sheets

Build 20.0.7587

Using Spreadsheets as Tables

Spreadsheets as Tables

The connector models spreadsheets and ranges as relational tables.


Tables shows various configuration options to reflect your spreadsheets' organization in the tables; for example, you will find guides for working with headers and querying ranges as tables.

Columns provides more information on column discovery.

Stored Procedures

In addition to working with the data in the spreadsheet, you can use the available stored procedures to access functionality in the Google Spreadsheets API that is not modeled as SELECT, INSERT, UPDATE, or DELETE statements.

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