Get dataset hierarchy

[anambedoya]

Hi all! I'm trying to generate a token (https://learn.microsoft.com/en-us/rest/api/power-bi/embed-token/generate-token) to embed the Wall boards - Recruitment report in the web. We have the following structure:

As you can see, the Recruitment Wallboards dataset uses the Recruitment dataset. Right now, the API to get the report (https://learn.microsoft.com/en-us/rest/api/power-bi/reports/get-reports-in-group) is throwing only the Recruitment Wallboards dataset so the API to generate the token fails. Is it possible to get the master dataset through an API?

Thank you!

[Anonymous]

Hi @anambedoya ,

Thanks for reaching out to us with your problem. Base on your description, it seems that you want to get the involved dataset and master dataset info of the report. You can follow the steps below to get it:

1. Get the own dataset of the report by the following REST API:

Reports - Get Reports In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Datasets - Get Datasets - REST API (Power BI Power BI REST APIs) | Microsoft Learn

GET https://api.powerbi.com/v1.0/myorg/datasets

2. Get data sources by REST API Datasets - Get Datasources

Datasets - Get Datasources - REST API (Power BI Power BI REST APIs) | Microsoft Learn

GET https://api.powerbi.com/v1.0/myorg/datasets/{datasetId}/datasources

Please note that you need to have the appropriate permissions (Dataset.ReadWrite.All or Dataset.Read.All) to use these APIs.

In addition, please review the following thread. Hope its solution can give you some insights or thoughts.

Solved: Data Lineage. can you connect up to the meta data - Microsoft Fabric Community

Metadata and Lineage from Power BI | Microsoft Learn

Best Regards

[anambedoya]

I'm still unable to get the dataset id of the master dataset. The datasourceId returned in the second API doesn't correspond to the datasetId I need to put in the get embedded token request.