Unknown Gateway and Datasource Id's in Admin - Datasets GetDatasourcesAsAdmin API Response

[afernand0]

Hi,

Does anyone know what the gateway id and datasource id in the https://api.powerbi.com/v1.0/myorg/admin/datasets/{datasetId}/datasources api response for Dataflows are referring to?

They are not the acutal guid of on-premises data gateways nor the id of any dataflow. 

Here's an example of a response. I'm referring to the values in datasourceId and gatewayId keys.

{"datasourceType": "Extension", "connectionDetails": {"path": "PowerPlatformDataflows", "kind": "PowerPlatformDataflows"}, "datasourceId": "abc1234-aaaa-bbbb-cccc-dddd", "gatewayId": "abc1234-xxxx-yyyy-zzzz-1111"}

[JBDarlingRidge]

@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... 

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!

[Anonymous]

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

[rohit1991]

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.

[afernand0]

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.

[Anonymous]

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

[afernand0]

@Anonymous , this api also gives the same id's as the admin API. Are you able to provide any info on how to find an item using the datasourceId or gatewayId in the response?