Power BI Embedded capacity optimisation for concurrent users

[JosephMurphy]

Hi,

We have created a power bi report which works fine in Desktop. However, as soon as we embed this using PowerBI embedded and do some load testing with 5 concurrent users, the report stops working (visual don't load, spinning bar). This occurs after a couple of minutes of all 5 users trying to quickly apply slicers at the same time. 

Please could someone advise on best practice for embedded configuration or if others have had a similar issue? 

Cheers

Joe

[v-prasare]

Hi @JosephMurphy, 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[v-prasare]

Hi @JosephMurphy,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[v-prasare]

Hi @JosephMurphy, 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

[JosephMurphy]

SKU F2. Is this is the correct configuration for the report I am embedding? Would Premium resolve the issue of concurrent users?

[tancha · Accepted solution]

The issue you're encountering with Power BI Embedded where reports stop loading and show a spinning bar after multiple users interact with slicers could be due to performance bottlenecks, especially when handling concurrent user requests. Here are a few best practices to improve performance for embedded reports:

1. Optimize your Power BI model: Ensure the data model is optimized. Large or complex models may slow down when multiple users interact with them.

2. Consider direct query mode: Instead of using import mode, you could use DirectQuery to reduce the load on the Power BI report server by querying the data source in real time.

3. Limit visuals and slicers: Too many visuals or slicers can strain the report's performance. Reducing the number or optimizing visuals may help.

4. Use Azure capacity for embedded reports: Make sure you are using an appropriate Azure Embedded Capacity SKU, as this can significantly improve performance under load.

For detailed guidance, refer to the article here: Power BI Best Practices