Inclusi

Build your own reports and connect Power BI or Excel

Choose a dataset, columns, filters and groupings, save and share reports, download CSV or Excel, email them on a schedule, and use the OData feed.

Updated on

Where: Reports in the menu, then Report builder.

  1. Choose New report and a Dataset: for example shifts, timesheets, invoices and invoice lines, claims, participants, workers, incidents, complaints, credentials, training, SIL residents or plan management invoices. You only see datasets, columns and branches your role allows.
  2. Tick the columns. Add a filter for each condition (a column, a Condition and a value; dates can be relative, such as last month). Add a grouping to group By a value or a date period, with totals. Set Sort by and Order.
  3. Look at the Results. Totals for all matching records is at the bottom. Choose Show records on a group to drill into it.
  4. Give it a Name and What it is for, and Save. Save a copy makes your own version of someone else's report.

Download CSV or Download Excel file exports the results; exports are recorded in the audit log. Large results are capped and slow queries stop after 15 seconds; narrow the filters if that happens.

Email a report on a schedule

Choose Email this report, then Add a schedule: How often, the Day or Day of the month, the Time and the File type. Each recipient gets only what their own access allows. Recent emails lists what was sent; Send now sends one straight away and Stop this schedule ends it.

Power BI and Excel

Choose Power BI and Excel for the read-only OData feed (Business and Enterprise plans). Create an API key with reports access in Settings, Integrations, API keys, then follow Connect Power BI or Excel. The feed has a modified-at column for incremental refresh.

The feed follows the OData standard but has not yet been tried with Power BI itself. Tell us if something does not connect.

Was this helpful?

Related articles

Need more help?

Contact support with the page you were on and what you expected to happen. Do not send participants' health details. Is Inclusi down? See the status page.