cancel
Showing results for 
Search instead for 
Did you mean: 
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
New Member

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

Super User IV
Super User IV

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!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




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!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




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!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Anonymous
Not applicable

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

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session Drive Data Culture with Power BI: Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors