Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

Reply
m-colbert
Resolver II
Resolver II

REST API Dataflow Upstream Dataflows Not Working

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 Lea... 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

2 REPLIES 2
fabianoolvr
New Member

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.

glilly1
Frequent Visitor

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
[]
 

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.