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

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

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.

    • Tekuii's avatar
      Tekuii
      Frequent Visitor
      3 years ago

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