UpsteamDatasets property in Dataset is empty. How to get them?

[Jvrhe]

Hi, I'm trying to get the upstream datasets to embed a PowerBI Reports with Direct Query.
Without the upstream datasets I'm unable to embed the reports.

When I look up the specific dataset, the upstreamDatasets property is empty.

How do I get the upstream datasets? I'm 100% sure these reports have a upstream dataset, because in the PowerBI online environment I can see the relations. But somehow they don't show up here.

See:
https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/get-dataset-in-group#code-try-0

[v-karpurapud]

Hi @Jvrhe 

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.

Thank you.

[v-karpurapud]

Hi @Jvrhe 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-karpurapud]

Hi @Jvrhe 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-karpurapud · Accepted solution]

Hi @Jvrhe 

Thank you for reaching out to the Microsoft Fabric Community Forum.

The issue you're experiencing with the Get Dataset In Group REST API endpoint returning an empty array for upstream datasets may occur if the dataset isn't a composite model, the upstream datasets aren't in a supported lineage format, or the dataset hasn't been refreshed recently enough.

The REST API you're using (Get Dataset in Group) doesn't fully capture all upstream lineage information, especially in complex or composite models. Instead, use the Get Lineage API, which is designed to show complete upstream/downstream relationships.

Additionally, if your report connects to a dataset from a different workspace, this won’t be reflected as an upstream dataset in the same workspace call. In such cases, use the report's workspace ID in the Lineage API. It will show the connected dataset from the other workspace too.

If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.

Thank you