Power BI Connector for Google Drive

Build 20.0.7654

Sheets

Query the Google Sheets contained in a user's Google Drive.

Select

It is also possible to get all the sheets from a Team Drive.
Note: You must set the connection property TeamDriveSupport to 'true', in order to query from a specific Team Drive.

SELECT * FROM Sheets WHERE TeamDriveId='0ACkq0ZiV0yJCUk9PVA'

Columns

Name Type Description
Id [KEY] String The ID of the file.
Name String The name of the file. This is not necessarily unique within a folder. Note that for immutable items such as the top level folders of Team Drives, My Drive root folder, and Application Data folder the name is constant.
TeamDriveId String The Id of the teamDrive.
Description String A short description of the file or folder.
Extension String The extension of the file.
CreatedTime Datetime The creation date of the file or folder.
ModifiedTime Datetime The last modified date of the file or folder.
Size Long The size of the file in bytes.
OwnerName String The name of the resource's owner.
OwnerEmail String The email of the resource's owner.
Starred Boolean This field sets whether or not the resource is starred.
Trashed Boolean This field sets whether or not the resource has been moved to the trash.
Viewed Boolean This field sets whether or not the resource has been viewed by the current user.
ParentIds String A comma-separated list of parent folder Ids.
ChildIds String A semicolon-separated list of child resource Ids.
ChildLinks String A semicolon-separated list of child resource links.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
Query String This field accepts a valid Google Drive SDK query, which overrides conditionals in the WHERE clause.

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