cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
cchilton
Frequent Visitor

Embedded Visuals - Slow Loading

Hello, 

 

My company is building a web app using embedded visuals. Each visual is stored in a different report. We are using the Power BI API to update visuals based on user selection. We are using Direct Query mode. Each visual is filtered based on selected start/end date and other metrics. 

 

Issues: 

  • There is a 12 - 11 second load time between when the API is called and when visuals begin to render
  • There is an additional 8 - 10 second load time between when the Power BI symbol appears and the full visual actually loads 

What I have tried: 

  • Query Caching - unavailable for Direct Query
  • Removed excess columns from fact table 
  • Microsoft Docs 
  • Performance Optimization in Desktop - visual renders in 485 ms with NO filters applied

 

Given that in the desktop app the load time is a fraction of a second what could be going on? Visuals also load quickly in the Power BI Service/Cloud. What else can I troubleshoot on my end? Could this be an issue with how the API is being called? 

1 REPLY 1
lbendlin
Super User
Super User

Are you on a Shared or Premium capacity?  Which data storage location? 

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.