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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
phinguyen
Regular Visitor

Power BI embedded show and load data slow when embedded on website

Hi all.

Now, i working on project using powerbi embedded, nodejs, database sql azure and webservice.

I using driect queries mode to get data from database for powerBI. When i tracking total time run queries, it very fast (about 700 millisecond) for 1500 record (queries include: join table, template table...) but when show powerbi embedded to website it show and loading data slow (20-30s)
Please give me ideas for improving performance of Power BI embedded when embedded on website

Thanks

2 REPLIES 2
Eric_Zhang
Microsoft Employee
Microsoft Employee

@phinguyen

As per my personal experience, things that would affect performance are

  1. When creating Power BI Embedded, select a location which is more close to your web server.
  2. Avoid using complicated query in DirectQuery mode. At this moment, DirectQuery are only supported to connect Azure SQL Database/DW. Based on test, the actual query sent from Power BI is not optimized which would stop the index in database used.

By the way, in your case, could you explain how you track the queries running time?

@Eric_Zhang

Thanks for answering me

i using query performance insight of azure, sqlserver to track queries and use fiddler 4 track time load web

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.