// Public demonstration data. Configure refresh separately in Power BI.
let
    Source = Json.Document(Web.Contents("https://assessment.kitcrewapp.com", [RelativePath = "api/reporting", Query = [table = "crew", format = "json"]])),
    Rows = Table.FromRecords(Source[rows], Source[columns], MissingField.UseNull),
    Typed = Table.TransformColumnTypes(Rows, {
        {"crewId", type text},
        {"crewName", type text},
        {"staffNumber", type text},
        {"batch", type number},
        {"grade", type text},
        {"sessionId", type text},
        {"status", type text},
        {"statusLabel", type text},
        {"passed", type logical},
        {"additionalTrainingRequired", type logical},
        {"attemptCount", type number},
        {"assessmentDate", type text},
        {"course", type text},
        {"aircraftType", type text},
        {"configuration", type text},
        {"checklistVersion", type text},
        {"mainTrainer", type text},
        {"recordedAssessments", type number},
        {"failedAssessments", type number},
        {"promptedAssessments", type number},
        {"assessingMinutes", type number},
        {"simulated", type logical},
        {"updatedAt", type text}
    })
in
    Typed