Forum Discussion
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 ru...
As per my personal experience, things that would affect performance are
- When creating Power BI Embedded, select a location which is more close to your web server.
- 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?
Thanks for answering me
i using query performance insight of azure, sqlserver to track queries and use fiddler 4 track time load web