Forum Discussion

AndrewDang's avatar
AndrewDang
Helper IV
9 years ago

Set local time zone Power BI Service

Hello all;   I have an issue with setting the right local time for my Power BI Service. I have the same measure to pull the current time. My Power BI desktop file pulls up 1/16/2017 4:36:02 PM whic...
Need Help
nirvana_moksh's avatar
nirvana_moksh
Impactful Individual
8 years ago

wont this return a date time relative to when the refresh for the data was ran from the SQL side?

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Nope, the folks at power bi (Microsoft) dont support anyway to refresh the service in any other time zones,  Only UTC time.  So, a filter for relative date of today, gives us today in UTC time, not the other 23 time zones.  I have seen many forums and requests to have this fixed with no reply, nor suggestions to get around it.

 

I finally found a way myself but had to add date adjustments and realtive time and adjust like crazy to outsmart the BI service.

 

It seems like a world wide problem that has yet to be addressed and communicated to the community.  A simple setting in the service to refresh in a specific time zone on the service would be the simplest way