Values incorrect after publishing

[Anonymous]

My report is running perfectly for some weeks but all of a sudden it shows incorrect values. 

I have a direct query connection with my SQL database and I do a simple count. On my desktop I see the correct value, but when I publish it, the value is wrong...

Example:

Desktop valuePublished value

I cannot explain why this is. Can someone help me?

[dsovethanov]

Try to click on "Reset to default" on top right of the report. 

[Greg_Deckler]

Is this really on a dashboard or is this a report? If it is a dashboard, generally this is caused because when you pin a tile, the tile maintains its context at the time it was pinned.

[Anonymous]

I'm sorry, it is a report 🙂

[Greg_Deckler]

Hmm. Only thing I can think of since it is a Direct Query is if the gateway is talking to the wrong database?

[Anonymous]

Nope... I checked that...

[Greg_Deckler]

Perhaps some kind of permissions issue, where the account that you are using to connect from your Desktop has permission to see stuff that the account being used by the gateway does not? Sorry, grasping at straws.

[Anonymous]

Unfortunaly I have all the rights... it is soooo weird!