Forum Discussion

brittade's avatar
brittade
Frequent Visitor
1 year ago
Solved

List Dataflows REST API returns nothing even though I have dataflows

I have tried this API endpoint with both a service principal and the user owner of the workspace and nothing is returned. Additionally, the dataflows don't appar in the list items response either. Do...
workspaces
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi brittade ,

    You're right currently, there's no single API that returns all dataflows, especially Gen2 CI/CD dataflows.

    • The Fabric Dataflow API supports Gen2 CI/CD.
    • The Power BI Dataflow API supports Gen1 and non-CI/CD Gen2.
      But neither covers all types together, and this isn’t clearly documented yet.

    It seems like this is a limitation for now likely a work in progress. Hoping Microsoft consolidates this soon into a unified endpoint.

    Regards,
    Akhil.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi brittade ,

Just a quick check before we go deeper.

  • Has the service principal been explicitly added to the workspace?
  • What kind of error or response are you getting — is it just an empty "value": [], or something else?
  • Also, do you have Admin access to the workspace where the dataflows are located.

But let's confirm the setup first before ruling anything out. Let us know.

Regards,
Akhil.

  • brittade's avatar
    brittade
    Frequent Visitor
    1 year ago

    Anonymous responses below. 

     

    • Has the service principal been explicitly added to the workspace?
      • yes, contributor access as previously mentioned, and i also tried the owner/admin user and that doesn't work either.
    • What kind of error or response are you getting — is it just an empty "value": [], or something else?
      • empty value: [] see image in my original post for the example output.
    • Also, do you have Admin access to the workspace where the dataflows are located.
      • my user does, and I just moved the service principal to admin access on the workspace as well, this doesn't work either.

     

    After some more testing, it seems that the fabric dataflows apis only work on Gen2 CI/CD. For Gen1 and non-CI/CD Gen2 the power bi dataflow APIs work, but they do not return the Gen2 CI/CD dataflows. I'm not finding this information in the docs, is this a work in progress, will we eventually be able to list all dataflows from a single API endpoint?