Select different data gateway cluster for report

[JoshT]

Is it possible to select a different target gateway cluster for a report if there are two with the same data source? Either in power BI service, or by changing in power BI desktop then republishing?

Long story is we wanted to uninstall a gateway from one machine and install on another, but it's impossible to remove a gateway from the cluster if the 'isAnchorGateway' property is set to true (tried this method, and came up against an error, fixes here don't work - it's impossible to change the anchor gateway to another in the cluster, so ty Microsoft for not sorting that one out).

Only solution is to create another duplicate cluster with the same data sources and access, so now we need to switch existing reports to the new one.

[JoshT · Accepted solution]

Never mind, found it.

You have to navigate to the 'Datasets' menu in the workspace, under actions, select the ellipsis, then settings. It's under gateway connection, and you need to expand actions, the select the relevant option in 'maps to' (this will deselect that option in any other gateway clusters).