Forum Discussion
Power BI report does not shows some visuals
- 4 months ago
Hi peternguyen2 ,
Thank you for your patience
The extra information you provided is very helpful and may indicate the root cause of the issue.
Since your report uses Direct Query to another Power BI semantic model (a chained or composite model setup), the problem may not be with the gateway itself. In Power BI Service, some visuals can fail in cases such as:
- Limitations related to composite models or chained semantic models
- Certain visuals generating queries that exceed Service or backend resource limits
- Build permissions or credentials not fully propagating across semantic models
Since only some visuals fail but refresh works, this suggests the semantic model query execution path might be failing for specific visuals, rather than a general connectivity problem.
Here are a few things to try:
Replace the failing visual with a simple table using the same fields or measures.
Check if the semantic model is hosted in a different workspace or capacity.
Make sure all users and the gateway connection have Build permission on the source semantic model.
If possible, import a small subset of data instead of using Direct Query to see if the issue is related to chained semantic model queries.
For more information please go through the documentations:
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models
https://learn.microsoft.com/en-us/power-bi/connect-data/service-datasets-build-permissions?
Best Regards,
Abdul Rafi
Hello peternguyen2
The report works in Power BI Desktop but some visuals fail in Power BI Service due to an OnPremiseServiceException.
common causes
Gateway timeout or outdated gateway
Heavy/complex DAX queries
Permission or RLS issues
Custom/unsupported visuals
Data type or null handling problems
Quick troubleshooting
Replace failing visual with a simple table visual
Test measures individually
Check gateway logs and update gateway
Simplify heavy DAX calculations
Verify permissions/RLS in Service
Since dataset refresh is successful and only some visuals fail, the issue is most likely related to query complexity or gateway execution in the Power BI Service.
If my response helped you, please consider clicking
Accept as Solution ✅ and giving it a Like 👍 – it helps others in the community too.
Thanks,
Connect with me on:
LinkedIn |
Data With Pankaj - YouTube
- peternguyen24 months agoFrequent Visitor
Hi Pankaj,
You may be correct that, “Since the dataset refresh is successful and only some visuals fail, the issue is most likely related to query complexity or gateway execution in the Power BI Service.”
I just wanted to add some more information:
Previously, the developer (who has since resigned) published the report using a Personal Gateway installed on his laptop, and the report worked well.
However, I have now published the report using an On-Premises Gateway, and the issue is occurring.
I also tested using a cloud connection, as the data source is from Kainexus (connected via API key), and the same issue still occurs.
Would this additional information help?
Thanks