Forum Discussion
Manipulating Date/Time
I have a PowerBI report that interacts with a SharePoint list. My flows and report works without issue, but I'm having problems with my date/time not displaying correctly. My values are the same across the report and SP (Date/Time), but I can't figure out why I'm 6 hours off when I import into BI. I've tried changing my data type in my BI to include Timezone, but this had no effect on my values.
This is because the date/time is stored in UTC time on the back end, which is what Power BI gets when it pulls the data. You can add hours to it in the query editor to convert to your time.
7 Replies
This is because the date/time is stored in UTC time on the back end, which is what Power BI gets when it pulls the data. You can add hours to it in the query editor to convert to your time.
So, my values are displaying correctly in my Table view, but any ideas why my time isn't changing in my actual report. My value is the same as my uncalculated date. The only change I've made is using the Calculated Column Date and Enddate.
If you take the CustomDate measure and add it to a new card visual, will the issue persist?
To help me understand your issue better, which platform is reflecting the correct Date/Time (your actual time), the one in sharepoint or on desktop?
The SharePoint is displaying the correct Date/Time JohnnySaade
As christinepayton mentioned you can manipulate the datetime in a power query function, to do it add a custom column with the following:
[Date]+#duration(0,-6,0,0)
This function will deduct 6 hours of your Date column therefore fixing the issue
Thanks to JohnnySaade and christinepayton . That resolved my issue
