Refresh DateTime in power Bi Service not the right time

[Frixel]

Hello,

I will create a vizual in my model for when the model is refresh.

I create this in the Power Bi Desktop and there the time is correct.

When i publish it to the Power Bi Service and the is a refresh the time is incorrect. (minus 2 hours) I am stay in Netherlands, Amsterdam.

What is going wrong?

[Frixel · Accepted solution]

Hi all,

thanks for your helps, i haven it now fixed and working with this video

YouTube 

[Jonvoge]

Hi Frixel

You're luckily not the first to discover this.

Try the fix mentioned in this post: Solved: Last Refresh Date change Timezone - Microsoft Fabric Community

Date.From(DateTime.FixedLocalNow())

_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.
Find me on LinkedIn, Sessionize, or my blog Downhill Data

[Frixel]

Hi @Jonvoge 

When i use the " Date.From(DateTime.FixedLocalNow())"  i only get the date and not the time

[Jonvoge]

Hi Frixel

You can probably just use DateTime.FixedLocalNow(), and omit the date.from part that I included before.

_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.
Find me on LinkedIn, Sessionize, or my blog Downhill Data

[Frixel]

Hi @Jonvoge 

And what choose i here for the richt convert?

[Jonvoge]

I believe Date/Time is sufficient... But I could be wrong. Try both!

_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.
Find me on LinkedIn, Sessionize, or my blog Downhill Data

[Frixel]

I try both but always in the service the time is 2 hours earlyer than it is.

[sergej_og]

Hey @Frixel ,
try this one.
= DateTimeZone.SwitchZone(DateTimeZone.UtcNow(),2)

I solved this topic this way for the moment.
I have to check the solution after switching the summer time to winter time.
Maybe it would be this by the end of October
= DateTimeZone.SwitchZone(DateTimeZone.UtcNow(),1)

Service switch always to UTC.

Regards

[Frixel]

Hi @sergej_og 

Thanks for your helps but hen i get this.

[Frixel]

I created a new datetime colomn from colomn 1 like this 

Then it is correct time in the desktop but also in the service i miss 2 hours.