Forum Discussion

JorgeK's avatar
JorgeK
Regular Visitor
8 years ago

Latest refresh date on scheduled dataset

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.

General Comment

5 Replies

  • JorgeK's avatar
    JorgeK
    Regular Visitor
    8 years ago

    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

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    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. :smileyhappy:

     

    Regards

    • JorgeK's avatar
      JorgeK
      Regular Visitor
      8 years ago

      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's avatar
        v-ljerr-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        8 years ago

        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. :smileyhappy:

         

        Regards