topic REST API Dataflow Upstream Dataflows Not Working in Developer

REST API Dataflow Upstream Dataflows Not Working

m-colbert — Fri, 14 Apr 2023 21:07:09 GMT

I have dataflows that reference other dataflows. I am building out a data lineage tool, but the REST API Dataflows - Get Upstream Dataflows In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn does not return any results. All I ever get is

{
  "@odata.context": "http://wabi-us-north-central-e-primary-redirect.analysis.windows.net/v1.0/myorg/groups/#########/$metadata#upstreamDataflows",
  "value": []
}

This is regardless of if the dataflows reside inthe same or different workspace. Has anyone gotten this to work?

The dataflow-dataflow lineage is never shown in the Power BI service either.

Thanks

Re: REST API Dataflow Upstream Dataflows Not Working

glilly1 — Wed, 01 May 2024 14:30:31 GMT

I'm having the same issue. Calling Get Upstream Dataflows in Group referencing a Dataflow that I know has a connection to another dataflow returns 'value[]'. This API Call is not working. What is the resolution??

Using this method in Python:

result = requests.get('https://api.powerbi.com/v1.0/myorg/groups/' + {groupId} + '/dataflows/' + {dataflowId} + '/upstreamDataflows')

print(result.content.value)

Empty

[]

Re: REST API Dataflow Upstream Dataflows Not Working

Anonymous — Sun, 02 Jun 2024 02:10:26 GMT

Same issue here as well.

I see no point restricting the Dataflows - Get Upstream Dataflows In Group response to the same group. It's more useful to retrieve the upstream dataflow regardless if it is in the same group or not (like the Datasets - Get Dataset To Dataflows Links In Group ).

I hope Microsoft ajusts the implementation of this endpoint or, at least, create another one following this view.

I think I found a way to workaround this limitation... using the Get Dataflow API it's possible to find the "upstream dataflows ids" inside the value of the "document" field (it's the string following a "dataflowId =" ). It's not pretty, but I think it'll do the job.