Forum Discussion

SeanStayn's avatar
SeanStayn
New Member
9 years ago
Solved

Set local timezone in PowerBi Service with Direct Query

Hey,   I try to set the UTC time in PowerBi Service to a local timezone, without success.   There are some good tutorials, how I can set the timezone, like Power Query or something else. But all ...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi SeanStayn,

    I have saved the timezone offset in one table of my database, to know the offset in PowerBi Service, but I can't add the offset value, because most of the DAX functions are not compatible with the Direct Query mode. 

    Based on my test, you should be able to use the following DAX formula to add the offset value(assume it's 2) with DirectQuery mode in your scenario. :smileyhappy:

    Column = Table1[Date] + 2 / 24
--just replace 2 with the offset value

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi SeanStayn,

I have saved the timezone offset in one table of my database, to know the offset in PowerBi Service, but I can't add the offset value, because most of the DAX functions are not compatible with the Direct Query mode. 

Based on my test, you should be able to use the following DAX formula to add the offset value(assume it's 2) with DirectQuery mode in your scenario. :smileyhappy:

Column = Table1[Date] + 2 / 24
--just replace 2 with the offset value

 

Regards