How to update time as report pulls time as UTC

[unclejemima]

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.

[v-caliao-msft · Accepted solution]

@unclejemima,

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