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.
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
|
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.