List Dataflows REST API returns nothing even though I have dataflows

[brittade]

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. Doc links and examples below: 

https://learn.microsoft.com/en-us/rest/api/fabric/dataflow/items/list-dataflows?tabs=HTTP

returns 

for both service principal with Contributor access, and the owner of the workspace with Dataflow.ReadWrite.All enabled for the app registration used. 

List items : 

https://learn.microsoft.com/en-us/rest/api/fabric/admin/items/list-items?tabs=HTTP

also doesn't return the dataflow. I have 1 Gen2 and 1Gen1 in this workspace. 

I did not see this in known issues. Is there a way to fix this?

[v-agajavelly]

Hi @brittade ,

Just checking in were you able to make any headway with the dataflow APIs? I know it’s a bit tricky right now with the split between Gen1, Gen2, and CI/CD support. Happy if you found a workaround or if you're still hitting that limitation. Happy to help dig further if needed.

Regards,
Akhil.

[brittade]

I was able to get the dataflows by using a combination of the power bi apis and the fabric APIs. Thanks!. 

[v-agajavelly · Accepted solution]

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.

[v-agajavelly]

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]

@v-agajavelly 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?