Forum Discussion
Report displayed on TV with Direct Query stops refreshing after a while
- Anonymous1 year ago
Hi zenisekd,
Thank you for reaching out in Microsoft Community Forum.
Please follow below steps to resolve the error;
1.Switched from Change Detection to Automatic Page Refresh (every 5 seconds).
2.Rebuilt visuals using Deneb to minimize queries — now each report issues just one simple query (~16 rows).
3.Each report uses its own semantic model but connects to a common data source.
4.Confirmed PPU capacity limits, and optimized setup to stay within those thresholds.
Please continue using Microsoft community forum.
If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.
Regards,
Pavan.
Hi zenisekd
This usually happens because DirectQuery dashboards on TV screens run in a browser session that times out if there’s no user activity. Change detection helps, but Power BI also limits how often queries can run (around 10 per second per dataset, depending on Pro or Premium). With the same report open on five screens, those queries add up quickly.
A couple of things you can try:
- Run the browser in kiosk mode and disable sleep so the session doesn’t drop.
- Increase the refresh interval a bit or reduce duplicate report views.
- If you need a more stable setup, look at push datasets or Power BI Embedded, since they give better control for continuous displays.