UniversalSecurityClientUserException – SQL Analytics Endpoint stuck on "Unexpected error encountered

Hi MarcusTrinder ,

The UniversalSecurityClientUserException on the SQL Analytics Endpoint typically indicates a metadata/security sync failure between the Lakehouse and its auto-generated endpoint not a data issue. Here are the steps that usually resolve it:

1. Force a full endpoint sync via REST API
The pipeline activity may not trigger a deep sync. Try calling the Fabric REST API directly:

POST https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/lakehouses/{lakehouseId}/tables/loadAll
Or use the "Refresh" button directly from the SQL Endpoint item in the workspace (not from a pipeline).

2. Check if the issue is user-specific
Test with another account that has workspace Admin or Member role if the endpoint opens for them, the issue is specific to your user's security token propagation.

3. Verify capacity state
If your Fabric capacity was paused/resumed recently, security context tokens may not have re-synced. Try pausing and resuming the capacity from the admin portal.

4. Check for known issues
Visit the Fabric service health page and the Known Issues tracker for any active incidents related to SQL Endpoint.

5. If nothing else works
Open a support ticket and include the correlation ID from the error (usually visible in browser DevTools → Network tab when the error fires). This helps Microsoft Engineering trace the exact sync failure.

Let me know which step resolves it.