Forum Discussion
Copy datasources from one gateway to another?
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)
Super UserI 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
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-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)