Integrations · Spreadsheets and no-code

Load job postings data into Power BI

Load job posts into Power BI with a Power Query (M) script that pages through results and refreshes in the Power BI service.

Get an API key Read docs

Steps

You need: Power BI Desktop; the same query also works in Excel's Power Query and a jobdata API key.

In Power BI Desktop choose Get data → Blank query → Advanced editor and paste the script.
Set your API key and filters in the Query record.
Use Anonymous credentials for the data source - the API key travels in the header.
Publish and set a scheduled refresh; the static base URL keeps the query refreshable in the service.

Power BI · powerquery

let
    ApiKey = "YOUR_API_KEY",
    GetPage = (page as number) => Json.Document(Web.Contents("https://jobdataapi.com", [
        RelativePath = "api/jobs/",
        Query = [title = "analyst", max_age = "30", page_size = "1000", page = Text.From(page)],
        Headers = [Authorization = "Api-Key " & ApiKey]
    ])),
    Pages = List.Generate(
        () => [n = 1, r = GetPage(1)],
        each [r] <> null,
        each [n = [n] + 1, r = if [r][next] = null then null else GetPage([n] + 1)],
        each [r][results]
    ),
    Jobs = Table.FromRecords(
        List.Combine(Pages),
        {"id", "title", "location", "published", "has_remote", "application_url"},
        MissingField.UseNull
    )
in
    Jobs

Notes

Expand the nested company record with Expand column if you need company name, website or logo.
Keep the base URL static and pass filters via Query - dynamic URLs block scheduled refresh in the Power BI service.

Ready to load real data?

All endpoints are public for limited testing - run the script without a key to see the structure, then add your key. Flat monthly plans with unlimited usage.

View pricing Explore endpoints