topic Re: Power BI embedded show and load data slow when embedded on website in Developer

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

phinguyen — Thu, 23 Mar 2017 17:26:50 GMT

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

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

Eric_Zhang — Sat, 25 Mar 2017 07:03:11 GMT

@phinguyen

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?

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

phinguyen — Sat, 25 Mar 2017 11:34:14 GMT

@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