Get upstream datasets

[Anonymous]

Hi,

is it possible to get all the upstream datasets/core models of a certain dataset/proxy model via the power bi rest API

cause we need to add all the related datasets in the generate token request for a certain reportID and not only the directly connectected datasets to that report?

thanks

[frank-panosai]

According to support, there is currently no direct way to get all upstream datasets of a specific model.

The default embedding of reports for customers fails as well because of this without modification, e.g. especially in Power Pages, because the upstream datasets are not retrieved and passed to generate the embedding token.

Workarounds:
1. Call Admin - WorkspaceInfo PostWorkspaceInfo - REST API (Power BI Power BI REST APIs) | Microsoft Learn with lineage = true, then get the result with Admin - WorkspaceInfo GetScanResult - REST API (Power BI Power BI REST APIs) | Microsoft Learn and lookup the data set which will have a upstreamDatasets property

2. Call Datasets - Get Datasources - REST API (Power BI Power BI REST APIs) | Microsoft Learn for your workspace and data set -> you get the list of datasources by name, which you could use to filter the datasets in the group and get the respective id

3. Merge everything into a single direct lake/query/import source type model.

[lancetki]

I need this too, please add this Microsoft!

[Amarquez]

I know that this is from over a year ago, but I now have the same problem. Have you had any luck on resolving this?