How does the workspace work?

[Anonymous]

Hi all,

I know the subject is really vague but please hear me out.

I know that one power bi workspace can have about 1000 reports. I also understand that reports in import mode are much faster than the other two options. Assuming we have about 300 reports with different data sources in different modes (live or import etc) and about 100 active users using them at about the same time. I have heard from the users the reports are slow. We have tested individual reports and they seem to be working fine. but when the above scenario occurs it is slow for everyone. 

My question is how does the workspace handle multiple reports with multiple active users accessing it at the same time? I m just trying to get my head around it.

(Note: Yes, I know the reports need to be optimized and all that. Assume everything is optimized already.)

[v-xiaotang · Accepted solution]

Hi @Anonymous 

Using reports in the workspace is the same as operating on capacity.

This is how it works

What is Microsoft Power BI Premium? - Power BI | Microsoft Docs

Besides, it is also related to the type of capacity.

What is Microsoft Power BI Premium? - Power BI | Microsoft Docs

Best Regards,

Community Support Team _Tang

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

[Anonymous]

Hi There,

Not sure if the Workspace issue as per the details below it should be able to handle it. 

But you can explore another option by using the Deployment Pipeline https://docs.microsoft.com/en-us/power-bi/create-reports/deployment-pipelines-overview very easy option to create another workspace and keep it synced and divide the Groups based on the requirement or discussion in your organization. 

Cheers
Mahak