Show current hour values

[toyota_carina]

Hi.

I'm getting some data using http request. Data contains values for every hour for current day. 

I want to refresh dataset just once a day to get all values, and every hour exact at 00 show values for current hour.

I've tried to create a measure  CurrentHour = HOUR(NOW(), a calculated column isCurentHour = IF([DataHour] = [CurrentHour]; 1; 0) and filter isCurrentHour = 1, but when I publish report I realized that I need to refresh a whole dataset, to make filter work. Measure works fine, but not filter. I also have tried to create a table Table = FILTER('Data;Data[DataHour] = HOUR(NOW())), but It was the same result, I needed to refresh dataset.

I could use scheduled refresh, but I have a free version, so I can't make it refresh 24 times for every hour. Also I don't like the idea of 24 unnecessary http requests, since data doesn't changes.

Is it something I can do to make it work?

Thanks

[v-huizhn-msft]

Hi @toyota_carina,

Even through you have pro license, it only limited schedule refresh 8 times a day. We can not let dataset refresh every hour. Please review the following feature request and vote it.

hourly refresh
New way to schedule refreshes

Best Regards,
Angelia

[toyota_carina]

So there is no way to make filter works dynamically? Measure refreshes when I refresh webpage, but I don't understand why FILTER('Data;Data[DataHour] = HOUR(NOW())) function doesn't work the same way, why I do need to refresh the whole dataset for that.. 

[v-huizhn-msft]

Hi @toyota_carina,

As I tested, I create two measure in my .pbix file.

Current_Time = NOW()
Hour of Current_time = HOUR(NOW())

I create two card visuals to display the measure. At first, it shows the following result.



After a while 10 o'clock, the measure didn't refresh automatically untill I click "refresh" buttom on the home page. It shows the latest time as follows.



Best Regards,
Angelia

[toyota_carina]

Hi, @v-huizhn-msft.

I know that measure value rerfreshes when "refesh" button is clicked or page is refreshed (F5). But if you will try to use measure to filter not DirectQuery dataset, page refresh will not help. You must refresh a whole dataset for that.
And it is wrong, it should be dynamic.
I've created a sample file on google drive CurrentHourTest.pbix for show what I mean.

I've created a table with hours and value columns. My goal is that this table filters when current hour changes. F.ex. if it's 2p.m. it dynamicly filters row where hour = 14, without refreshing whole dataset, because I already do have a data for every hour for current day. In example pbix I used 2 ways for accomplish that: 1.  create a new tabel using FILTER() function  and 2. create a new calculated column and filter by it.

But when I published this report, meause shows correct value and changes by refreshing page, but none of filters shows correct values next hours, until you refresh dataset.

Screenshot