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.
rohit1991 Thanks for engaging.
So I just got more info, actually there are 9 TVs, each has its own refresh, with a change detection set for 5 seconds.
each has 7 simple card visuals. Any recommendations for settings?
The capacity is PPU. There are 9 reports, each having its own semantic model. But I am not sure, if the limitation is per semantic model or the data source?
Is there any on prem data gateway involved in between the datasource and Power BI? if yes then please check if you are hitting any limit from the gateway front.
there are different limits that you can tweak in order to get better results,
Max connections per datasource at semantic model level
Query parallelism
https://blog.crossjoin.co.uk/2023/03/19/directquery-parallelisation-in-power-bi-some-examples/
see if you can tweak them for better results. Also, I would also suggest you to look for possibilities to reduce the queries if possible one option that I can suggest is enabling auto aggregations
https://learn.microsoft.com/en-us/power-bi/enterprise/aggregations-auto
Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos.
Proud to be a Super User!
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.
