Dashboard Perfomance: Personal Workspace vs Shared Workspace

[gustalem]

Hello everyone!

Just a quick question. I tryied to find out how to improve the perfomance of my dashboard. 
The last week, a colleague shared me a dasboard from a personal, and it works very well. 

I tryied to share my own dashboard in my personal area, and I could see how the perfomance of my dashboard in my personal workspace, was better than the same dashboard in a shared premium workspace.

What's the difference about the perfomance between the areas? I've already read the Microsoft guides about workspaces, and still don't get it 😞

[Anonymous · Accepted solution]

Hi, @gustalem 

First, thanks for @lbendlin reply. The performance of a dashboard in Power BI can be influenced by several factors, including the workspace type (personal vs. shared), the capacity it's hosted on, and the specific configurations or features enabled in each workspace.

Personal workspaces vs. shared premium workspaces:

1. Personal workspaces typically run on shared capacity unless specifically assigned to Premium capacity by a capacity administrator. Shared Premium workspaces, on the other hand, run on dedicated Premium capacity. While Premium capacities offer dedicated resources which generally improve performance, the actual performance can vary based on the overall load and resource utilization of the Premium capacity. If the Premium capacity is heavily utilized, you might experience slower performance compared to a less burdened shared capacity. 
Manage your Fabric capacity - Microsoft Fabric | Microsoft Learn

2. Shared Premium workspaces are designed for collaboration and may contain more content (reports, dashboards, datasets) than personal workspaces. The increased content and number of users accessing this content can impact the loading times and overall performance of dashboards within these workspaces.

3. There might be differences in the configuration and features enabled in personal vs. shared Premium workspaces. For example, certain optimizations and settings available in Premium capacities, such as Auto-scale, can affect performance. Additionally, personal workspaces might have fewer data refreshes and less complex datasets, contributing to faster performance.
Using Autoscale with Power BI Premium - Power BI | Microsoft Learn

Steps to Improve Dashboard Performance in Shared Premium Workspaces:

1. Ensure that your reports and dashboards are optimized for performance. This includes minimizing the number of visuals on a page, using aggregations, and optimizing your data model. 
Optimization guide for Power BI - Power BI | Microsoft Learn


2. Monitor and Manage Premium Capacity: Regularly monitor the utilization of your Premium capacity and consider redistributing workloads or resizing the capacity if necessary. 

3. Check the configuration of your shared Premium workspace and adjust settings for optimal performance. This might include managing dataset refresh schedules to off-peak hours and reviewing the usage of features like paginated reports or large datasets.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[lbendlin]

You need to provide more information.  Which cluster is the Premium capacity on?   Usually Premium workspace perform better than shared workspaces but it is possible that the network location of your premium capacity is less favorable for you.

[gustalem]

Hi @lbendlin, thank you for your answer!

I don't know how to find out it, but I took a look in settings on my workspace and it says: "Premium capacity". Is that you asked?

[lbendlin]

Looks like you are using a PPU (Premium Per User).   Check which cluster that is on.