Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors