Forum Discussion

Jvrhe's avatar
Jvrhe
Regular Visitor
1 year ago
Solved

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

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 u...
  • v-karpurapud's avatar
    1 year ago

    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