Saving and publishing is where a useful query becomes an organizational asset. Treat this stage with the same care as query design. The toolbar is central to saving and publishing.
From left to right, the toolbar provides: new report, open existing report, save report, interactive run, create JSON link, settings, edit the report name, export report JSON, import report JSON, delete report, build and run report, and Enable AI for Report Copilot.
Save Workflow
- Name the report.
- Select output format and settings, for example Excel, CSV, text, or JSON. For Excel output, confirm each column's display format in the results grid (see Formatting Output Columns) and confirm that every parameter has a label and, where needed, a default (see Report Parameters and Default Values).
- Save for personal use (unpublished) while validating. Run in the editor to confirm results, then publish when ready for the Report List.
Publish Workflow
Publish only after validation so the report appears in Report List for authorized users with stable, documented behavior. After publishing, users run the report from the standard report list with the same execution context and limits used in normal operation. To publish, select Settings, then change Unpublished to Published.
JSON Export and Import
To move a report to another system or environment, such as dev to prod or one tenant to another, use Export JSON from the toolbar to download the report definition as a JSON file. On the target system, use Import JSON to load that definition.
The JSON contains the report’s SQL, parameters, and settings so it can be run and maintained on the new system. Expect minor differences across environments, such as permissions, data, or scheduling. Re-validate after import before broad release.
