// Public demonstration data. Configure refresh separately in Power BI.
let
    Source = Json.Document(Web.Contents("https://assessment.kitcrewapp.com", [RelativePath = "api/reporting", Query = [table = "trainers", format = "json"]])),
    Rows = Table.FromRecords(Source[rows], Source[columns], MissingField.UseNull),
    Typed = Table.TransformColumnTypes(Rows, {
        {"trainerId", type text},
        {"trainerName", type text},
        {"staffNumber", type text},
        {"recordedResults", type number},
        {"standardResults", type number},
        {"promptedResults", type number},
        {"failedResults", type number},
        {"assessingMinutes", type number},
        {"averageSeconds", type number},
        {"finalPassDecisions", type number},
        {"additionalTrainingDecisions", type number}
    })
in
    Typed