Settings

A flat table of fault tickets that Power BI reads through its data gateway. Choose which tickets go in and which columns it has. The table is rebuilt every night, or straight away from here, and the new copy replaces the old one in a single step, so Power BI never reads a half-built table.

Loading…

What goes in

Which tickets become rows. Sandbox tickets are always left out.

Ticket types

Statuses

Columns

Tick what Power BI should see, name each column, and set the order. ticket_id and refreshed_at are always included.

Include Field Column name Order
Loading…

Preview

The newest 25 rows, exactly as Power BI reads them.

Loading…