Relative time showing UTC format in PBI report having live connection to DirectLake semantic model

[Anonymous]

Hi,

I have created a Power BI report with live connection to DirectLake semantic model, there I want to use page level filter of Relative time of 24 hours in ET timezone but in Power BI Service it is taking by default UTC timezone which is showing incorrect data to us as the data coming from source is in ET timezone so, we are missing to show some records because of filter doing realtive time of last 24 hours in UTC timezone.

Please help me in any workaround or solution to handle this problem of doing Last 24 hours for ET timezone in my live connection report where we can't create any calculated columns also.

Thanks.

[SaiTejaTalasila · Accepted solution]

Hi @Anonymous ,

You can refer this articles -

https://radacad.com/solving-dax-time-zone-issue-in-power-bi

https://www.myonlinetraininghub.com/change-type-using-locale-with-power-query

Thanks,

Sai Teja 

[lbendlin]

as the data coming from source is in ET timezone 

Doesn't sound like it is. You probably have a datetime field, not a datetimezone field.   correct that and specify which timezone the dates are coming from.  Ideally your source dates would already be in UTC so you wouldn't need to worry about all this.