Forum Discussion
Copy datasources from one gateway to another?
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
Anonymous
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 Power BI REST API (github.com)
3 Replies
blopez11Super User
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
m-colbertResolver III
Anonymous
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 Power BI REST API (github.com)