Data difference between Web and Desktop

[Anonymous]

Hi there,

I'm experiencing a difference in numbers in my report in power bi web. The issue is very specific, because we have on the graphics shown below the numbers in bars (which are correct both on web and desktop) and in lines "Média de Tempo CEF" (average time in days), which is the one that's presenting this weird variation.

The first one is the desktop one, the other is on the web.

The way i'm calculating this average time is by analysing the initial and current/final time of each step of the process with DATESBETWEEN( ), like such:

The report on power bi web has an daily automatic update set up. At first i thought that it was a problem with the update or some duplicated queries (as i've seen in another support post), but 2021 data is correct, so the problem seems to be only with 2020 data.

For reference, we have these two tables "Fluig 2021" which contains all data of 2021 of course, and "Fluig Completo", that combines the queries of 2020 and 2021.

I know it's hard to picture the issue in full, i cannot share the files due to company info security, but i hope you guys can help me fix this issue that is causing me (and other coworkers) a big headache.

Thanks in advance!

[lbendlin · Accepted solution]

Remember that the Power BI service is based on UTC.