The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
I have embedded multiple Power BI dashboards on my website. However, when multiple end users try to access the dashboards simultaneously, they experience significant delays in loading. I have verified that the dashboard performance is generally fast, and I have implemented incremental refresh, RLS methods, and have only 4 to 5 visuals with several filters. I am using Pro licenses.
Hi, @momo2208
Ensure your data models are as efficient as possible. Remove unnecessary columns and tables, and simplify relationships. Review your DAX formulas to ensure they are optimized. Complex or inefficient DAX can slow down performance.Simplify visuals where possible. Complex visuals with many data points can slow down loading times. You can refer to the following link:
How to Improve Power BI Performance Issues: Tips and Best Practices - Monocroft
You can also use caching to reduce load times. This can help improve performance for frequently accessed reports. You can check the following link:
How to Improve Performance in Power BI - Zebra BI
Consider migrating your semantic model to Azure Analysis Services to increase query throughput. If feasible, upgrading to Power BI Premium can provide more resources and better performance for concurrent users.Use the Power BI Desktop Performance Analyzer to identify and address specific performance bottlenecks.
Troubleshoot report performance in Power BI - Power BI | Microsoft Learn
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
and I have implemented incremental refresh, RLS methods,
Those are not relevant for the user experience (unless your RLS DAX is slow).
Which capacity SKU are you running on?
We are using PRO capacity and RLS method is important for us.
There is no performance guarantee on the shared capacity.
User | Count |
---|---|
3 | |
2 | |
2 | |
2 | |
1 |
User | Count |
---|---|
4 | |
3 | |
2 | |
2 | |
2 |