Power BI Connector for Google Drive

Build 20.0.7654


Create, update, delete, and query permissions for resources in a user's Google Drive.


The ResourceId field must be specified to get data from this table. This is the only supported filter.

SELECT * FROM Permissions WHERE ResourceId = '0B5AH3NIqjXDKX3pJS3NncTZJa01'


To insert into Permissions, you must specify values at least for the ResourceId, Role, Type, and EmailAddress fields.

INSERT INTO Permissions (ResourceId, Role, Type, EmailAddress) VALUES ('0B5AH3NIqjXDKX3pJS3NncTZJa01', 'WRITER', 'USER', 'support@cdata.com')


The PermissionId and ResourceId fields are required for updating a Permission.

UPDATE Permissions SET Role= 'organizer' where PermissionId ='3NIqjXDK' AND ResourceId= '0B5AH3NIqjXDKX3pJS3NncTZJa01'


To delete a Permission, the PermissionId and ResourceId fields are required.

Delete From Permissions WHERE PermissionId ='3NIqjXDK' AND ResourceId= '0B5AH3NIqjXDKX3pJS3NncTZJa01'


Name Type ReadOnly Description
PermissionId [KEY] String True

The Id of the permission for the resource.

ResourceId [KEY] String True

The Id of the resource (a file or folder).

Role String False

The role specified for the permission.

Type String False

The type entity to which the permission applies. It can take only these values: 'USER', 'GROUP', 'DOMAIN', 'ANYONE'.

EmailAddress String False

The email address of the user or group to which this permission refers.

Domain String False

The domain to which this permission refers.

AllowFileDiscovery Boolean False

Whether the permission allows the file or folder to be discovered through search. This is only applicable for permissions of type 'DOMAIN' or 'ANYONE'. The default value for this field is 'false'

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