Dataflow data source change and gateway assignment

[Jack2of3]

Hi All.

I have successfully changed the Data Base source for my dataflows. The Data Bases are on the same cluster. The old entry is DM02xxx the New entry is 19C so it is long (((Description XXX))).

When I check the lineage of the dataflow it still shows DM02 as well as the new 19C connection.

Any idea how to get it to only show the new 19C connection?

I've checked settings but it just spins.

[v-yanjiang-msft]

Hi @Jack2of3 ,

Please refer to this official document: Change the gateway used in a dataflow project - Power Query | Microsoft Docs

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Jack2of3]

The first entry is the origional connection.

The second entry is after the Power Query Advanced entry was changed.

Should be able to remove the first entry in this app.

[Jack2of3]

I've done the part where I change the Gateway Source DB in Power Query Advanced. Creating a new connection seems to be overkill. Why can't the capability to open the settings and change the gateway source entry be available like with a dataset?

[m-colbert]

@Jack2of3 

Welcome to the world of dataflow frustration. I've experienced the same. What are the names of the gateway datasources, often this will list teh server and DB name not the name of the datasource.

[Jack2of3]

Unfortunately with it being Oracle data bases it uses the the HOST Server:Port/Database service that is in the TNSNAMES.Ora file. Now with 19C it uses the entire Decription in the TNSNAMES.Ora for connection