Re: Different dates in desktop and service

NielsvR · ‎02-19-2021

Hi all,

With one of my reports I have the issue that dates are offset by one day from Power BI desktop to the Service. For example, June 1st in the desktop version becomes May 31 in the service. I have tried to convert the dates to my local timezone (Amsterdam) and to remove the time-component at all, keeping only the dates. The problem however still occurs. Another odd thing is that is only occurs at one account, if I publish the report using another account, the dates are shown correctly in the service.

Does anybody have suggestions about the true nature of this problem and possible solutions? I have seen this issue coming by earlier on this forum, but not with the exact same conditions, and in previous years. So I wonder whether more is known about this issue now..

Thanks in advance!

Niels

TVTBI · ‎05-15-2025

Hi, I had the same issue (in NZ) and resolved it by checking and adjustting the Refresh timezone in the semantic model. Not sure if that was the right fix but seemed to work for me.

carlavd · ‎05-16-2025

Hi,

This I also tried, but did not solve my problem.

I solved it by substracting the 2 hours from the date field in power query. Disadvantage: my report in the desktop version and in the service are not showing the same data, but this is not really a problem.

SaiTejaTalasila · ‎05-20-2024

Hi,

You can refer this one -https://www.myonlinetraininghub.com/change-type-using-locale-with-power-query

carlavd · ‎05-20-2024

Thank you for your answer. I was hoping this would be the solution. So I did "change type" > "Use Locale". But the behaviour was the samen. In Power Bi Desktop the date showed correct 19 the of May. When I published to the service and visualized the report I also got 9 the of May but after 5 seconds it changed to 18th of May.

To try and pinpoint the issue: I made a field showing the current date and time. On publishing the same behaviour: first showing the correct time and than switching to my time -2 hours. And my time zone is UTC-2. But I can't make Power Bi service aware of the fact that I'm in UTC-2. A workaround is manipulating the date but I prefer not to do so because I will see different data in power bi desktop and on the service.

NielsvR · ‎03-04-2021

Hi Dedmon,

Thanks for your reply, but unfortunately this is apparantly not the issue.. Since the storage locations in both accounts are the same, allthough in one account the dates are correct. Do you have other suggestions?

Kind regards,

Niels

v-deddai1-msft · ‎02-22-2021

Hi @NielsvR ,

Power BI service in using UTC time and it is different from local time. Would you please refer to https://radacad.com/solving-dax-time-zone-issue-in-power-bi for solution.

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

Best Regards,

Dedmon Dai

carlavd · ‎05-20-2024

Hi Niels,

Did you finaly solved the issue? I have the same problem. I'm in Belgium and in my Power Bi desktop everthing is ok. I publish to the service and for a few seconds I see the right date but than it chances to the previous date. It's driving me mad.

Thx for you respons,

Carla

collinq · ‎02-19-2021

Hi @NielsvR ,

This is an interesting one! Based on your explanation of the issue, it appears to me that this might be user based? You say that one userid is fine and the other one is different. I am wondering if the userid that is incorrect is "licensed" or "created" (or whatever the term might be) in a different time zone? That would seem to be the unique factor and all I can think of off the top of my head. (My thinking where I have seen similar-ish issues in other tools is where the userid was made at a coporate location which is in a totally different part of the world and it gets "default" time and location based on where it was made and not where the user actually works.)

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

Proud to be a Datanaut!
Private message me for consulting or training needs.

NielsvR · ‎02-24-2021

Hi @collinq ,

where can I check this 'licensing' location? The address-settings of the Office-account maybe? It is only a small company where I work for now, so I guess they just made the account in the Netherlands, but I will sure check this.