Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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%'
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
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
75 | |
71 | |
38 | |
29 | |
26 |
User | Count |
---|---|
97 | |
96 | |
60 | |
44 | |
41 |