Power BI Workspace Error - User Session Limit Reached

[Anonymous]

Hi all,

I'm encountering an issue with my Power BI workspace that's preventing me from accessing data stored in SQL tables from a DataWarehouse. The error message I am receiving is the following one:

The user session limit for the workspace is 724 and has been reached.  
Changed database context to 'DW_NAME'.  
Changed language setting to us_english 

From what I can gather, it seems like the session limit for the data warehouse or the workspace has been exceeded.

To provide a little bit of context about the workspace, it contains 2 DataWarehouses that are used to provide data to several PBIs. These Data Warehouses have SQL tables that receive new rows several times a day when a user completes a form and a Power Automate flow inserts the form results into a table.

I've been using this system for half a year and I've never encountered this issue.

Has anyone experienced this issue before? If so, could you provide guidance on:

1. Whether this is a Power BI-specific issue or related to the data warehouse?
2. How to increase the session limit, or work around this limitation?
3. Any tips for identifying and terminating inactive sessions safely to free up capacity?

Thanks in advance for your help!

[Expiscornovus · Accepted solution]

Hi @Anonymous,

I have seen this issue on this forum before, in the below thread:

https://community.fabric.microsoft.com/t5/Service/User-Limit-reached-for-Workspace/m-p/3786779

My suggested approach would be to contact Microsoft support about this, like suggested in that thread as well.

https://admin.powerplatform.microsoft.com/newsupportticket/powerbi

[Jonvoge · Accepted solution]

Hi ikesil

In the past, this has been known to be caused by sessions not being shut down properly on capacities.

You may need to file a support ticket for help on restarting the capacity.

See the following thread on the subject: Solved: Re: The user session limit for the workspace has b... - Microsoft Fabric Community

_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.
Find me on LinkedIn, Sessionize, or my blog Downhill Data

[Anonymous]

Hi @Jonvoge 

Thank you for the quick response and for pointing me in the right direction! I guess I have no other choice but to restart the capacity.

Also, thanks for sharing the thread—I'll review it for additional insights.

Best regards,
Ikesil

[Expiscornovus · Accepted solution]

Hi @Anonymous,

I have seen this issue on this forum before, in the below thread:

https://community.fabric.microsoft.com/t5/Service/User-Limit-reached-for-Workspace/m-p/3786779

My suggested approach would be to contact Microsoft support about this, like suggested in that thread as well.

https://admin.powerplatform.microsoft.com/newsupportticket/powerbi

[Anonymous]

Hi @Expiscornovus 

Thank you for sharing the thread and the link to contact Microsoft Support. I’ll review the discussion you mentioned and follow up with support as recommended.

Your guidance is very helpful—thanks for taking the time to assist!

Best regards,
Ikesil