Forum Discussion

Jadegirlify's avatar
Jadegirlify
Icon for Helper I rankHelper I
1 year ago
Solved

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

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...
  • v-venuppu's avatar
    1 year ago

    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