Forum Discussion
Time Zone Issue
Hello, I've got some Power BI reports that pull data from Sharepoint. Some of these fields are datetimes. In PowerBI Desktop, they display correctly (exact same time as the Sharepoint data, which...
- Hi there
yes that is correct all the datetimes are stored in UTC.
It is not that it is converting anything it is reading from the source, where the source is stored as UTC.
By creating the offset it will allow you to show it with the correct datetime.
GilbertQ
Super User
Super UserHi there
This is because all the datetimes are stored as UTC
What you will need to do, is to offset it by your timezone. The result will be in Power BI Desktop it will look wrong. But once uploaded to the Power BI Service and the dataset refreshes it will then be correct.
This is because all the datetimes are stored as UTC
What you will need to do, is to offset it by your timezone. The result will be in Power BI Desktop it will look wrong. But once uploaded to the Power BI Service and the dataset refreshes it will then be correct.