How can I delete a custom data source protocol created via the API?

Doug Fisher 1

Hi,

I created a custom data source protocol using a POST to https://api.azuredatacatalog.com/catalogs/{0}/dataSourceProtocols?api-version=2016-03-30

I now need to delete it, but I am getting the following error:

The remote server returned an error: (400) Bad Request.

ProtocolError
{"error":{"code":"ImmutableViewItem","message":"View item cannot be updated or deleted because the underlying type 'Microsoft.DataCatalog.TypeSystem.DataSourceProtocol.1' is immutable."}}

Once a custom protocol has been created, is it possible to update or delete it? There are no assets currently registered referencing this protocol.

Thanks!

KranthiPakala-MSFT 46,502 Reputation points Microsoft Employee

2020-09-01T00:25:55.187+00:00

Hi @Doug Fisher ,

Welcome to Microsoft Q&A platform and thank you for using this forum.

As per the official documentation and from the error message you have shared, it seems to be not possible to update/delete the custom data source protocol.

I have also reached out to internal team to confirm on the same. Will keep this thread posted as soon as I have confirmation from the team.

Thank you for your patience.
KranthiPakala-MSFT 46,502 Reputation points Microsoft Employee

2020-09-02T22:45:12.753+00:00

Hi @Doug Fisher ,

Were you able to check from ADC Portal for its existence and attempt to delete? Note: Catalog Administrator / Power BI Pro License user able to see all the Data Asset(s) by searching “*”

Please let us know if you were able to do it from Portal.

Thank you
Doug Fisher 1 Reputation point

2020-09-03T04:00:51.12+00:00

Hi @KranthiPakala-MSFT thanks for your response and your suggestion.

I am able to view and delete all assets (including tables, containers, etc) linked to my custom data source via the ADC portal, but I cannot find anything in the ADC portal that represents the custom data source itself.

Thanks
KranthiPakala-MSFT 46,502 Reputation points Microsoft Employee

2020-09-05T00:32:46.167+00:00

Hi @Doug Fisher ,

Thanks for your response and confirmation. I am still awaiting a response from internal team on this query. Will keep this thread posted as soon as I have response from the team.

Thank you for your patience.
KranthiPakala-MSFT 46,502 Reputation points Microsoft Employee

2020-09-09T21:30:10.937+00:00

Hi @Doug Fisher ,,

Sorry for the delay in response and thank you for your patience.

After having conversation with internal team, it should be possible to delete a custom data source protocol, so this sounds like a bug.

For deeper investigation and immediate assistance, If you have a support plan you may file a support ticket, else could you please send an email to AzCommunity[at]Microsoft[dot]com with the below details, so that we can enable a one-time-free support for you to work closely on this matter.

Email subject: <Attn - Kranthi : Microsoft Q&A Thread title>
Thread URL: <Microsoft Q&A Thread>
Subscription ID: <your subscription id>

Please let me know here once you have share the details.

Looking forward to your response.

Thank you
KranthiPakala-MSFT 46,502 Reputation points Microsoft Employee

2020-09-14T06:33:13.597+00:00

Hi @Doug Fisher ,

Following up to see if you have got a chance to file a support request regarding the above issue? In case if you do not have a support plan, please feel free to email the details requested in my previous comment.

Please let me know here once the email is sent.

Thank you

Share via

How can I delete a custom data source protocol created via the API?

Your answer