Forum Discussion
Helper IExporting 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 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?
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 LearnMicrosoft Fabric REST API references - Microsoft Fabric REST APIs | Microsoft Learn
7 Replies
- tayloramy
Super User
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.
JadegirlifyThanks for the feedback
v-venuppuCommunity Support
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 LearnMicrosoft Fabric REST API references - Microsoft Fabric REST APIs | Microsoft Learn
- Jadegirlify
Perfect. Will try this out. Thanks for the valuable feedback.
- 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
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 ,
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.
