Power BI Desktop to Service Time Zone Issue

[jamezcua9]

Hello,

I'm having issues with publishing report to the Power BI service and the my last refresh date changes to UTC/CET time as the service server resides in Netherlands.  I have a WTD metric in which the WTD target increases over the week on each day and increases after 5pm scheduled refresh.

WTD=IF(CALCULATE(VALUES(DimCalendar[WeekOfYearNumber]),DimCalendar[DDate]=TODAY(),ALL(DimCalendar[DDate]))=DimCalendar[WeekOfYearNumber]&&DimCalendar[DDate] <=TODAY(),1,0)

WTD = IF(CALCULATE(VALUES(DimCalendar[WeekOfYearNumber]),DimCalendar[DDate]=TODAY(),ALL(DimCalendar[DDate]))=DimCalendar[WeekOfYearNumber]&&DimCalendar[DDate] <=TODAY(),1,0)

[v-yulgu-msft]

Hi @jamezcua9 ,

To deal with the date time zone problem in Power BI desktop and service version, you can refer to:

Display Last Refreshed Date in Power BI

Solving DAX Time Zone Issue in Power BI

Create a column in Power BI for last refresh date

Best regards,

Yuliana Gu

[jamezcua9]

Hi @v-yulgu-msft 

None of the options mentioned actually worked for me.  Need additonal suggestions?