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. |
| The view designer follows many-to-one links only | On the Design canvas, a related table is added as a LEFT JOIN from a column that holds another table's key, so a view keeps one row per starting-table row. One-to-many joins, inner joins, and multi-column keys need a SQL-only view. |
| View designer size limits | A path of related tables is at most 4 tables deep, and a view joins at most 20 tables. A table already on the path cannot be added again. |
| Edit as SQL is one way | A designed view converted with Edit as SQL stays a SQL-only view; the designer does not read SQL back. |
| SQL Server, OLE DB, and ODBC sources supply no relationships | The view designer offers the foreign keys a SQLite database declares, the ones a CData-based source reports, and the ones Reportworq infers for QuickBooks Online report views. SQL Server, OLE DB, and ODBC sources supply none yet, so add manual relationships on the data model. |
| 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. |
Platform and automation#
| 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. |
AI#
| 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. |
Feedback on this page
Comments, questions, requests, or something missing or unclear? Email us - the page you are on is filled in for you.
Email feedback on this pageOr write to support@reportworq.com directly.