Forum Discussion

Maradh's avatar
Maradh
Helper I
3 years ago

Web and Desktop having different dates

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

Need Help

5 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Maradh , try these two first

    Clear Browser Cache -> refresh -> Check  

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

    • Maradh's avatar
      Maradh
      Helper I
      3 years ago

      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)

  • hashtag_pete's avatar
    hashtag_pete
    Helper V
    3 years ago

    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's avatar
      Maradh
      Helper I
      3 years ago

      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

  • Maradh's avatar
    Maradh
    Helper I
    3 years ago

    Bumping my post

    I still have no clue on how to solve this problem