Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Direct Query UTC workaround

Hello,   I have what seems to be a unique issue as I haven't found an adequate solution anywhere on here after a couple hours of searching. This has to do with the UTC conversion that occurs on Pow...
Need Help
GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
9 years ago

Hi Anonymous

 

What I would suggest if your source is a SQL Server, why not change the source Date and Time to go back related to your specific timezone.


So if you are in GMT-6 then I would do a DateAdd(Hour,-6,MyDateTimeColumn)

 

So when that loads into Power BI Locally it will look incorrect, but when it is refreshed in the Power BI Service it should then reflect the right values?

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi GilbertQ,

 

Thank you for taking your time to respond. I did try to shift the time back against my date/time column.

The problem that ended up happening was that my relative time filters were then thrown off giving me some August data for September visuals. This is due to my date/time column always showing 12:00:00am, so any changes backwards sets me a day behind. This also led to a lot of measured monthly/daily goals being off slightly.

 

I really wish we could set a specific timezone within the service so it wasn't such a headache to make sure our desktop/service data reconciled.