Share via

How to export Power BI data asset from Microsoft Purview to CSV files

Chee Koon Chwa 40 Reputation points
Aug 30, 2024, 8:22 AM

Hi,

I would like to export the list of my Power Bi data assets (focusing on Power BI dataset and Power BI report) from Microsoft Purview to csv file for business owner to perform an audit and review for clean-up activities. I read from the article it required SDK to perform the export, but i would like to know is there any more simple and easy way to do so?

Thank you.

Regards,

CK

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.
1,347 questions
{count} votes

Accepted answer
  1. PRADEEPCHEEKATLA 90,506 Reputation points
    Aug 30, 2024, 11:40 AM

    @Chee Koon Chwa - Thanks for the question and using MS Q&A paltform.

    Microsoft purview supports exporting Data Assets using the REST API.

    Exporting Data Assets from Microsoft Purview using the REST API in Python enables a streamlined process to retrieve structured metadata and asset information. By leveraging the REST API and Python, users can effortlessly access and export Data Assets, ensuring a programmatic and efficient approach. The powerful combination of the REST API and Python empowers users with flexibility and automation capabilities, facilitating the extraction of Microsoft Purview Data Assets and seamless integration with various data management and analytics workflows.

    For more details, refer to Exporting Microsoft Purview Data Assets using the REST API and Exploring Purview’s REST API with Python.

    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.

    1 person found this answer helpful.

1 additional answer

Sort by: Newest
  1. Chee Koon Chwa 40 Reputation points
    Oct 17, 2024, 12:18 AM

    Hello,

    I have another question related to the how to export Power BI data asset from Microsoft Purview to CSV files from my earlier post.

    My question:

    1. Can we export also Business Glossary using the restful API? This refers to use the RESTFUL API to extract the data from Purview together with all of the Power BI data asset and Business Glossary in one single CSV.

    Thank you.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.