Excel Add-In for Azure Active Directory

Build 25.0.9539

Miscellaneous

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


PropertyDescription
DefaultGroupsDetermines whether to use the /me/memberOf or /groups endpoint for user authentication.
DefaultUserDetermines whether to use the /me or /users endpoint for user authentication.
ExtensionPropertiesAppIdThe ID of the Application that you want to get extension properties for. For all applications, set the value of this property to '*'.
GroupIdSpecify a default GroupId.
MaxRowsSpecifies the maximum number of rows returned for queries that do not include either aggregation or GROUP BY.
MaxSelectLengthThis property limits the number of characters allowed in the $select query option. If the length of the generated $select parameter exceeds the values specified, the column selection is instead processed client-side. Setting this property to 0 prevents the provider from submitting the $select parameter to the service, which is useful for services that do not support it. The default is -1.
OtherSpecifies advanced connection properties for specialized scenarios. Use this property only under the guidance of our Support team to address specific issues.
ReadonlyToggles read-only access to Azure Active Directory from the provider.
TimeoutSpecifies the maximum time, in seconds, that the provider waits for a server response before throwing a timeout error.
UserDefinedViewsSpecifies a filepath to a JSON configuration file that defines custom views. The provider automatically detects and uses the views specified in this file.
UserIdSpecify a default UserId.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 25.0.9539