Forum Discussion
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 correctly and the report refreshes successfully, some visuals are not displayed.
Below is the detailed error:
Error fetching data for this visual
Couldn't retrieve the data for this visual. Please try again later.
- Underlying Error OnPremiseServiceException
- Activity IDaf4d9a5d-6f64-42ef-b407-44159215bed6
- Correlation IDc1c2f75c-4608-2b2d-16b6-2c79e8b061fb
- Request IDb8436d43-0f47-4ac6-9a5c-172aa87d7e9b
- TimeWed May 06 2026 16:20:01 GMT+1200 (New Zealand Standard Time)
- Service version13.0.28233.53
- Client version2604.3.28959-train
- Cluster URIhttps://wabi-australia-east-b-primary-redirect.analysis.windows.net/
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
7 Replies
- pankajnamekar25
Super User
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 problemsQuick 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 ServiceSince 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 - YouTubeHi 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
- GilbertQ
Hi peternguyen2
From your observation it appears that you are having an issue connecting to the underlying data source. I would recommend logging onto the on premises gateway and making sure that you can successfully connect to the data source first. Once that is done you can then try and recreate a connection to see if that will then work. Once that works you should then be able to map it back to your power BI semantic model.
Hi,
There are no issues with the gateway or the connections.
The workspace type is Power BI ProPower 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
v-moharafi-msftCommunity Support
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
- v-moharafi-msft
Hi peternguyen2 ,
Thank you for reaching out to Microsoft Fabric Community and Thanks to pankajnamekar25 and GilbertQ for Sharing valuable insights.
Just wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.Best Regards,
Abdul Rafi.
- v-moharafi-msft
Hi peternguyen2 ,
Could you please confirm if the issue has been resolved? If not, feel free to reach out if you have any further questions.
Your update would be helpful for other members who may face a similar issue.
Best Regards,
Abdul Rafi
