Skip to main content

Power BI

Needs Votes

Don't adjust non-existing local datetime values in Reports

Vote (5) Share
Marcel Beugelsdijk's profile image

Marcel Beugelsdijk on 11 Apr 2017 10:50:19

Due to local time switches (typically Daylight Saving Time), some date/time combinations do not exist.
Such date/time combinations are allowed in Power Query and the Data Model, but in Report View, such combinations are adjusted, both in Power BI Desktop and in Power BI..
This video clearly illustrates the issue: https://www.youtube.com/watch?v=AIWLEsIoPSQ

Previously I raised a question: https://community.powerbi.com/t5/Desktop/Datetime-field-in-Report-View-not-the-same-value-as-in-Data-View/m-p/156542#M67805