Getting data from a PostgreSQL (issues)

[iguevara]

Hi,

    I'm getting data from a couple tables of a PostgreSQL DB but it is retreiving only a small part of the records. Everytime I refresh tha data, PowerBI Desktop shows different results but always incomplete information... maybe there is a part that I'm not doing well.

Loading query:

Select wrhs_id, created, local_code, subtotal, tax_amt, grand_total
 From orders where date_part('year',created) >= 2013

Any ideas?

Regards

Ignacio Guevara

[curth]

Is this inside the editor or after you fill into the data model? If inside the editor, the editor always shows only the first n rows of the result, so if the query defines a result set whose size is greater than n and the server returns them in a different order each time, you'd get what you're describing.

[Anonymous]

Ignacio,

This is just an idea, but there have been some issues with date recognition from other data sources. Can you make the year transform in your source? So your query would change to look only for orders where [year] >= 2013 instead of doing the date_part()? See if that works...