Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
@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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
6 | |
4 | |
3 | |
2 |
User | Count |
---|---|
14 | |
10 | |
5 | |
3 | |
3 |