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.
So if I'm understanding this correctly, the Power BI Service is converting all of my times to UTC, and because there's no option to disable this conversion I have to offset my times?
The underlying data is all in MST. Why would Power BI be converting all of my times without me telling it to?
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.
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.