Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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.
Solved! Go to 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
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