Web and Desktop having different dates

[Maradh]

Hi,

I've been struggling to understand and fix this issue i have with this one Power BI report where the dates on the Desktop version are correct but the Web version have all the dates reduce by 1 and it's the only table that is affected this way

Desktop dates

Web dates

You can notice the 2 screenshots don't match and the second column "D_saisie", which is not calculated in DAX but in Power Query, is supposed to be the yyyymmdd version of Date which isn't in the second screenshot

Does anyone have any idea on how this happened and how to fix it ? I've been working on Power BI for 4 years and never encountered this bug before, so im very curious

[Maradh]

Bumping my post

I still have no clue on how to solve this problem

[hashtag_pete]

Hi, 

only an idea: do you have a different local datetime somewhere, probably in PowerQuery, so that depending what the browser time is, you have different outputs?

BR

hashtag_pete

[Maradh]

It seems like there is nothing like that that could affect the date

Like i said, it is the only table that if affected this way in the report and it's only on the Web version

[amitchandak]

@Maradh , try these two first

Clear Browser Cache -> refresh -> Check  

Republish -> Clear Browser Cache -> refresh -> Check  

[Maradh]

I tried and it didn't work

It only happens on one of the 4 tables im using in the report (all having date in it)