Forum Discussion
Unknown Gateway and Datasource Id's in Admin - Datasets GetDatasourcesAsAdmin API Response
6 Replies
Hi afernand0,
The datasourceId and gatewayId values in the response from the GetDatasourcesAsAdmin API for Dataflows do not directly correspond to on-premises data gateway IDs or dataflow IDs. Instead, these are system-generated internal identifiers used by Power BI’s service to manage and track data connections. The datasourceId represents the data source connection for the dataset, but for Dataflows, it does not match the actual GUID of a Dataflow and instead refers to an internal mapping. Similarly, the gatewayId does not necessarily correspond to an on-premises data gateway but rather an internal Power BI Cloud Gateway or Fabric connector that facilitates the connection. The response’s connectionDetails typically show "kind": "PowerPlatformDataflows", confirming that this data source is tied to Power BI’s Dataflow architecture rather than an on-premises system.Hey rohit1991 , thanks for your AI generated comment which is rephrasing my question instead of answering it. I was hoping someone could shed some light on how to translate those 'virtual' ids to 'real' dataflow ids, so I can get the end-to-end lineage of a dataflow but it doesn't look like it's possible.
HI afernand0,
Perhaps you can try to use following rest api to get data flows from specific workspace group:
Dataflows - Get Dataflows - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Regards,
Xiaoxin Sheng
Hi afernand0 ,
Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.
If these also don't help, please share more detailed information and description to help us clarify your scenario to test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
afernand0
I believe the API you're looking for is https://api.powerbi.com/v1.0/myorg/admin/groups/{groupId}/datasets/upstreamDataflows.
Full info is here: https://learn.microsoft.com/en-us/rest/api/power-bi/admin/datasets-get-dataset-to-dataflows-links-in-group-as-admin
Essentially you map the datasetObjectId with the dataflowObjectId using this API. So it has nothing to do with the datasourceId or gatewayId, but if it has {"datasourceType": "Extension", "connectionDetails": {"path": "PowerPlatformDataflows", "kind": "PowerPlatformDataflows"} and the datasetObjectId is in the return of that API, then it's using internal "cloud" connection.
What I'm having issue with, is when a datasource doesn't have an objectId or gatewayId... Solve one problem create a new one!
