Power BI Connector for Email

Build 21.0.7930

Miscellaneous

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


PropertyDescription
DirectQueryLimitLimits the number of rows when using the DirectQuery mode. This helps avoid performance issues at design time.
EmailServiceOptimizes the IMAP connection for the service you are working with.
EnableForeignKeyDetectionWhether to detect the foreign keys in ODBC.
IncludeMessageWhether to include message body content and attachment data or not.
IsHTMLDetermines whether to return the MesssageBody as HTML or plain-text.
KeepAliveDetermines whether to keep the connection alive across instances.
ListMailboxesWhether to list all mailboxes or just the subscribed IMAP mailboxes. IMAP Only.
MaximumColumnSizeThe maximum column size.
MaxItemsMaximum number of items to return.
MaxRowsLimits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time.
OtherThese hidden properties are used only in specific use cases.
PseudoColumnsThis property indicates whether or not to include pseudo columns as columns to the table.
ReadonlyYou can use this property to enforce read-only access to IMAP from the provider.
RTKThe runtime key used for licensing.
SupportEnhancedSQLThis property enhances SQL functionality beyond what can be supported through the API directly, by enabling in-memory client-side processing.
TimeoutThe value in seconds until the timeout error is thrown, canceling the operation.
UIDModeIf true, permanent message Ids are used instead of the default temporary Ids.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930