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

Question

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

Shreyash Choudhary 106

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

AnnuKumari-MSFT 21,086 Reputation points Microsoft Employee

2023-03-09T06:42:00.7833333+00:00

@Shreyash Choudhary ,

Just checking in to see if the below 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'
AnnuKumari-MSFT 21,086 Reputation points Microsoft Employee

2023-03-13T14:40:33.6433333+00:00

@Shreyash Choudhary ,

Just following up to see if the below 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'
PRADEEPCHEEKATLA-MSFT 56,301 Reputation points Microsoft Employee

2023-03-21T10:41:47.2433333+00:00

@Shreyash Choudhary - Glad to know that the below response was helpful. Thank you for marking this answer as accepted. This will help others find useful answers faster.

Please feel free to take a survey on the relevant answer. You can help us improve by leaving feedback verbatim.

Have a good day!

Regards,

PRADEEPCHEEKATLA-MSFT

AnnuKumari-MSFT 21,086 Reputation points Microsoft Employee

2023-03-09T06:42:00.7833333+00:00

@Shreyash Choudhary ,

Just checking in to see if the below 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'
AnnuKumari-MSFT 21,086 Reputation points Microsoft Employee

2023-03-13T14:40:33.6433333+00:00

@Shreyash Choudhary ,

Just following up to see if the below 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'
PRADEEPCHEEKATLA-MSFT 56,301 Reputation points Microsoft Employee

2023-03-21T10:41:47.2433333+00:00

@Shreyash Choudhary - Glad to know that the below response was helpful. Thank you for marking this answer as accepted. This will help others find useful answers faster.

Please feel free to take a survey on the relevant answer. You can help us improve by leaving feedback verbatim.

Have a good day!

Regards,

PRADEEPCHEEKATLA-MSFT

Answer 1

AnnuKumari-MSFT 21,086 Microsoft Employee

@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

Shreyash Choudhary 106 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 21,086 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 21,086 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'

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

0 additional answers

Activity