Refresh Schedule Date

[Anonymous]

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.LocalNow()) And scheduled teh refresh time at 7:30PM under time zone (UTC+05:30) - Mumbai, India.

The last refresh time shows at desktop is correct i.e. 7:30PM but on the published dashboard its showing 2:00 PM i.e. the gap of 4:30 hrs.

Could you please advise what setting I am missing or which time the server is taking? I think with the local desktop the function DateTime.Time(DateTime.LocalNow())  is getting correct local time but with published server its not getting the correct time though I have scheduled under time zone (UTC+05:30) - Mumbai, India. 

Please advise

Thanks!

[v-yulgu-msft · Accepted solution]

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]

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

[Anonymous]

Hi @Anonymous,

Check this:

• https://www.excelguru.ca/blog/2016/06/08/display-last-refreshed-date-in-power-bi/