Forum Discussion
Page Refresh Enabled in Power BI Service.
I set the page refresh for every 1 second using direct query mode. The measure I am testing with is
I’ve done some testing, and a simple
NOW()function should work without issues. The key question now is: what type of capacity is your workspace using? If it’s on shared (non-premium) capacity, the minimum refresh interval is 30 minutes.Even if you have premium though, the minimum is what's been set by your admin.
3 Replies
- danextian
Super User
Hi PowerBIET
A DAX measure that uses NOW() alone won’t refresh unless the visual re-queries the source as the result is loaded from the cache which is when you inititally opened the page. The now value can change when you interact with other visuals by filtering or crossfiltering.
You can try forcing the visual to actually hit the data source even if you're just using it to show the time
Time = VAR dummy = MAX('YourDirectQueryTable'[ID]) -- any column from a DirectQuery table RETURN FORMAT(NOW(), "hh:mm:ss")Alternatively, you can simulate a live clock via iframe or JavaScript from an external source using a html visual.
I'm trying to get the report to refresh every 1 second in the Power BI service during an active session. The purpose of the clock is to prove it's working. What is the best to do this?
- danextian
I’ve done some testing, and a simple
NOW()function should work without issues. The key question now is: what type of capacity is your workspace using? If it’s on shared (non-premium) capacity, the minimum refresh interval is 30 minutes.Even if you have premium though, the minimum is what's been set by your admin.
