Once the dashboard is ready, you export the numbers. This tutorial covers the three most requested outputs — CSV (per visual), XLSX (full spreadsheet) and PDF (a snapshot of the dashboard) — and explains what changes in each, including the sample badge and the role of RLS.
Example workspace: Comércio Aurora Ltda (aurora).
What each format carries#
| Format | Scope | Where it runs | Notes |
|---|---|---|---|
| CSV | One visual | In the browser (client) | pt-BR Excel dialect: ; separator, CRLF line breaks, comma as decimal separator. |
| XLSX summary | Dashboard (aggregates) | Server | One sheet per block. |
| XLSX detail | The visual's entire snapshot | Server | This is the "full export"; it reads the snapshot through the secure view. |
| Page/dashboard | Cloud rendering worker | A faithful picture; depends on the rendering worker. | |
| PNG | Visual/page | In the browser | Image generated by your browser. |
Screen × total × export (the contract)#
ingestia.bi keeps three consistent numbers and warns you when they aren't the full universe:
- Screen: the rows loaded in the client.
- Total: summed over the loaded set (not over the virtual window). When it isn't the full universe, the label says "TOTAL (sample)" or "TOTAL (partial)".
- CSV export: the same rows as the screen; if partial, the file name
gets the
_amostrasuffix. For the full data, use XLSX detail.
Step by step#
Refresh the data
Check Data from … below the title. If needed, use Refresh now (see Data modes).
CSV of a chart
Right-click the chart ▸ Export this visual as CSV. The file opens in pt-BR Excel without breaking columns. In the same menu, Save as image downloads the chart as PNG.
Dashboard Excel
The Excel button in the header (summary, as on screen). For the rows behind each chart, More actions ▸ Underlying data (detail). The file carries a sample badge if truncated and a confidentiality stamp.
PDF or PowerPoint
The PDF button (Business and Scale plans) or PPT (one page = one slide). If the PDF doesn't come out, a tooltip explains why; use Print preview ▸ Print / PDF from the browser.
RLS and PII on export#
Every output applies RLS + PII masking + a confidentiality stamp:
- XLSX/PDF read the snapshot with the requester's RLS — you export only what you see.
- On-demand PDF uses an ephemeral embed token (5 min, 1 dashboard) that carries the session's RLS; the worker prints exactly your slice (an unpublished dashboard is refused; anti-IDOR download).
- Details in Tutorial: configure RLS.
Expected result#
- The CSV opens in pt-BR Excel with the right columns; the name has
_amostraif partial. - XLSX detail brings the entire snapshot through the secure view.
- The PDF (when enabled) reproduces the dashboard with your slice.
Limits and caveats#
- PDF requires the rendering worker + a plan with PDF; without them, nothing is generated.
- The snapshot is a row ceiling — exports reflect that ceiling (with the sample badge).
- The PPTX appearance may vary between versions of PowerPoint.
Common mistakes#
- CSV with merged columns: make sure you opened it as pt-BR Excel (
;separator). - "PDF won't generate": read the tooltip next to the button — usually the plan doesn't include PDF. Use Print preview ▸ Print / PDF.
- Rows are missing: it's a sample of the snapshot — use XLSX detail for the full set.
Related#
- Dashboard header actions
- Export and distribution
- Data modes: Import, DirectQuery and cache
- Tutorial: configure RLS
Last reviewed: 2026-10-03.