Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi Everyone,
I have two columns name Start Time(GMT) and End Time(GMT), now there can be n no of user who is use to use this table and want to see Start Time(GMT) and End Time(GMT) according to their time zone format instead of GMT time zone
i created two columns below:
Start Time (User Local) ='Last Refresh Date DWS'[Start Time] - (UTCNOW() - NOW())
End Time (User Local) ='Last Refresh Date DWS'[End Time] - (UTCNOW() - NOW())
the above columns works well for me in Desktop but when i publish the dataset to service workspace i am not getting the correct result.
I am getting the same value in Start Time (User Local) and End Time (User Local) as start time(GMT) and End time(GMT) in service.
can anyone help
Hi @kapildua16 ,
Here're some solutions in the following links, please kindly refer to
Solving DAX Time Zone Issue in Power BI - RADACAD
Create Last Refresh Time that respects Daylight Saving in Power Query - YouTube
Power BI Time zone conversion-multiple Countries| Convert GMT into Local time zone| Day Light Saving...
Hope the resolutions mentioned can help you solve the problem.
Best Regards,
Yulia Yan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @kapildua16 ,Power BI service operates in the UTC time zone, and evaluates all locale based time functions in that time zone. Power BI Desktop evaluates them according to the locale of the user.
Proud to be a Super User! | |