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

[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! 

[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 · Accepted solution]

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?

[v-pnaroju-msft]

Thankyou, @deborshi_nag for your response.

Hi ha729,

We appreciate your inquiry through the Microsoft Fabric Community Forum.

We would like to inquire whether have you got the chance to check the solution provided by @deborshi_nag  to resolve the issue. We hope the information provided helps to clear the query. Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.

Thank you.

[v-pnaroju-msft]

Hi ha729,

We are following up to see if what we shared solved your issue. If you need more support, please reach out to the Microsoft Fabric community.

Thank you.