Forum Discussion

Ankit_1987's avatar
Ankit_1987
Helper I
8 years ago
Solved

TIMEZONE PowerBI service problem (Google Analytics)

Hi community, I am writing this after going through all the possible solutions posted, could not get it done.   I have brought data from Google Analytics into power bi desktop, and I am using Toda...
Need Help
  • Ankit_1987's avatar
    Ankit_1987
    8 years ago

    Hi Anonymous,

    Thanks for the revert. I get what you're saying. The problem with using UTCTODAY is, I have metrics coming from many different sources and everything is in PST. So it doesn't make sense to compare stuff which are different timezones. 

    Up until this point I am avoiding to convert everthing else in UTC. So looking for a way to convert just this one thing to PST.

    Thanks

  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi Ankit_1987,

     

    As I said, power bi service not support dynamic visual graph based on user location and language.
    Maybe you can consider to add TIMEZONE offset to user information table will dynamic RLS based on username.

     

    Refernece link:

    RLS with UserName()

     

    After these steps, you can use related timezone offset as parameter of calculation to fix user timezone issue.

     

    Regards,

    Xiaoxin Sheng

Ankit_1987's avatar
Ankit_1987
Helper I
8 years ago

Hi Anonymous,

Thanks for the revert. I get what you're saying. The problem with using UTCTODAY is, I have metrics coming from many different sources and everything is in PST. So it doesn't make sense to compare stuff which are different timezones. 

Up until this point I am avoiding to convert everthing else in UTC. So looking for a way to convert just this one thing to PST.

Thanks

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Ankit_1987,

 

As I said, power bi service not support dynamic visual graph based on user location and language.
Maybe you can consider to add TIMEZONE offset to user information table will dynamic RLS based on username.

 

Refernece link:

RLS with UserName()

 

After these steps, you can use related timezone offset as parameter of calculation to fix user timezone issue.

 

Regards,

Xiaoxin Sheng