cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
amalm Helper II
Helper II

Annoying differences in data between Desktop data and Server Data

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?? Smiley Frustrated

What do I do? 

 

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

1 ACCEPTED SOLUTION

Accepted Solutions
amalm Helper II
Helper II

Re: Annoying differences in data between Desktop data and Server Data

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. 

View solution in original post

4 REPLIES 4
Super User IV
Super User IV

Re: Annoying differences in data between Desktop data and Server Data

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?




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






Power BI Blog
Community Support
Community Support

Re: Annoying differences in data between Desktop data and Server Data

@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.

amalm Helper II
Helper II

Re: Annoying differences in data between Desktop data and Server Data

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. 

View solution in original post

Super User IV
Super User IV

Re: Annoying differences in data between Desktop data and Server Data

Hi there

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




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






Power BI Blog

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.