Copy datasources from one gateway to another?

[Kevin_Brennan]

Hi

We have just setup a new gateway server. Is it possible to copy all the datasource connections from our existing gateway server to this new one? I am not interested in forming a cluster with the 2 of them, I need 2 standalone gateways for the moment.

I can only find comments on migrating, moving, restoring or making a cluster

Thanks

K

[blopez11]

I am not aware that this is easily possible.  You may be able to use the Power BI REST APIs to get the data sources from one gateway and create them on another, but on creation  you still need to provide the credentials.  Depending on skill and familiarity, it may be more trouble that it is worth, but I don't know how many sources you are talking about.

Gateways - REST API (Power BI Power BI REST APIs) | Microsoft Learn

[Kevin_Brennan]

Thanks, this is what I feared. We have circa 120 sources, though uncertain how main are still relevant/live. Looks like it is going to be a long task creating them and assigning them to datasets

[m-colbert · Accepted solution]

@Kevin_Brennan 

I would recommned using the Power BI REST API custom connector to create a report that will show you for your entire tenant (at least where you have access) what gateway data sources are used in which reports. This will help you clean it up. migueesc123/PowerBIRESTAPI: A Microsoft Power BI Data Connector or Power Query Connector for the Pow...