// Public demonstration data. Configure refresh separately in Power BI.
let
    Source = Json.Document(Web.Contents("https://assessment.kitcrewapp.com", [RelativePath = "api/reporting", Query = [table = "results", format = "json"]])),
    Rows = Table.FromRecords(Source[rows], Source[columns], MissingField.UseNull),
    Typed = Table.TransformColumnTypes(Rows, {
        {"sessionId", type text},
        {"crewId", type text},
        {"crewName", type text},
        {"staffNumber", type text},
        {"batch", type number},
        {"grade", type text},
        {"currentStatus", type text},
        {"attemptId", type text},
        {"attemptNumber", type number},
        {"attemptType", type text},
        {"assessmentDate", type text},
        {"course", type text},
        {"aircraftType", type text},
        {"configuration", type text},
        {"checklistVersion", type text},
        {"metadataCaptured", type logical},
        {"assessmentKey", type text},
        {"category", type text},
        {"assessment", type text},
        {"result", type text},
        {"trainerId", type text},
        {"trainerName", type text},
        {"durationSeconds", type number},
        {"completedAt", type text},
        {"failureReason", type text},
        {"failedSteps", type text},
        {"promptType", type text},
        {"promptText", type text},
        {"promptedSteps", type text},
        {"observation", type text},
        {"simulated", type logical},
        {"legacy", type logical}
    })
in
    Typed