Forum Discussion
User Limit reached for Workspace
I started another thread because I'm having issues with my data warehouse (https://community.fabric.microsoft.com/t5/Data-Warehouse/Data-Warehouse-is-inaccessible-overnight/m-p/3927904#M966)
Half of my dataflows failed and the error message was "Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: DataSource.Error: Microsoft SQL: The user session limit for the workspace is 724 and has been reached."
I was wondering if they were related because theoretically, if the workspace is at "max users" then it wouldn't authenticate any more. But there's no shot that there's actually 724 users with active sessions in my workspace. I was hoping that you would say Microsoft was able to terminate all of the sessions.
Receating the workspace seems to be a common suggested solution by Microsofft... I'd probably spend an entire week rebuilding it, but that may be the path I have to head down. 😞
What we found worked as a temporary measure is creating a Lakehouse in a new area and creating Shortcuts to all tables in the unusable Warehouse / Lakehouse. Data is still there, it's just authentication that fails, so using shortcuts will make so the authentication happens at the other workspace / Lakehouse. This can help temporarily.
If you have Datasets connected to the previous Warehouse, you can do a rebind of the dataset to the new lakehouse. There's an API for that as Update DataSource.
That's a great solution, will try!