TIMEZONE PowerBI service problem (Google Analytics)

[Ankit_1987]

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 Today()-1, function in DAX formula to fetch yesterday data. The problem is, at the power BI service for auto refresh, it shows inconsistent data as compared to my desktop report beacuase of the timezone issue..my report is in PST but service I guess is in UTC. How do i resolve this ??

[Ankit_1987 · Accepted solution]

Hi @v-shex-msft,

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

[v-shex-msft]

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

[Ankit_1987 · Accepted solution]

Hi @v-shex-msft,

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

[v-shex-msft · Accepted solution]

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