Exporting All Fabric Workspace artifacts including (reports, dataflow, owners, last modified dates)

[Jadegirlify]

I'm inheriting a Microsoft Fabric workspace that’s already loaded with artifacts (reports, dashboards, metrics, semantic models, dataflows, lakehouses, warehouses, notebooks, etc.) and your job is to clean it up so that there are no duplications, and best practices are followed. How can I successfully/securely export all organizational workspace artifacts (list of reports/dashboard with all connected data sources, dashboards, datasets/semantic models, dataflows, warehouses, lakehouses, notebooks, etc.) including owners, last modified dates, permissions, refresh schedules and usage metrics into a spreadsheet/csv file?

[v-venuppu]

Hi @Jadegirlify ,

As we didn't heard from you, will proceed to close this thread.Please try to raise new thread in the community if you need any further assistance.We are happy to help.

Thank you.

[v-venuppu]

Hi @Jadegirlify ,

Can you please let us know the ETA or else please let us know if we are good to close this thread..?

Thank you.

[v-venuppu]

Hi @Jadegirlify ,

Could you please let us know the ETA by when you will be able to test the provided solution? This will help us to know when we can follow up. If you encounter any challenges during implementing the provided solution , please inform us and we’ll be glad to assist.

Thank you.

[v-venuppu · Accepted solution]

Hi @Jadegirlify ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @tayloramy for the prompt response.

There is no single button to export everything, but you can do this with the Fabric/Power BI Admin REST APIs. Using a simple PowerShell or Python script, you can loop through all workspaces and pull out reports, datasets, dataflows, lakehouses, notebooks, etc. along with metadata like owners, last modified dates, refresh schedules, permissions, and usage. The script then writes everything into a CSV/Excel file, giving you a full inventory of the workspace. From there, it’s much easier to clean up duplicates and apply best practices.

Here are few Documentations for your reference:
Admin - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Microsoft Fabric REST API references - Microsoft Fabric REST APIs | Microsoft Learn

[Jadegirlify]

Perfect. Will try this out. Thanks for the valuable feedback.

[tayloramy]

Hi @Jadegirlify,

I don't believe there is a nice way to export everything. 

I'd recommend making a new workspace, moving things over to that as you clean through them, and then once you've moved and organized everything, you can delete the old workspace.

If I helped, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution. 

[Jadegirlify]

Thanks for the feedback