Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
This article describes the limits of the files and data structures supported by the Finance Reconciliation agent.
Limits of files and data structures
The following table illustrates the limits for the different scenarios in which the Finance Reconciliation agent operates.
| Scenario | Assistive (Excel add-in) | Autonomous (Copilot Studio agent) |
|---|---|---|
| Maximum number of columns for automatic table key suggestions | 200 | Not applicable |
| Maximum number of rows supported for reconciliation (per sheet) | 1,000,000 | 1,000,000 |
| Maximum number of reference columns supported in the reconciliation report | 20 | 20 |
| Maximum number of mapping key pairs | 30 | 20 |
| Maximum file size | 25 MB | 15 MB per source file |
| Maximum character length in a single cell for partial matching | 32,000 | 32,000 |
Frequently asked questions
Are the limits of Excel based on the maximum number of rows supported by Excel?
No, the limits are based on a combination of the constraints in the previous table.
Are the limits of reconciliation based on the limits of the number of columns in the source data sets?
No, the limits are only measured based upon the columns used as mapping keys.