Forum Discussion
How to update time as report pulls time as UTC
I've got my report to use "is today" in its criteria.
I want to update at 6pm MST to give end of day reporting.
Problem 6PM is also 12AM next day UTC. So the report shows zero data.
If I update at 5:30PM MST its 11:30PM UTC so that will show proper "TODAY" data...but our day in the office does not end until 6:00PM MST so the data is incomplete.
Any idea's? Would be great if the Power BI didn't report on UTC time. I mean if I update 6:00PM MST it should use those times in its reporting.
By default, Power BI use UTC time when viewing report in Power BI Services. We can convert the UTC time to local time in Power query. I have tested it on my local environment.
Regards,
Charlie Liao
1 Reply
- v-caliao-msft
Microsoft Employee
By default, Power BI use UTC time when viewing report in Power BI Services. We can convert the UTC time to local time in Power query. I have tested it on my local environment.
Regards,
Charlie Liao