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

Question

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

Answer 1

@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.