cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
giullianoc
Frequent Visitor

Data difference between Web and Desktop

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.

 

 

giullianoc_1-1631815301163.pnggiullianoc_2-1631815313605.png

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:

 

giullianoc_4-1631815822304.png

 

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.

giullianoc_5-1631816200855.png

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!

 

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

Remember that the Power BI service is based on UTC.  

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

Remember that the Power BI service is based on UTC.  

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!