Get Dataflow ID from datasource/gatewayID

[smpa01]

My dataset URL is following

//pseudo URL for datset
https://app.powerbi.com/groups/22504304-f1e7-4503-8fdf-8c029ae5e24e/datasets/5f6c3de9-3559-4f5a-8884-871ef0ed3bce

I have the followng two dataflows in the above dataset

//pseudo URL
https://app.powerbi.com/groups/22504304-f1e7-4503-8fdf-8c029ae5e24e/dataflows/66a51eae-0d1e-4c84-a63e-e7747e595937

https://app.powerbi.com/groups/22504304-f1e7-4503-8fdf-8c029ae5e24e/dataflows/4a9c6855-3de5-4942-88e4-e8ba66e72e66

when I make Get Datasources REST call

GET https://api.powerbi.com/v1.0/myorg/datasets/22504304-f1e7-4503-8fdf-8c029ae5e24e/datasources

it returns gateway and datasource id for each of dataflows. How can I utilize any of these info any other REST calls that would return me the dataflow IDs - 66a51eae-0d1e-4c84-a63e-e7747e59593 and 4a9c6855-3de5-4942-88e4-e8ba66e72e66.

I don't have access to any admin APIs.

Thank you in advance.

[v-xiaoyan-msft · Accepted solution]

Hi  @smpa01 ,

The Power BI REST API provides programmatic access to the report server catalog. However, it does not provide a direct way to retrieve the dataflow IDs from the datasource IDs.

The datasource ID returned by the REST call is specific to the dataset and not directly related to the dataflow ID. The dataflow ID is unique to the dataflow and is used to identify it in the Power BI service. GET Datasources

If you have the dataflow URLs, you can extract the dataflow IDs directly from the URLs. In your case, the dataflow IDs are and .66a51eae-0d1e-4c84-a63e-e7747e5959374a9c6855-3de5-4942-88e4-e8ba66e72e66

Unfortunately, without access to admin APIs, there’s no direct way to map the datasource IDs to the dataflow IDs using the Power BI REST API. You might need to maintain a separate mapping of datasource IDs to dataflow IDs in your application.

Best regards.
Community Support Team_Caitlyn