I've got a couple of questions:
1) How do you know that the last data refresh was 9am? Is that a value in the data or some other information?
2) What are you using for "...showing the last refresh on dashboard"? Is that the Last Refresh date that we can insert into titles/tooltips/etc., or some other date?
Based on that we can give you further guidance.
Thank you Jonathan for taking time to review...
-The refresh of the report is scheduled for 9am each business day, the date/timestamp of the file is usually in the 9:00-9:05am range
-Currently I am using the Last Refresh date to show on the dashboard, that is mentioned above, which is currently showing the time the dashboard is launched and not the time the data was refreshed that day