Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Refresh Schedule Date

Hello, I have a problem and need your inputs. Just to capture the dataset's last refresh date, I have created a blank query with code = DateTime.Time(DateTime.LocalNow()) & DateTime.Date(DateTime.Lo...
Show and Tell
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Anonymous,

     

    There existing some gap for the time zone displayed in Power BI Service. The time zone in the service is effectively always set to UTC. So, you need to add the timezone offset to local time.

     

    Here is a similar thread, please refer to the suggestion to modify the code for last refresh date:

    Last Refresh of Data

     

    Best regards,
    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi Anonymous,

 

There existing some gap for the time zone displayed in Power BI Service. The time zone in the service is effectively always set to UTC. So, you need to add the timezone offset to local time.

 

Here is a similar thread, please refer to the suggestion to modify the code for last refresh date:

Last Refresh of Data

 

Best regards,
Yuliana Gu

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi v-yulgu-msft

     

    This seems to be proper work around to add hours from UTC. I will give it a try and will update here how it goes but I really appreciate your time in this matter.

     

    Thank you!

    Harshad