Wrong results for sql query

[Anonymous]

Hello friends,

I am experiencing one of the most annoying bugs:

My SQL Data Source returns zeros (0) for a value field in some rows - instead of real values.

Other rows contain the right numbers in the same field.

After I do a Refresh (in Query mode) - I suddenly see the right numbers. 

It looks as if the source database produces this - but I really don't think it's the case.

I am not able to reproduce this but have seen this three times in the last two days.

I cannot trust the numbers with this occurring... 

Has anyone seen this?

Thanks

Michael

[Greg_Deckler]

I have not seen this but let's see if we can zero in on this.

When you say "My SQL Data Source" is that Microsoft SQL Server and what version?

When you initially get zeros, is that after running the query and importing or is that during Preview of the data source?

Are you running a query against your SQL source or are you using the default navigation of tables and views in Power BI?

Is this a view or a table that you are accessing?

What is the SQL data type of the column where you have seen this?

[pointer_pbi]

Hello @Greg_Deckler , I hava a similar situation, but thhis is on a Excel file, would this happen as well for a Excel file at OneDrive if the Excel file is being saved at the time of the Data fetching (refresh scheduled time)?

[Anonymous · Accepted solution]

I think I have caught the criminal! - It is my operational system that is updating some fields!!!

So the data in the SQL table WAS REALLY changing, like I thought.

@Greg_Deckler Thanks for willing to help!

Power Query is OK!

Michael

[Anonymous]

Thanks, @Greg_Deckler.

My Data Source is MS SQL Server version 9 (2005 I beleive) - could this be a problem? My SELECT is from a table.

I see wrong results in the Report View - so I drill-down to the problemattic accounts (most are OK, but some have differences).

Than, I go to Query to see the detailed data (I add a "Filter" step of one of problematic accounts - I wish they had a filter option in the table view mode in the report)  and indeed - out of 12 rows (one for each month) - there are several rows with 0 (zero) value, instead of some other.

I do "Refresh" - and now I see the right values....

X-Files....