Forum Discussion

ashmitp869's avatar
ashmitp869
Icon for Responsive Resident rankResponsive Resident
2 years ago
Solved

DateTime.LocalNow() not showing correctly in PBI Service

Hi All,

 

My Reporting when refreshing in PBI service, giving me two Data Time.

 

When check from Date Updated 

 

 

Whereas I have created a Last Refresh DateTime in my app, showing me UTC time.

How can I change this to Local Time in Power Bi Service.

 

 

I have change the date in Power bi Desktop

 

 

 

Need Help
  • arvindsingh802's avatar
    arvindsingh802
    2 years ago

    On Service DateTime.LocalNow() will give you the time of the timezone on which your Power BI tenant is hosted
    You can use 

    =DateTimeZone.SwitchZone(DateTimeZone.LocalNow(),-5,0)

     Updated the parameteres as per your requirement

1 Reply

  • arvindsingh802's avatar
    arvindsingh802
    Icon for Community Champion rankCommunity Champion
    2 years ago

    On Service DateTime.LocalNow() will give you the time of the timezone on which your Power BI tenant is hosted
    You can use 

    =DateTimeZone.SwitchZone(DateTimeZone.LocalNow(),-5,0)

     Updated the parameteres as per your requirement