Data Refresh, how to fix the NOW() issue

Hi everyone, 

I have a dashboard whose goal is to measure the time difference between the dates I get via an sql query in Direct Query and the current time I get with the NOW() function. The issue is, once published we can update the dashboard (and therefore the value returned by now) only every hour.

I don't know if it is possible to have a real time update of the NOW() function or if it exists an other option.

I thought of another idea that could be a solution: use a database that contains a row for each minute and retrieve the maximum value from this database via a direct sql query that would replace the now function. Do you know if there is such a database or if there is another solution to my problem?

Hoping to have been clear.
Thanks in advance !