Saved reports and Power BI

Save a report

On Reports, click New report (or Open the report builder) on the Saved reports card. Choose the columns, date range and filters, click Save report and give it a name. A preset range such as Last 30 days moves forward each time the report runs; a custom range keeps its days. Days are each terminal's local day: a wait that started at 11:30 PM in Phoenix on Nov 7 is a Nov 7 record, even for a company in Chicago. The file's times are each record's local time, with Time zone columns.

Everyone on your team sees the company's saved reports in the Saved reports card on Reports. Standard carriers can keep 1 saved report; Pro carriers and fuel buyers can keep as many as they need. Anyone can open one, download it (CSV) or Make a copy; the person who saved it and admins can rename, change or remove it. Downloading a report (like every export) needs two-factor authentication on your account; the Power BI feed below uses an API key instead.

Connect Power BI

The API feed is part of Pro for carriers ($199 a month; upgrade on Settings > Plan & billing) and free for fuel buyers.

1. Create an API key under Settings > API keys with the reports:read permission, and copy it.
2. In the Saved reports card on Reports, open the report's menu and click Copy feed URL.
3. In Power BI Desktop, choose Get Data > Web, then Advanced.
4. Paste the URL in URL parts. Under HTTP request header parameters, enter Authorization and the value Bearer followed by a space and your key.
5. Click OK, choose Anonymous if asked how to connect, then expand the data list into a table (or add ?format=csv to the URL to get a table straight away).
6. Publish the report. In the Power BI service, open the semantic model's settings, set the data source credentials to Anonymous (the key travels in the header) and turn on Scheduled refresh.

Excel (Data > Get Data > From Web, Advanced) and Tableau (Web Data or a CSV URL) connect the same way.

What the feed returns

Each row is one record. Column names are stable (record_number, amount, start_time), numbers are numbers and times are in UTC; every row ends with time_zone, the terminal's zone (such as America/Phoenix), to show local times. A custom range or year to date counts each record on the day its wait started at its terminal; Last 30 days and the other rolling ranges end when the report runs. Up to 50,000 rows come back; when more match, the JSON says truncated: true and a CSV is refused, so narrow the report's date range or statuses. See demurly.com/docs/api for the details.

Send it on a schedule

Admins can email a saved report every day, week or month: see Scheduled reports in Payment history and exports.