Forum Discussion
Solved
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 ac...
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.
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