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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.