Power BI Embedded performance issue

Anonymous — Tue, 17 Sep 2019 11:27:36 GMT

Hi,

Recently, I've embedded PowerBI embedded in our own application. I have a report that I embed with 6 visuals on it that do not contain crazy amounts of data. (loads instantly on desktop.)

Every 10 minutes we run an automated task that checks for activity in the last 2, if this is not the case then we Suspend the PowerBI service. When the service is suspended and there is activity, we start the service back up after which we embed the beforementioned report. In the morning the starting of the service is about 30 seconds and loading/rendering the report is also 30 seconds, this is within acceptable standards.

After a few times of shutting down and starting up however, this goes up to 50 seconds for starting the service and almost 2 minutes for rendering/loading which is simply unacceptable, especially if this is going to have to be implemented for hundreds of customers.

If anyone could help me out with this performance issue I would be much obliged.

Thanks in advance!

EDIT: Added pictures below to show where the biggest bottlenecks are.

Not entirely sure what this does, maybe something with authentication.

Loading the 1.6kb conceptualschema for 46 seconds seems unacceptable.

querying for data for 20+/- seconds seems acceptable to me.

topic Power BI Embedded performance issue in Developer

Power BI Embedded performance issue