Hi,
I'm building a report with absence times of employees, eith data from Dataverse via DirectQuery. The Problem ist, that we are located in Germany and therefore appointments are scheduled in the local timezone. Dynamics stores this information in UTC. In my report i need to translate, lets say the field [scheduledstart] to local timezone.
What i tried so far:
DatetimeZone.ToLocal in PowerQuery does not work, because it is not supported for Direct Query.
Just adding 2 hours to the field does not work, because in Germany Timezones change between CET and CEST during the year. So for a part of the data i need to add 1 hour and for another part I add 2 hours. And the day of the switch changes from year to year.
How else can I get clean local Datetime values for my report???
Thanks in advance 🙂
