Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
gustalem
Helper I
Helper I

Dashboard Perfomance: Personal Workspace vs Shared Workspace

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 😞

1 ACCEPTED SOLUTION
v-yaningy-msft
Community Support
Community Support

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

View solution in original post

4 REPLIES 4
v-yaningy-msft
Community Support
Community Support

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
Super User
Super User

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.

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?

 

gustalem_0-1718716696993.png

 

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.