Diferent results from query inside Postgres SQL and Power BI

[Tekuii]

So, I have a VIEW with this query

SELECT
    aap.qtd_procedimento,
    COUNT(aap.qtd_procedimento) as soma_raio_x
FROM
    arq_agendal aa
    INNER JOIN arq_agenda_procedimento aap ON aap.chave = aa.chave
WHERE
    (
        aa.ind_status = 'A'
        OR aa.ind_status = 'M'
    )
    AND (
        aa.des_procedimento :: text = ANY (
            ARRAY ['ABDOMEN AGUDO'::character varying::text, 'ABDOMEN SIMPLES- A.P.'::character varying::text, 'ADICIONAL DE INCIDÊNCIA'::character varying::text, 'ANTEBRAÇO'::character varying::text, 'ART. SACRO ILÍACAS'::character varying::text, 'ARTICULAÇÃO ACRÔMIO-CLAVICULAR'::character varying::text, 'ARTICULAÇÃO COXO-FEMURAL (CADA LADO)'::character varying::text, 'ARTICULAÇÃO ESCÁPULO-UMERAL'::character varying::text, 'ARTICULAÇÃO ESTERNO-CLAVICULAR'::character varying::text, 'ARTICULAÇÃO TIBIO-TÁRSICA'::character varying::text, 'ARTICULAÇÕES SACRO-ILÍACAS'::character varying::text, 'BACIA'::character varying::text, 'BRAÇO (ÚMERO)'::character varying::text, 'CALCÂNEO'::character varying::text, 'CAVUM: LAT - HIRTZ'::character varying::text, 'CLAVÍCULA'::character varying::text, 'CLISTER OPACO (DUPLO CONTRASTE)  '::character varying::text, 'COLUNA CERVICAL: FUNCIONAL OU DINÂMICA'::character varying::text, 'COLUNA DORSAL:  A.P. - LATERAL / OU TORACICA)'::character varying::text, 'COLUNA LOMBO SACRA COM OBLIQUAS E COM SELETIVAS PARA L5/S1      '::character varying::text, 'COLUNA LOMBO-SACRA                  '::character varying::text, 'COLUNA PARA ESCOLIOSE: P. A. - LATERAL/ OU TOTAL PARA ESCOLIOSE   '::character varying::text, 'COLUNA TORACO- LOMBAR                   '::character varying::text, 'COLUNA TOTAL OU ESCOLIOSE PANORÂMICA'::character varying::text, 'COLUNA VERTEBRAL OU COLUNA TOTAL      '::character varying::text, 'CORAÇÃO E VASOS DA BASE (RCVB): P.A. - LAT'::character varying::text, 'COSTELAS- POR HEMITORAX'::character varying::text, 'COTOVELO'::character varying::text, 'COXA'::character varying::text, 'CRÂNIO P. A. LAT'::character varying::text, 'CRÂNIO P. A. LAT- BRETTON'::character varying::text, 'ESCANOMETRIA'::character varying::text, 'ESÔFAGO '::character varying::text, 'ESTERNO'::character varying::text, 'JOELHO C/ AXIAL (CADA LADO)'::character varying::text, 'JOELHO OU RÓTULA A.P. LAT - AXIAL'::character varying::text, 'JOELHO: A.P. - LATERAL'::character varying::text, 'MAMOGRAFIA'::character varying::text, 'MÃO OU QUIRODÁCTILOS'::character varying::text, 'MÃOS E PUNHOS PARA IDADE ÓSSEA'::character varying::text, 'MAXILAR INFERIOR: P. A - OBLIQUAS'::character varying::text, 'MEMBROS INFERIORES (D/E)'::character varying::text, 'MEMBROS SUPERIORES (D/E)'::character varying::text, 'OMOPLATA OU OMBRO FUNCIONAL'::character varying::text, 'ÓRBITAS P. A. LAT OBL.- HIRTZ'::character varying::text, 'OSSOS DA FACE: M.N. -  F.N. LAT - HIRTZ'::character varying::text, 'PÉ C/ CARGA'::character varying::text, 'PÉ OU PODODÁCTILOS'::character varying::text, 'PELVE C/ CARGA'::character varying::text, 'PERNA'::character varying::text, 'PUNHO A .P. - LAT'::character varying::text, 'PUNHO A .P. - LAT - OBLIQUAS'::character varying::text, 'SACRO-COCCIX'::character varying::text, 'SEIOS DA FACE: F.N. - M.N. LAT'::character varying::text, 'SELA TURCA: P. A. LAT - BRETTON'::character varying::text, 'TORAX: P. A - LAT / arcos costais'::character varying::text, 'TORNOZELO'::character varying::text, 'TORNOZELO C/ OBLIQUAS'::character varying::text, 'TRÂNSITO INTESTINAL'::character varying::text]
        )
        OR aa.des_procedimento ILIKE '%Rx%'
        OR aa.des_procedimento ILIKE '%Raio%'
    )    
    
GROUP BY  aap.qtd_procedimento
    

This is the output:

I've imported this view to PBI ... and that's what I got from it.

[Tekuii]

Do you have any idea of what could solve this?

[MahyarTF]

Hi,

what is the data type of the original column that you did sum in your measure and also have you checked the aggregation type of the column in Tabe visual?

Appreciate your Kudos

[Tekuii]

Hi, thanks for your support, here it is how the aggregation is at the moment

And the data type is set to "Whole Number"

[MahyarTF]

It is weird,

Do you see the same data in the Model panel in Power BI ?

I mean, if the data that is shown in power bi is the same as the image you shared on your first page

[Tekuii]

Hi, do you have any other idea of what could be causing to this divergence between data?

[MahyarTF]

To be honest, nothing.

But just for test, create new power bi and bring the query individually and test it,

I know maybe, it will not be useful, but sometimes, something is cashed, and couldn't see that.

[Tekuii]

I've created a brand new project, and still getting same result as before.

[Tekuii]

Yes, it is.