BI data feeds
Pull a saved report into Power BI, Excel, Google Sheets or Looker Studio with a CSV or JSON feed.
Availability: Data feeds are part of Custom Reports. See Optional features.
A data feed is a web address that returns a saved report's current results. BI tools fetch it on their own refresh schedule, so your spreadsheet or BI dashboard stays up to date without anyone downloading files.
Who can do what
- Anyone who can build reports (Organization Admins and Recruiters by default) creates and revokes their own API keys. Report admins can see and revoke everyone's.
- Anyone who holds a key can fetch any saved report in your organization. The feed returns what the key's creator can see when it's fetched: only their jobs, and base salary only if they can see it. Treat a key like a password.
Create an API key
- Open Insights → Reports → Data feeds. The same keys are also listed under Insights → Data export, in Report API keys (BI feeds).
- Enter a Key name, such as the tool or team that will use it.
- Select Create key.
- Copy the key straight away. It is shown only once.
Keys made here work only for report feeds.
To stop a key working, select Revoke next to it. Any tool using it stops getting data.
Get a report's feed address
- Open the saved report.
- Open Connect to BI tools.
- Copy the CSV feed or JSON feed address.
- Put your API key in place of
YOUR_API_KEY.
Connect your tool
Connect to BI tools has step-by-step tabs for each tool:
| Tool | Feed | In short |
|---|---|---|
| Power BI | JSON | Get Data → Web, paste the address, expand the rows list into columns, then set a scheduled refresh |
| Excel | CSV | Data → Get Data → From Other Sources → From Web, paste the address, then Load. Refresh with Data → Refresh All. |
| Google Sheets | CSV | Enter =IMPORTDATA("your CSV feed address") in a cell. Sheets fetches it again about every hour. |
| Looker Studio | CSV | Import the feed into Google Sheets first, then choose Create → Data source → Google Sheets and pick that sheet |
Send the key securely
If your tool lets you add a request header, send the key as Authorization: Bearer followed by the key, and leave ?key= off the address. Keys in an address can end up in browser history and logs.
Addresses with ?key= still work for tools that only accept an address, but this way is being phased out.
What a feed returns
- CSV: one header row with the report's column names, then the report's rows.
- JSON: the report's name and source, when it was generated, the total number of matching rows, the columns, the rows, and any group totals.
A feed returns the same rows as the report, up to 500. Totals and the matching-row count cover every matching row. See How many rows you see.
Limits and errors
- Each key can make up to 120 requests an hour. Over that, the feed refuses requests and says when to try again. Set your tool to refresh less often.
- A missing or revoked key is refused.
- A key stops working if the person who created it is removed, deactivated or loses build access. Create a new key from someone who still builds reports.
- An archived report, or one from another organization, returns not found.
- If Custom Reports is switched off for your organization, feeds stop working.
