Miscellaneous
This section provides a complete list of the Miscellaneous properties you can configure in the connection string for this provider.
| Property | Description |
| IncludeNavigationParentColumns | Specifies whether the provider includes non-key parent columns in views generated from navigation properties. |
| Other | Specifies additional hidden properties for specific use cases., to be used only when our Support team advises it, to address specific issues. See Remarks for details. |
| RowScanDepth | The maximum number of rows to scan to look for the columns available in a table. |
| ShowEmptyRows | Specifies whether the provider includes empty rows when reading data from a worksheet. |
| Timeout | Specifies the maximum time, in seconds, that the provider waits for a server response before throwing a timeout error. |
| UserDefinedViews | Specifies a filepath to a JSON configuration file that defines custom views. The provider automatically detects and uses the views specified in this file. |