Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello All.
I know you can use datetime.local in power query to generate the date and it converts it to UTC in the power BI service.
my questions is though, does this incorporate day light savings time as well?
Solved! Go to Solution.
yes, daylight saving (not savings) time is factored in. You can use the timezone functions in Power Query to translate back and forth as needed. But as you stated behind the scenes everything is done in UTC (as it should be).
Hi @Robert14358
@lbendlin Good Share!
To your question, when you use in Power Query, it retrieves the local date and time of the machine on which the query is being executed. However, when the query is refreshed within Power BI Service, the server's time settings are used, which may or may not automatically account for daylight savings time adjustments depending on the configuration.
Here are the steps you can take to ensure that DST is taken into account in your reports:
Check Regional Settings:
Use TimeZone Functions:
datetime.local
DateTimeZone.ToLocal
Manual Offset Adjustment:
datetime
Verify Refresh Schedules:
Automate DST Adjustments:
Testing:
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
do the time zone functions include DST though? usually they are seperate things.
DST values are selectable, and they map accordingly. It's still your responsibility to look at the calendar as the timing of when DST goes in and out of effect around the world are wild, to say it mildly. (Everybody is complaining about DST but nobody is brave enough to actually abolish it)
yes, daylight saving (not savings) time is factored in. You can use the timezone functions in Power Query to translate back and forth as needed. But as you stated behind the scenes everything is done in UTC (as it should be).
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |