Forum Discussion
Top N with live connection
Hi! I use live connection, the datasets refresh every 5 minutes. I would like to display the data in a table, so I turn on the "analysis of historical data" in the dataset settings. (If I not turn...
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.