Forum Discussion

phinguyen's avatar
phinguyen
Regular Visitor
9 years ago

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

Need Help

2 Replies

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee
    9 years ago

    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?

    • phinguyen's avatar
      phinguyen
      Regular Visitor
      9 years ago

      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