Hi @ShaikMaheer-MSFT , i am facing issue when i am trying to delete linked service from a branch. the linked service is related to 0 item (datasets) when tried to delete its giving error message saying "the document cannot be deleted since it is reference by datasetname . make sure to publish any changes to dependent resource as they may have been committed but not yet published." I already deleted all the related resources which is pointing to the linked service, so it's related to 0, then why it's giving error while deleting its?? also, i can't publish it says its only possible from collaboration release branch. How to delete linked service then from the branch? please provide any solution? i am using azure synapse analytics. Thanks

@Shreyash Choudhary , Thankyou for using Microsoft Q&A platform and thanks for posting your query here. As I understand your issue, you are experiencing error "The document cannot be deleted since it is reference by datasetname" while trying to delete the linked service from ADF workspace,however, you have already deleted all the reference resources. Please let me know if that's not the issue. It seems that you might have deleted all the related resources like dataset associated with this linked service from the collaboration branch , not from the adf_publish branch. Could you please switch to the GIT mode to live mode to verify if the dataset is really deleted from the published branch or not. Once you ensure that the related resources are deleted from the publish branch as well. Create a new collaboration branch and delete the linked service from this branch and then, merge this change to the main branch and publish it. Hope it helps. Kindly let us know how it goes. Thanks

How to delete linked service from branch [ISSUE Not able to delete]

Accepted answer

AnnuKumari-MSFT 33,716 Reputation points Microsoft Employee

2023-03-08T08:58:48.32+00:00

@Shreyash Choudhary ,

Thankyou for using Microsoft Q&A platform and thanks for posting your query here.

As I understand your issue, you are experiencing error "The document cannot be deleted since it is reference by datasetname" while trying to delete the linked service from ADF workspace,however, you have already deleted all the reference resources. Please let me know if that's not the issue.

It seems that you might have deleted all the related resources like dataset associated with this linked service from the collaboration branch , not from the adf_publish branch. Could you please switch to the GIT mode to live mode to verify if the dataset is really deleted from the published branch or not.

Once you ensure that the related resources are deleted from the publish branch as well. Create a new collaboration branch and delete the linked service from this branch and then, merge this change to the main branch and publish it.

Hope it helps. Kindly let us know how it goes. Thanks
Please sign in to rate this answer.
Shreyash Choudhary 126 Reputation points

2023-03-09T06:52:00.83+00:00

Hi @AnnuKumari-MSFT,

i checked in live mode linked service & dataset is still there !

yes i deleted all the related resources like dataset associated with this linked service from the branch (don't know if its collaboration branch or the adf_publish) .

but it should,t give error while deleting linked service when its not related to any dataset in any branch!!

any solution?

AnnuKumari-MSFT 33,716 Reputation points Microsoft Employee

2023-03-09T11:47:19.8733333+00:00

Shreyash Choudhary ,

If you can see the datasets in live mode, it means the changes are not published.

If you are unable to publish the previous changes then kindly go for the below steps:

Create a new local branch. Probably you will see the dataset in this branch.

Delete the dataset first and then delete the linked service from this local branch.

Merge it to the main branch and publish the changes.

Please let me know if you face any challenges executing the above steps. Thanks

AnnuKumari-MSFT 33,716 Reputation points Microsoft Employee

2023-03-14T04:50:34.5966667+00:00

@Shreyash Choudhary ,

Just following up to see if the above answer helped. Please do consider clicking Accept Answer as accepted answers help community as well. Also, please click on Yes for the survey 'Was the answer helpful'

Grégoire MANSIO 0 Reputation points

2024-10-23T13:33:22.19+00:00

Hello,
I have the exact same issue: I am trying to delete a GBQ legacy LinkedService after having deleted its pipelines and datasets. Up to that point, everything is fine and is published seamlessly.
Now, when I want to delete this remaining GBQ linked service, and publish, the error below pops up. Still, this dataset is referenced nowhere in my live code (workspace-publish.json).

I tried the above solution (new_branch, delete, merge then publish) but the same error occurs.

Please help

Error code: DeleteDataFactoryResourceOrchestrationError Inner error code: DeleteDataFactoryResourceOrchestrationError Message: The document cannot be deleted since it is referenced by DS_GoogleBigQuery.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

How to delete linked service from branch [ISSUE Not able to delete]

0 additional answers

Your answer