Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
But in Power BI Service o Data Flow don't change
I configured in my location in options
Why is it different in Power BI Desktop and Data Flow?Dataflow
Solved! Go to 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
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
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
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