Forum Discussion

ipon70's avatar
ipon70
Helper I
3 years ago

Display Server Refresh Schedule on Report

I would like to know if there is a way to display what the server refresh schedule is, kind of like the "Last Refresh" code but to show "how often this happens".  

 

EXAMPLE:  Server is set to refresh each hour, the visual should show "Every 1 hour(s) and 0 minute(s), starting 7/13/2023 at 12:00 AM". 

 

Any help would be great.

 

Need Help

1 Reply

  • aj1973's avatar
    aj1973
    Community Champion
    3 years ago

    Hi ipon70 

    there should a column in your fact Table of your dataset that indicates time of data update. Use it. you can then count how often it happens using DAX.