Forum Discussion

zenisekd's avatar
zenisekd
Super User
1 year ago
Solved

Report displayed on TV with Direct Query stops refreshing after a while

Hi,  I have mede a 5 simple reports (all with simple queries, quering  for my customer, used direct query with change detection and each display on one screens (via PC with chromium web browser engi...
Need Help
  • Anonymous's avatar
    Anonymous
    1 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.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi zenisekd,

Thank you for reaching out in Microsoft Community Forum.

Thank you tharunkumarRTK , rohit1991  for the helpful response.

As suggested by tharunkumarRTK, rohit1991.,  I hope this information was helpful. Please let me know if you have any further questions or you'd like to discuss this further. If this answers your question, please "Accept as Solution" and give it a 'Kudos' so others can find it easily.

Please continue using Microsoft community forum.

Regards,
Pavan.