Annoying differences in data between Desktop data and Server Data

[amalm]

I've only started noticing this issue in the past 2-3 days. The following are screenshots of the exact same visual, one in the Desktop and the other in Power BI app downloaded from the Windows store:

Screenshot from the Desktop:

Screenshot from the end user app:

As you can see, columns 2 & 3 are exactly the same, as they should be, but in Columns 1 & 4 there is a difference of 4 hours between the values. Seems like a bug?? 

What do I do? 

Additional info: Columns 2&3 are pulled from one table, and Columns 1&4 are from another table.

[amalm · Accepted solution]

Thank you for your replies. 

I figured out the bug. The column in question was formatted as "Date & Time" whereas the right format to be used was "Date, Time, Timezone". The Desktop application and the online service were interpreting the data differently due to this. 

[GilbertQ]

Hi there

I learn something new every day, that is good to know. Thanks for posting it here!

[v-yuta-msft]

@amalm,

What's the data source? Are the two reports using the same data source? Has anyone refresh the data source before this issue happens?

Community Support Team _ Jimmy Tao

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

[GilbertQ]

Hi there

Could it be due to the data refresh being at different times?
What I mean is if the data is changing and you refresh your PBIX manually, and in the Power BI Service it has a scheduled refresh then the numbers would always be different?