Report performance: Premium workspace (shared vs dedicated)

[lukmtb08]

Dear all, 

we have a premium workspace with a report (all data is connected to dataflows which are getting data from Excel stored in SharePoint). Connection is Import. About 250.000 rows. We have a lot of measures in it. For example one "Switch"-measure with 500 lines of code. 

In Desktop, the performance is great. I have a developer PC. In Power BI Service, the report performance is very bad. Would it make a huge difference if we change our workspace from Premium shared, to Premium dedicated? 

Thank you!

[v-tangjie-msft · Accepted solution]

Hi @lukmtb08 ,

Refer this document , in general, a dedicated Premium workspace should provide better performance compared to a shared workspace, as it provides dedicated resources for a single tenant. This means that the resources are not shared with other tenants, which can lead to better performance and more consistent query response times.

However, the actual performance difference between a shared and dedicated workspace can vary depending on a number of factors, including the size of the dataset, the complexity of the report, and the number of concurrent users accessing the report.

In addition to optimizing capacity, optimizing data models, visualizations, network environments, metrics, etc. can optimize performance.

Please refer to the following documents for more information.

running out of resources - Microsoft Power BI Community

Slow loading of new page - Microsoft Power BI Community

Best Regards,

Neeko Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[lbendlin · Accepted solution]

 if we change our workspace from Premium shared, to Premium dedicated? 

There is no such thing. The maximum you can do is put your workspace on a higher Premium Capacity SKU (for example move from a P2 to a P3)

All capacities sit in shared clusters. The only difference is that Premium capacities have guaranteed resources (renderers and memory).  

[v-tangjie-msft · Accepted solution]

Hi @lukmtb08 ,

Refer this document , in general, a dedicated Premium workspace should provide better performance compared to a shared workspace, as it provides dedicated resources for a single tenant. This means that the resources are not shared with other tenants, which can lead to better performance and more consistent query response times.

However, the actual performance difference between a shared and dedicated workspace can vary depending on a number of factors, including the size of the dataset, the complexity of the report, and the number of concurrent users accessing the report.

In addition to optimizing capacity, optimizing data models, visualizations, network environments, metrics, etc. can optimize performance.

Please refer to the following documents for more information.

running out of resources - Microsoft Power BI Community

Slow loading of new page - Microsoft Power BI Community

Best Regards,

Neeko Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.