The maximum file size (in MB) of workbook files included when scanning for worksheets to model as tables.

Data Type

int

Default Value

-1

Remarks

When this connection property is set to a positive integer value, only worksheets originating from workbooks below the specified file size (in megabytes) are modeled as tables.

This can avoid 504 Gateway Timeout errors when working with large Excel files that take too long for the Microsoft Graph API to process.

Note: This connection property has no effect if you are connecting to a single workbook, such as by setting the WorkbookId connection property to a single workbook ID.

If this connection property is not set or is set to -1, no workbooks are excluded on the basis of their file size.