Limits and known constraints#
The current, confirmed constraints of Reportworq. Each is a real boundary to design around, not a bug. Items
are grouped by area so you can scan the ones that apply to your task.
Sources and worksheets#
| Constraint |
Detail |
| Encrypted Excel workbooks are not supported as sources |
A password-encrypted workbook cannot be used as a report source; remove the encryption first. |
.xlsb output is non-deterministic headless |
The binary .xlsb format does not render reproducibly in headless generation; prefer .xlsx for automated runs. |
| Cross-workbook formulas need co-located workbooks |
Cross-workbook references resolve only when the workbooks sit in the same Network-Share provider folder; references across a SharePoint URL do not resolve. |
| Dynamic Path is distribution-only |
A parameter-driven source-file path is available for distribution reports, not for contribution. |
Parameters#
| Constraint |
Detail |
| Parameter sets are cell-based and Text-List only |
Parameter sets apply only to cell-based reports with Text-List parameters, as a finite list of pipe-delimited combinations (for example C5|C6). |
| A parameter-set part-count mismatch is a silent no-op |
If the number of pipe-delimited parts does not match the parameters, the combination is skipped with no error. |
Output and distribution#
| Constraint |
Detail |
| PowerPoint output requires a template |
A run that produces PowerPoint must have a .pptx template attached, or generation fails. |
| One replicating worksheet per PowerPoint slide |
A slide may contain only one replicating worksheet; more than one causes generation to fail (adjacent same-worksheet slides replicate as a group). |
| Additional Files are separate attachments |
The Additional Files list is static and non-parameterizable; its files ship as separate attachments and are never merged into the report PDF. |
| Box is read-only |
The Box provider supports browse and read only; it cannot be used to write output. |
| Teams supports Direct (Graph) only |
Only the Teams Direct (Graph) send path is wired; there is no Teams Bot path. |
Data models and connectors#
| Constraint |
Detail |
| Data models build Excel Reports in the add-in |
A data model is a source for building Excel Reports in the add-in; it is not a live, query-driven report content source. |
| Unmapped model fields are excluded until remapped |
Fields that are not mapped are excluded from output until you remap them; they are not populated by Excel formulas. |
| Filter pushdown is SQL-only |
Only SQL sources push filters down to the database; every non-SQL source filters in memory, which matters for large models. |
| Direct queries default off |
Direct-query mode is off by default; the data model caches unless you enable it. |
| Oracle is EPM Cloud / Smart View |
The Oracle connector is Oracle EPM Cloud / Smart View (REST, Basic auth), not a relational SQL connector. |
| Adomd requires tabular MDX and a Premium capacity |
An Adomd (Power BI / SSAS) source needs a tabular MDX query and a Premium, PPU, or Fabric capacity with XMLA enabled; MFA accounts need a service principal. |
Scheduling#
| Constraint |
Detail |
| Cron is 5-field Cronos |
Schedules use 5-field Cronos expressions; older Quartz ?…? syntax is rejected. |
| Constraint |
Detail |
| HTTPS is mandatory for the add-in and M365 |
The Excel add-in login and all Microsoft 365 features require HTTPS; over HTTP they silently do not work. |
| Ports 8600 and 8601 must be open |
Every server needs both the main port (8600) and the Real-time Event Hub port (8601) open, or cluster eventing breaks. |
| One shared job queue across workspaces |
Instances with multiple workspaces share a single job queue; rows for other workspaces are redacted and cannot be expanded or canceled until you switch to that workspace. |
| The Cloud API needs a workspace selector |
Once more than one workspace exists, a global Cloud API key requires ?workspace=<name> on each call. |
| Deprecated API endpoints return 404 |
The info and history API endpoints are deprecated and return 404; use ping / list / run / status / cancel. |
| Constraint |
Detail |
| The in-app assistant is not available in this build |
The in-app assistant ships switched off and cannot be turned on from an admin setting; report-level AI features are the supported surface. |
AI* Excel functions are not generative |
The AI* function family is the Workday Adaptive connector; only RWAIINSIGHT is generative. |
