Is the export feature currently available for data assets in Purview data catalog

Anonymous
2024-08-09T04:15:22.5933333+00:00

Hi,

Please confirm if there is an option available to export the entire Purview data catalog contents to an Excel sheet. Such as a list of assets in each collection for existing (registered) data sources in Purview.

Also, what are the steps required to generate the above export for all data assets in Purview?

Based on my testing, and information in the below article on Purview export (preview) feature, it is currently only possible to export one asset type at a time from the Purview data catalog.
Also, the Purview exports (currently preview feature) are limited to business assets only.

Refer to: https://techcommunity.microsoft.com/t5/security-compliance-and-identity/now-in-preview-export-your-business-assets-from-microsoft/ba-p/3859055

Thanks & regards, Tino.

Microsoft Security | Microsoft Purview

Locked Question. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
Answer accepted by question author
Anonymous
2024-08-09T09:56:08.19+00:00

Hi ,@Tino Giambattista

Currently, Microsoft Purview does not support exporting the entire data catalog contents to an Excel sheet in one go. The export feature is limited to business assets and allows exporting only one asset type at a time.

To export business assets from Purview, follow these steps:

  1. Navigate to the Purview Portal: Go to the collection containing the assets you want to export.
  2. Select Business Assets: Choose the asset type you want to export.
  3. Export: Use the export option to download a CSV file of your selected assets, including their GUIDs and the fields you chose to export

For more comprehensive exports, you might consider using the Purview REST API. This approach allows you to programmatically retrieve entity details and export them as needed.

for more details:

: Tech Community article on Purview export feature

: Microsoft Q&A on exporting entities from Azure Purview

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


If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Was this answer helpful?

1 person found this answer helpful.

1 additional answer

Sort by: Newest
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.


    Comments have been turned off. Learn more