Forum Discussion
TIMEZONE PowerBI service problem (Google Analytics)
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
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:
After these steps, you can use related timezone offset as parameter of calculation to fix user timezone issue.
Regards,
Xiaoxin Sheng
Hi Ankit_1987,
You can try to use UTC now as calculated parameter, current service still only support UTC date.
Time in PBI Service is inconsistent with the local time (non-UTC time) displayed in PBI Desktop
Power BI Desktop February Feature Summary
Regards,
Xiaoxin Sheng
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
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:
After these steps, you can use related timezone offset as parameter of calculation to fix user timezone issue.
Regards,
Xiaoxin Sheng