Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Get upstream datasets

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 req...
Need Help
frank-panosai's avatar
frank-panosai
New Member
1 year ago

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.