topic Re: Powerbi report taking 20 plus seconds to embed in our web app in Report Server

Powerbi report taking 20 plus seconds to embed in our web app

nuthanm — Thu, 17 Jun 2021 09:46:24 GMT

We embed powerbi report in our web app using reactjs library and .NET powerbi sdk.

To get all reports we call the GetReportsInGroupAsync method and it is taking more than 8 seconds.

- Get an instance of powerbiclient

- Get workspace details using the same powerbiclient

- Get Reports based on workspace using the same powerbiclient

Next thing what we did here is,

When a user clicks on the link from UI we initiated a new API call to get embedded report details,

1. From the above response we take reportId and called a new endpoint to get embed token and URL details.

2. Get an instance of powerbiclient

3. Get workspace details using the same powerbiclient

4. Get the desired report based on reportId along with workspace

5. Pass this report details to get embedded token

For all the above operations report took more than 16 seconds to load.

Note: Even I tried reducing powerbiclient and workspace endpoints from two to one call but even though it is taking time to load.

Is there any way to optimize this to less than 8 seconds? If yes please help me.

Re: Powerbi report taking 20 plus seconds to embed in our web app

v-deddai1-msft — Mon, 21 Jun 2021 06:28:17 GMT

Hi @nuthanm ,

Here are some suggestions for your reference: https://docs.microsoft.com/en-us/power-bi/developer/embedded/embedded-performance-best-practices

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

Re: Powerbi report taking 20 plus seconds to embed in our web app

nuthanm — Mon, 21 Jun 2021 11:31:36 GMT

@Anonymous

Thanks for the reference Link.

Just for your information in detailed stats,

I ran each individual methods using swagger to see how many seconds it took to complete and get response for each one

1. GetReportsInGroupAsync - taking around 3 seconds

2. DataSets.UpdateParametersInGroupAsync + Reports.GenerateTokenInGroupAsync - When we hit the first time it took around 20 seconds and after immediate request it is giving less than 10 seconds.

Note:

Our report is light weight with less data and our SLA is in 8 seconds to load.

Currenlty we have one report inside workspace.

We enabled QueryCaching and Large Dataset Storage format but still taking more time.

Re: Powerbi report taking 20 plus seconds to embed in our web app

v-deddai1-msft — Tue, 22 Jun 2021 05:16:20 GMT

Hi @nuthanm ，

I suggest you have a look in the Power BI Portal and the metrics for your embedded instance. Your can also use the premium metrics app to see whats going on. It does work with Embedded instances as well.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai