Power BI Connector for Microsoft Excel Online

Build 24.0.9060

Connection

This section provides a complete list of the Connection properties you can configure in the connection settings for this provider.


PropertyDescription
DefineTablesAssign table names to ranges.
WorkbookThe name or Id of the workbook.
DriveThe Id of the drive.
IncludeSharePointSitesWhether to retrieve drives for all SharePoint sites when querying Drives view. If 'true' the provider will retrieve all Site IDs recursively and for each of them issue a separate call to get their drives. Therefore, be aware that setting this property to 'true' may decrease performance for the Drives view. Note that the SharePointAccessToken or OAuthJWTCert connection property must be specified to query the SharePointSites view and other views if IncludeSharePointSites is set to 'true' when using the CLIENT OAuthGrantType or the AzureServicePrincipal AuthScheme.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060