Skip to content

Automatic translation — the Portuguese version is the reference. View in Portuguese

Updated on 2026-10-03

Tutorial: export data (CSV, XLSX, PDF and PowerPoint)

Take the numbers to Excel or PDF, understanding the summary/detail modes, the sample badge and what RLS does on export.

On this page (8)

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#

FormatScopeWhere it runsNotes
CSVOne visualIn the browser (client)pt-BR Excel dialect: ; separator, CRLF line breaks, comma as decimal separator.
XLSX summaryDashboard (aggregates)ServerOne sheet per block.
XLSX detailThe visual's entire snapshotServerThis is the "full export"; it reads the snapshot through the secure view.
PDFPage/dashboardCloud rendering workerA faithful picture; depends on the rendering worker.
PNGVisual/pageIn the browserImage 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 _amostra suffix. For the full data, use XLSX detail.

Step by step#

  1. Refresh the data

    Check Data from … below the title. If needed, use Refresh now (see Data modes).

  2. 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.

  3. 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.

  4. 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 _amostra if 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#


Last reviewed: 2026-10-03.

Related links