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
Hi,
There are no issues with the gateway or the connections.
The workspace type is Power BI Pro
Power BI Desktop reads the data source via DirectQuery from the Power BI semantic model dataset as screenshot attached
Could this be the root of the issue?
Thanks
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