Delete multiple assets in Purview

Anonymous
2022-04-08T11:07:29.707+00:00

Hello,

I have a collection in Purview with more than 700 assets that I want to delete. The problem is that I don't see any way to delete multuiple assets, I can only do it one by one, and deleting the collection is not also the solution because it has assets related.

I have found an option to move multiple assets to another collection, but not to delete it. Can you help?

Thanks,

Microsoft Purview
Microsoft Purview
A Microsoft data governance service that helps manage and govern on-premises, multicloud, and software-as-a-service data. Previously known as Azure Purview.
998 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Stefan Strube 10 Reputation points MVP
    2023-10-25T11:32:02.2733333+00:00

    I found out by navigating Microsoft Purview that it is possible to start a bulk delete of assets in the user interface. If you navigate to the level of SQL Server instance then the deletion of this entity type will delete the child items as well. See my blogpost: Bulk delete assets in Microsoft Purview via the user interface.
    And I've create a Power AUtomate flow to automate the deletion of assests in Microsoft Purview: Bulk Delete assets in Microsoft Purview with Power Automate flow.

    2 people found this answer helpful.
    0 comments No comments

  2. PRADEEPCHEEKATLA-MSFT 82,191 Reputation points Microsoft Employee
    2022-04-11T07:33:16.73+00:00

    Hello @Anonymous ,

    Thanks for the question and using MS Q&A platform.

    Currently, there is no way to delete multiple assets from the Purview UX.

    The only way to delete multiple assets from the catalog is through REST APIs.

    Steps to delete an Asset in Purview using REST API:

    From this document, follow the steps to Use the Postman client to call the REST APIs.

    Step1: Get Token

     POST https://login.microsoftonline.com/<your-tenant-id>/oauth2/token  
    

    100555-image.png

    Step2: How to find a guid of an asset in Azure Purview Studio. Select any asset and you will find the guid in the url section:

    156627-image.png

    Step3: Entity - Delete By Guid – Used to delete single asset by using associated Guid:

    Syntax: DELETE {Endpoint}/catalog/api/atlas/v2/entity/guid/{guid}

    Sample URL: DELETE {Endpoint}/catalog/api/atlas/v2/entity/guid/fd279eb4-f6c3-1b0b-ad67-e4f8abd2972f

    Step4: Entity - Delete By Guids – Used to delete mulitple asset by using associated Guid:

    Syntax: DELETE {Endpoint}/catalog/api/atlas/v2/entity/bulk?guids={guids}

    Sample:

    DELETE {Endpoint}/catalog/api/atlas/v2/entity/bulk?guids=[  
          
          "18e06957-e265-967a-07f1-e14e2ab8940f",  
          
          "cc0730ba-9b30-41f0-6953-559d17626d2b"  
          
        ]  
    

    Hope this helps. Do let us know if you any further queries.

    ------------------------------

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
    1 person found this answer helpful.