Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Values incorrect after publishing

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?

7 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    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's avatar
      Anonymous
      Not applicable

      I'm sorry, it is a report :)

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion

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