Issue with data changing when published but only for one user

[siansian]

Hi, when publishing from Power BI Desktop to our report server, I have an issue whereby filtered cards intermittently show different values than those which are correct. E.g. actual value = 400, value shown in published report = 200. I assumed intially that this was the same for all users accessing the report, however, I've since discovered it's only affecting me - the person who published the report. Has anyone else experienced this and have any ideas as to how I can correct it?

[siansian]

Hi @v-xiaoyan-msft, just wondering how you tested my report? There are various filters applied to the report, but that's not really the issue I'm afraid - it's the difference between the value being shown when the report is in production vs. that which is shown once it's published.

[v-xiaoyan-msft]

Hi @siansian ,

Sorry I may not be able to fully reproduce your problem because of the sample, I made a simple demo with the filter applied. During my research, I found that users with similar problems to yours are usually caused by applying filters to the dataset, perhaps you could provide me with information about the version you are currently using?
I'll check in the internal icm to see if anyone else is reporting the same issue as you, and I'll update you here if there are any developments.

Hope it helps,

Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[v-xiaoyan-msft]

Hi @siansian ,

After my testing, the report works fine with me.
Please check if you have applied a filter to your report first.my best advice would be to check your queries as thoroughly as possible to see what they’re actually doing and if perhaps they have a hidden filter that could be impacting your dataset.

Hope it helps,

Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.