Forum Discussion
AndrewDang
9 years agoHelper IV
Set local time zone Power BI Service
Hello all; I have an issue with setting the right local time for my Power BI Service. I have the same measure to pull the current time. My Power BI desktop file pulls up 1/16/2017 4:36:02 PM whic...
sxe8
2 years agoFrequent Visitor
The easiest solution I have found was the keep the Date field as "Local Time" and only make the date formatting in the semantic model.
For example, extracting the datefield from web api in dynamics 365 using Dataflow at the end of the data transformation the date field must be "Local Time".
Then when importing the dataflow into semantic model - when you do your "Transform data" section ensure to transform the datefield to "Local Time" (so you should the value like: dd/mm/yyy hh:mm:ss am +hh:00).
Then in the "table view" you can change the date field to dd/mm/yyyy (and it should display the date in your timezone).
Then you don't have to worry about daylight savings...