Forum Discussion
Power BI Workspace Error - User Session Limit Reached
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:
- Whether this is a Power BI-specific issue or related to the data warehouse?
- How to increase the session limit, or work around this limitation?
- Any tips for identifying and terminating inactive sessions safely to free up capacity?
Thanks in advance for your help!
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
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
4 Replies
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 DataHi 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
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
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