Forum Discussion
Top N with live connection
Assuming you have a hybrid streaming/push dataset as your data source.
Reports do NOT refresh automatically unless you use the new auto page refresh feature. CAVEAT: this may be limited to Direct Query connections.
Dashboards do refresh automatically.
You can pin any report visual to a dashboard, including a table visual.
Your TOPN filter would work with either a dashboard or a report set to auto page refresh.
Yes, I have a hybrid streaming/push dataset.
I created a report with a table and I used TOP N (TOP 1) filter then I pinned the table to a dashboard. It is work like a charme all day, but in the next day morning the TOP N does not refresh. For example, if at 23:55 the highest row_id 2815, then the next day in the table I can see in the dashboard only the rows with 2815 row_id, despite of there are 2816, 2817, ..., 3000 row_id.
Have you ruled out time zome issues? The service works on UTC.
https://radacad.com/solving-dax-time-zone-issue-in-power-bi
I don't think, that it is a time zone issue, because the highest row_id independent from the time zone.