Forum Discussion
Report displayed on TV with Direct Query stops refreshing after a while
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.
tharunkumarRTK thanks for your helpful response.
This was the direction, that I needed. I managed to find, that ATM these are the current limits for PPU:
https://powerbi.microsoft.com/hu-hu/blog/power-bi-february-2024-feature-summary/
Also, since part of the visual was made in Deneb, we reworked the whole report there, so now there is just one query, which is sent to the source per report. The query is very simple, returning only small table with 16 rows.
We had some issues with the change detection, so we switched to automatic refresh every 5 seconds. Seems to be working fine now, with 9 reports (each on one screen), each having its own dataset (but a single source).
We will be probably adding more reports, so I will let you know if it works fine.
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.