Forum Discussion

peternguyen2's avatar
peternguyen2
Frequent Visitor
4 months ago
Solved

Power BI report does not shows some visuals

Hello Community, My Power BI Desktop shows all the visuals correctly. However, after publishing the report to the Power BI Service, although the On-Premises Gateway and connections are configured c...
  • v-moharafi-msft's avatar
    v-moharafi-msft
    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