Dataflow data gateway being changed upon takeover, unable to change back

[danielwebb]

I have experienced several times now with different gateways a problem whereby when ownership of a dataflow is taken over, the data gateway settings in the dataflow are changed and trying to change them back won't work.

The dataflows are cloud sources only (Azure SQL) but we have an enterprise gateway for on-prem SQL DBs (these queries are in their own dataflow). The data gateway under Options -> Project -> Data load is set to "(none)" when the dataflow is set up, but if another user (with the same rights on the Azure SQL DB) takes over, the data gateway is set to the name of the enterprise gateway and the queries in the dataflow time out and won't refresh.

We go into Options -> Project -> Data load, change the gateway to "(none)" again, there is a message that says this change effects all queries in the dataflow:

then click OK, however if we go back into options again the change hasn't been applied and the gateway is still set to the name of the on-prem gateway.

This seems like some sort of bug as the setting isn't being applied. I have tried unlinking all of the connections first before changing the gateway, but that doesn't have any effect. The only thing that works has been to create a new dataflow, which is a rather drastic and time consuming step...

[alfBI]

This is crazy.... Thx to this post I have discovered why the gateway of our DF changed without any explicit actions.... in our case the DF was developed ina PRE workspace with a PRE gateway. After deployed to a PRO workspace the gateway was changed to a PRO gateway (as the gateway value is not supported on the pipeline parameters). Now, every time a developer does a take over on the PRO workspace the gateway changes to PRE automatically... craxy

I can't believe that issue has not been solved.....

Thx

[edhans]

I've had success getting the dataflow to recognize my preferred gateway if I go in and edit the dataflow in some way and mess with the tables that are being pulled from the desired gateway. the DF sees it and allows me to select what I want.