Conectar o Power BI — Assessor Tech

let
    ApiKeyValue = "COLE_SUA_CHAVE_AQUI",
    BaseUrl = "https://claude-data-hub.lovable.app",
    PageSize = 1000,

    // Filtros opcionais. Record vazio = sem filtro.
    FiltroBase = [],

    FetchPage = (offset as number) as record =>
        let
            Consulta = Record.Combine({
                FiltroBase,
                [
                    limit  = Number.ToText(PageSize),
                    offset = Number.ToText(offset)
                ]
            }),
            Resposta = Web.Contents(
                BaseUrl,
                [
                    RelativePath = "api/public/assessor",
                    Query        = Consulta,
                    Headers      = [ #"x-api-key" = ApiKeyValue ]
                ]
            )
        in
            Json.Document(Resposta),

    PrimeiraPagina = FetchPage(0),

    // Falha explícita se a resposta não trouxer o total de linhas.
    TotalBruto = Record.FieldOrDefault(PrimeiraPagina, "count", null),
    Total =
        if TotalBruto = null or not Value.Is(TotalBruto, type number)
        then error "Resposta sem o campo 'count'. Verifique a chave de API (header x-api-key) e a URL do endpoint."
        else TotalBruto,

    OffsetsRestantes =
        if Total <= PageSize
        then {}
        else List.Generate(() => PageSize, each _ < Total, each _ + PageSize),

    PaginasRestantes = List.Transform(OffsetsRestantes, each FetchPage(_)[data]),
    TodasAsLinhas = List.Combine({ PrimeiraPagina[data] } & PaginasRestantes),

    Colunas = { "id", "ticket_numero", "assunto", "status", "categoria", "subcategoria", "cliente", "solicitante", "responsavel", "data_abertura", "data_atualizacao", "data_fechamento", "tempo_gasto_horas", "tempo_contratado_horas", "mes_abertura", "mes_fechamento", "servico_completo", "urgencia", "justificativa", "quantidade_acoes" },
    TabelaBruta = Table.FromRecords(TodasAsLinhas, Colunas, MissingField.UseNull),

    TabelaTipada = Table.TransformColumnTypes(TabelaBruta, {
        {"id", type text},
        {"ticket_numero", type text},
        {"assunto", type nullable text},
        {"status", type nullable text},
        {"categoria", type nullable text},
        {"subcategoria", type nullable text},
        {"cliente", type nullable text},
        {"solicitante", type nullable text},
        {"responsavel", type nullable text},
        {"data_abertura", type nullable datetimezone},
        {"data_atualizacao", type nullable datetimezone},
        {"data_fechamento", type nullable datetimezone},
        {"tempo_gasto_horas", type nullable number},
        {"tempo_contratado_horas", type nullable number},
        {"mes_abertura", Int64.Type},
        {"mes_fechamento", type nullable number},
        {"servico_completo", type nullable text},
        {"urgencia", type nullable text},
        {"justificativa", type nullable text},
        {"quantidade_acoes", type nullable number}
    })
in
    TabelaTipada