Latest refresh date on scheduled dataset

[JorgeK]

Hi guys,

I currently have a dataset with a scheduled refresh four times a day.

On the report, I have created a "Last Refresh Date" table that displays the most recent refreshed date and time.

But somehow, the date on the report is not refreshed accordingly to the refresh of the dataset.

I have published the report on the 22nd of September, and the date stamp is on the 25th of September, which means it has updated at least once. I have refreshed the dataset again manually, yet the date hasn't changed, although the data has been updated.

Any solution on this one?

Thanks in advance

/********************************************************************************************************************************/

To update on this note,

It seems like when I update the dataset, it's feeding a previous date with a inaccurate time to the visual....

Why is it doing that?

= DateTime.Time(DateTime.LocalNow()) & DateTime.Date(DateTime.LocalNow())

This is the code that I have.

[v-ljerr-msft]

Hi @JorgeK,

According to your description above, I have tested it on my environment. And I can show the correct latest refresh date time on the report with the same solution. 

Have checked the refresh history to see if every refresh was successful?

In addition, also make sure you're using the latest version of Gateway. 

Regards

[JorgeK]

Hi @v-ljerr-msft,

I have checked again just now, but it still isn't showing the right data.

It seems like my Refresh_Date table in the dataset is showing 9/27/2017 8:05:43 PM, not 9/28/2017, 9:07:42 AM.

[v-ljerr-msft]

Hi @JorgeK,

A little weird. Is it possible for you to share a sample pbix file which can reproduce the issue, so that I can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. 

Regards

[Anonymous]

Has there been a solution to the issue?

I have the same, last refersh shows only the time of scheduled refresh, however, when I refresh the data set manually in power bi service, it is not reflected in "last refresh" table

thanks!

[JorgeK]

Hi guys,

I currently have a dataset with a scheduled refresh four times a day.

On the report, I have created a "Last Refresh Date" table that displays the most recent refreshed date and time.

But somehow, the date on the report is not refreshed accordingly to the refresh of the dataset.

I have published the report on the 22nd of September, and the date stamp is on the 25th of September, which means it has updated at least once. I have refreshed the dataset again manually, yet the date hasn't changed, although the data has been updated.

Any solution on this one?

Thanks in advance