Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Data Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more

Reply
peternguyen2
Frequent Visitor

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.

Please check the technical details for more information. If you contact support, please provide these details.
  • 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

1 ACCEPTED SOLUTION

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

View solution in original post

7 REPLIES 7
v-moharafi-msft
Community Support
Community Support

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

v-moharafi-msft
Community Support
Community Support

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.

GilbertQ
Super User
Super User

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.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

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

 

peternguyen2_1-1778122504569.png

 


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

pankajnamekar25
Super User
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 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

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


Helpful resources

Announcements
Fabric Data Days is here Carousel

Fabric Data Days 2026

Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.

May Power BI Update Carousel

Power BI Monthly Update - May 2026

Check out the May 2026 Power BI update to learn about new features.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.