topic Re: Get upstream datasets in Developer

Get upstream datasets

Anonymous — Thu, 13 Apr 2023 15:04:53 GMT

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

Re: Get upstream datasets

Anonymous — Wed, 21 Aug 2024 15:36:54 GMT

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?

Re: Get upstream datasets

lancetki — Fri, 30 Aug 2024 09:14:48 GMT

I need this too, please add this Microsoft!

Re: Get upstream datasets

frank-panosai — Tue, 04 Feb 2025 11:38:40 GMT

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.