Unable to delete Shared Query in Fabric SQL Database

[ha729]

As title says, I am unable to delete a particular Shared Query in Fabric SQL Database. For reference I am the query owner.

Please find a screenshot and error message attached

Below is the error message

Update query failed. The user is not the query owner and cannot edit the un-shared query.
Correlation ID: 95318b3f-5294-4ed1-9458-2fb58b5ad4b8
Root Activity ID: 8b6a194f-14eb-42a4-a060-6716bb5a0943
Status: 403
Error Code: SqlDbNative.QueryPersistence.MyQueryUpdateForbiddenNonOwner
Type: Api
Source: User

[ha729]

I followed the steps you provided t check the current owner for the shared query and these options don't exist - there is no Manage permissions under the Shared Query area.

[deborshi_nag]

Can you check the ellipsis (...) next to the parent i.e. the Warehouse and see who's the Owner? 

Could you also try moving the shared query by clicking "Move to My Queries" and then try deleting it?

[deborshi_nag]

Hi @ha729 

The error code SqlDbNative.QueryPersistence.MyQueryUpdateForbiddenNonOwner indicates that, even though you were the original creator, the query has been shared, and now Fabric does not consider you the current owner. Sharing locks the ownership context, and any modification (including deletion) requires the current “query owner” permission.

Since you no longer have "query owner" rights, you have two pragmatic options:

1. Duplicate the Query & Delete Unshared Copy

   • Create a new version of the query under your ownership.
   • Leave the shared version untouched, then delete your new unshared one when no longer needed.

2. Change Ownership or Permissions

   • Ask a workspace Admin (or current owner) to either:
     • Revoke the share and reassign ownership back to you, or
     • Delete the shared query entirely.

You can also check who is the current owner for the shared query.

• Navigate to your workspace.
• Locate the shared query (often under Shared Queries).
• Click the ellipsis (…) next to the query and choose Manage permissions (or Manage access).
• In the list of users/groups and their permissions, the entry marked as Owner identifies the current owner.

Hope this helps - please appreciate leaving a Kudos or accepting as a Solution!