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