Forum Discussion
ADLSv2 some Shortcuts fails with "Not authorized" message using same connection
I have this "MyLakehouse" Lakehouse with several shortcuts pointing to my Azure Datalake Storage V2 storage, most of my almost 100 shortcuts works pretty fine but there are 4 shortcuts that suddenly fails.
Data source errorCOM error: Azure.Storage.Blobs, Error in Stored Credential Operation - {"error":{"code":"ArtifactConnection_InsufficientPermission","pbi.error":{"code":"ArtifactConnection_InsufficientPermission","details":[{"code":"ArtifactConnection_InsufficientPermission","detail":{"type":1,"value":"User does not have sufficient artifact permission Read to perform the artifact connection operation."}}],"exceptionCulprit":1}}}. Status: 401 (Unauthorized) ErrorCode: Unauthorized Content: <?xml version="1.0" encoding="utf-8"?> <Error> <Code>Unauthorized</Code> <Message>Error in Stored Credential Operation - {"error":{"code":"ArtifactConnection_InsufficientPermission","pbi.error":{"code":"ArtifactConnection_InsufficientPermission","details":
When checking the SQL Endpoint for this fails, I can see this error:
But, other tables in the same storage using same connection works pretty fine..
Any idea?
Okay, this is solved now.
The MS Support Team just droped and create the shortcuts, one by one.
According their explanation, they deleted the shortcuts, wait for several minutes until some kind of cache is refreshed then recreate the shortcut again.
I performed that procedure before raising the case to MS Support but I did not wait any time after the delete.
Now is working again.
8 Replies
Hi Jarrinf,
Thank you for reaching out to the Microsoft fabric community forum.
This error usually comes when the user or connection used for the shortcut doesn’t have proper access to the folder in your Azure Data Lake. The message “ArtifactConnection_InsufficientPermission” means the read permission is missing for those particular folders.
Since other shortcuts are working fine, please check if the permissions for these 4 folders are different or if the stored credentials might have expired. Make sure the same user or service principal used in Fabric has Read and List access on those folders.
After fixing the permissions, refresh the shortcut connection and try again. It should start working.
Let me know if you still face the issue after checking this.
Regards,
Community Support Team.Hello, thanks for your reply.
Folders seems okay, I dropped and create them again, now the shortcuts seems good but the sql endpoint for those tables no. Look at this:
This is the SQL Endpoint
And this is the shortcut
The error in the endpooint shows an error:
When I try to resync, (using an admin account), it just raise a DatamartUserNotAuthorized message.
Hi Jarrinf,
The error “DatamartsUserNotAuthorized” usually happens when the user doesn’t have the required permission to refresh or manage the SQL endpoint. Please make sure that the account being used has either Contributor or Admin access in the Fabric workspace. If the access is correct, try refreshing the schema from the SQL endpoint once. In some cases, this error can also appear due to a temporary sync issue between the Lakehouse and its SQL endpoint.
If the issue continues, please confirm if there were any recent workspace permission or role changes so we can help check further.
Regards,
Community Support Team.
Murtaza_GhafoorSuper User
You can also test access by opening the same shortcut paths through the Synapse SQL Endpoint using the same credentials.
If the request returns a Bad Request error, that typically indicates a permission issue on the storage side.Next, try the “Check Access” feature in Azure Storage Explorer to confirm whether your account or service principal has the required rights for those folders or files.
Finally, it’s a good idea to review the Azure Activity Logs to see if there have been any recent “Deny” entries or access-related events for that storage account.
- Nabha-Ahmed
Hi
The error clearly indicates a permission issue, not a shortcut or SQL Endpoint problem:
pgsql:ArtifactConnection_InsufficientPermissionUser does not have sufficient artifact permissionRead Status: 401 UnauthorizedEven though other shortcuts work, these specific folders/files in your Azure Data Lake do not have the required READ permissions for the Fabric connection/service principal.
How to fix:
Go to Azure Storage Account → Containers → Folder/File of the failing shortcut.
Open Access Control (IAM).
Ensure the Microsoft Fabric Managed Identity / Service Principal has at least:
- Storage Blob Data Reader
- Reader (optional but recommended)If using ACL permissions (DFS), also check folder-level permission:
Right-click folder → Manage ACL
Give Fabric identity:
Read
Execute (needed to access folder path)
Refresh the shortcut in Lakehouse.
