Inconsistent data after every refresh

[Anonymous]

I have a report built into a Matrix and everytime i hit refresh,  the numbers changed dramattically, even after just a few minutes between refreshes. It changes from $11,000,000 total to $700,000 and then will go back to the 11 million. The amount of records in my expense table, after pulling it into Power BI, is not even up to 100,000 records. I pull in my data from an ODBC connection and then use SQL queries to bring in the data (tables take to long to load in if i do not). My number values are decimal values. The column I grab the values from is a new column i create (basically the amount in the table times another amount. If i refresh it in the desktop version or let my gateway on the schedual refresh do it, it gives me this problem. 

Here is the SQL code i am using, relatively basic one, but due to the size of the GLentry , i cant pull it all in and then edit it in Power Query

Select *

from glentry

where location BETWEEN 501 AND 505 

AND entry_date > '6/30/17'
 
AND accountno LIKE '8%'

[v-yulgu-msft]

Hi @Anonymous,

Please test to count the records returned by above SQL code on data source side to see if the result is correct. Did you connect to data source with Import mode or Live connection mode? You said you hit the refresh, then total value changed on report, was the source data updated?

Regards,

Yuliana Gu