Forum Discussion

Jamestoz1010's avatar
Jamestoz1010
New Member
1 year ago
Solved

Dataflow metadata

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

    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