Reply
JoshT
Advocate II
Advocate II

Select different data gateway cluster for report

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.

1 ACCEPTED SOLUTION
JoshT
Advocate II
Advocate II

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).

View solution in original post

1 REPLY 1
JoshT
Advocate II
Advocate II

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).

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)