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

Shreyash Choudhary 126 Reputation points
2023-03-07T14:08:48.5666667+00:00

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

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,316 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,444 questions
{count} votes

Accepted answer
  1. AnnuKumari-MSFT 30,361 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


0 additional answers

Sort by: Most helpful