Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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:
I cannot explain why this is. Can someone help me?
Try to click on "Reset to default" on top right of the report.
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.
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?
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.
Unfortunaly I have all the rights... it is soooo weird!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
82 | |
64 | |
62 | |
56 |
User | Count |
---|---|
171 | |
112 | |
110 | |
72 | |
72 |