Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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 valueDesktop valuePublished valuePublished value

 

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

7 REPLIES 7
dsovethanov
New Member

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

Greg_Deckler
Super User
Super User

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.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

I'm sorry, it is a report 🙂

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


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

Nope... I checked that...

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.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.