Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |