We are currently using an on-premises data gateway to allow our reports in the app.powerBI.com web interface use an on-premise SQL Server Analysis Services (SSAS) server tabular model for their data source. Dozens of reports, workspaces, and other PowerBI objects are all running off of this gateway.
We now need to move this SSAS server to a different server for resource management reasons.
If I go to https://app.powerbi.com/ click the "settings" gear and open the "manage gateways" page, I can find the detail I want to change, the "Server" value here:
But that field is disabled for every admin that has tried. I believe if I could change this field, my problems would be solved.
We looked into doing it through the API, but it appears it is also not editable via API calls related to the gateway: https://docs.microsoft.com/en-us/rest/api/power-bi/gateways
Changing the gateway seemed like the path of least resistance. If anyone knows how to do that, please let me know.
The second idea we had was create a second gateway and point all existing dashboards, reports, workspaces, etc. to the new gateway. However, we have a lot of non-technical users that we can't expect to go in and do this themselves on things they have created, so if we do this it must be via the API. It appears I could do this for things the user calling the API has in their "My Workspace" but I don't see where I could do something like "Find all objects using Gateway 1 and point to Gateway 2 instead"
Any ideas?
