Dataflow metadata

[Jamestoz1010]

Is there anyway to extract all of the source tables and all of the published output tables for each dataflow quickly without having to manually go into each one?

[lbendlin]

Please specify if you mean dataflow Gen1, Gen2, or Gen2 CI/CD.

[v-sshirivolu · Accepted solution]

Hi @Jamestoz1010 ,
Thanks for reaching out to the Microsoft fabric community forum.

By using a PowerShell script (or alternatively, the Power BI Helper tool), users can automatically loop through all workspaces, retrieve each dataflow, and extract both the output tables (which are the entities in the dataflow) and their corresponding data sources. This eliminates the need for manual inspection and significantly speeds up the process—especially in environments with many dataflows or large datasets.

Whether you're an admin managing enterprise-level Power BI deployments or just someone trying to get a quick overview of your data architecture, this approach ensures you're getting exactly the information you need in a structured, repeatable way.

Please these official Microsoft documentation links

Register an application with the Microsoft identity platform
https://learn.microsoft.com/azure/active-directory/develop/quickstart-register-app

Register an application for Power BI REST API access
https://learn.microsoft.com/power-bi/developer/embedded/register-app

Power BI REST API Permissions Reference
https://learn.microsoft.com/power-bi/developer/embedded/power-bi-rest-api-permissions

If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it

Best Regards,
Sreeteja.
Community Support Team 

[v-sshirivolu]

Hi @Jamestoz1010 ,
Just wanted to check if you had the opportunity to review the suggestion provided?

If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.

[v-sshirivolu]

Hi @Jamestoz1010 ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and Accept it as the solution and give a 'Kudos'. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-sshirivolu]

Hi @Jamestoz1010 
Just wanted to check if you had the opportunity to review the suggestion provided? If so, please mark the helpful reply and Accept it as the solution . This will be helpful for other community members who have similar problems to solve it faster.