Forum Discussion

Tekuii's avatar
Tekuii
Frequent Visitor
3 years ago

Diferent results from query inside Postgres SQL and Power BI

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 ...
Need Help
MahyarTF's avatar
MahyarTF
Memorable Member
3 years ago

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's avatar
Tekuii
Frequent Visitor
3 years ago

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's avatar
    MahyarTF
    Memorable Member
    3 years ago

    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's avatar
      Tekuii
      Frequent Visitor
      3 years ago

      Yes, it is.

    • Tekuii's avatar
      Tekuii
      Frequent Visitor
      3 years ago

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

      • MahyarTF's avatar
        MahyarTF
        Memorable Member
        3 years ago

        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.