cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Localtime don't work in Data Flow

I had had a problem with date utc transform in date and hour local

In Power BI Desktop don't have problem, but in Data Flow don't work

Power BI Desktop change hour to my local
Power BI Desktop.png

 

But in Power BI Service o Data Flow don't change
Data Flow.png

I configured in my location in options
Opçõesw.png
Why is it different in Power BI Desktop and Data Flow?Dataflow

1 ACCEPTED SOLUTION

Hi @rafael1xkr ,

SwitchZone function not real changes stored date time, it only change displayed datetimezone of datetime values.
For power bi service, it will convert to UTC format. So these values you used SwitchZone function to modify display timezone format will change back to UTC format.

Notice: if you direct calculate on these datetime values, they will keep changed datetime value and convert to UTC format.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

3 REPLIES 3
Community Support
Community Support

HI @rafael1xkr ,

AFAIK, current power bi service only support UTC datetime format. If your table contains datetime with local timezone format, it will be converted be UTC formula.

For your scenario, I think 'localidate' not means the data flow datetime zone regions.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Other example, I used a score card to inform last update

I created the formula in M

= DateTimeZone.SwitchZone(DateTimeZone.LocalNow(),-3,0)

When I updated in Power BI Desktop it return the hour correct
But when update in Power BI Service don't consider timezone

Image below you can see in Power BI Service don't consider timezone of -03:00

Erro Update.png

Hi @rafael1xkr ,

SwitchZone function not real changes stored date time, it only change displayed datetimezone of datetime values.
For power bi service, it will convert to UTC format. So these values you used SwitchZone function to modify display timezone format will change back to UTC format.

Notice: if you direct calculate on these datetime values, they will keep changed datetime value and convert to UTC format.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors