Power BI Pro showing different dates compared to Desktop

Question

Hi,&nbsp;I'm having an error with one of my reports. I have a sale that was made on the 1st April and on Power BI Desktop it works fine and I have no problems with it, however when I upload it to Power BI Pro, the sale moves back a day and show the sale on the 31st March.&nbsp;&nbsp;I had this happen once before on another report for April as well and I couldn't figure it out. I don't understand why it happens and why does it only affect April&nbsp;&nbsp;Has this happened to anyone else, and if so what did you do?&nbsp;Cheers,Mike

greg_deckler · Answer

Have not seen this, is this a measure or a value in a column? Could be time zone related.

michael_knight · Answer

Hi&nbsp;Greg_Deckler&nbsp;&nbsp;It's a measure. I thought I was having dejavu but I actually posted about this in October but I didn't get any replies&nbsp;https://community.powerbi.com/t5/Desktop/Publishing-to-web-date-change/m-p/823150#M395487&nbsp;The strange thing is that it only happens on the 1st April. I did create a date dimension that I saw onlineso I think there might be a issue with that, however that issue would arrise in Desktop.&nbsp;

anonymous · Answer

Hi&nbsp;michael_knight&nbsp;,Please check whether the solutions in the below threads can solve your problem:https://community.powerbi.com/t5/Service/Date-in-Power-BI-Pro-report-is-one-day-earlier-compared-to-the/m-p/593428https://community.powerbi.com/t5/Service/Power-BI-Date-Time-Values-in-the-Browser-are-Different-Than/m-p/867291Best RegardsRena

michael_knight · Answer

No luck with that&nbsp;Anonymous&nbsp;&nbsp;This is 100% a timezone issue. I create a NOW() measure and there's a 1 hour difference in Desktop to Pro&nbsp;1st April seems to be the date that the timezones change to +01:00:00&nbsp;&nbsp;

michael_knight · Answer

Okay, did some testing. I create a new column with the different Timezone. I made it so it the time in the record was around 8 hours difference, I did this because my initial thought was that the time change caused a probably.

DateTimeZone.SwitchZone([Option Signed Date], +8)

Here is what it looks like is desktop. This is what it should look like. The record on the bottom is the one I'm having issues with

This is what it looks like on Pro

This puzzled me even more. I had assumed it was a timezone difference but it's a 24 hour differece

Any suggestions?

Forum Discussion

Power BI Pro showing different dates compared to Desktop

8 Replies

Related content

KPI % Comparing Suppliers - Same measure shows different values

Compare different tables

Comparing values between different tables

Count showing wrong compare to bar chart

Compare two columns in different tables