Power BI Desktop and Web show different data

[abogdanov]

I have built a dashboard and a couple of cards on it show different numbers in the web version of it, no matter what I do. What could be a reason for it? All the filters are exactly the same but where the Desktop file shows 5, the web file shows 10. 

Has anyone run into an issue like this?

[v-yangliu-msft · Accepted solution]

Hi  @abogdanov ,

1. If there is a Boolean data type in your dataset, it may cause this to happen. You can modify the Power BI filter to solve it:

https://www.c-sharpcorner.com/blogs/reports-doesnt-show-data-in-power-bi-web-service-after-refresh-i...

https://community.powerbi.com/t5/Report-Server/After-a-scheduled-refresh-the-report-has-no-data/td-p...

2. Whether the functions of Now() and Today() exist in your dax formula, the Today() function on the Power bi service returns today’s value according to the UTC time zone, while the Today() function on the Power bi desktop shows the computer’s system time, so in Power bi service, your time zone and standard time are different, resulting in data not appearing

https://radacad.com/solving-dax-time-zone-issue-in-power-bi

https://www.linkedin.com/pulse/power-bi-service-time-differences-how-fix-aaron-watsky

Best Regards,

Liu Yang

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

[jaideepnema]

Hi @abogdanov ,

Is the data different between the web and desktop version of the file ? This might happen if the dataset is not refreshed in the web version but refreshed in Desktop version manually.

Please accept this as a solution if your question has been answered !!

Appreciate a Kudos 😀

[abogdanov]

both have been refreshed multiple times and they still show different numbers

[Syk]

Try refreshing the data in both places. Could be that one of them is looking at older/unrefreshed data.

[abogdanov]

Not the case. I have tried updating the dataset and the visuals and neither thing helped.