Is there a way to list all the datasets and dataflow using a specific data source in a data gateway?

[Anonymous]

Our data gateway is currently hosted on a VM that needs to be decommissioned. We need to re-create all the existing data sources in our new gateway. Once that's done, I suspect we will need to update all Power BI assets using the existing gateway (Dataflows and datasets) to point them at the new one.

Is there a way to do this programmatically?

Is there a way to list all the Dataflows and datasets that are using a specific data source in the gateway?

I've had a look at API and PS Script but it does not seem to be able to link datasets/dataflows and Gateway data sources

[lbendlin · Accepted solution]

yes, there is. A really cool custom connector. GitHub - migueesc123/PowerBIRESTAPI: A Microsoft Power BI Data Connector or Power Query Connector fo...

We use it extensively for our gateway connection maintenance.

[Anonymous]

Thanks, I'll look it up