Raymond Boone on 26 Feb 2024 18:41:29
I've noticed that when others create new Gen2 dataflows, they create new connections to data sources--despite selecting an existing shared connections. As a result, I'm getting lots of duplicate data connections when new Gen2 DFs are created.
From testing:
1. Created a Gen2 dataflow as above--using existing shared connection.
2. Got the extra personal mode connection, but deleted it.
3. Refreshed the dataflow no problem--indicating it's using the shared connection.
4. Had another person "Take Over" the dataflow and refresh it. No problem.
5. Had the other person disconnect the connection and reconnect it and no new personal mode connection was created.
6. I took over the connection again and refreshed, no problem.
7. I disconnect the connection and then recreated it and got a new personal mode connection.
8. I deleted the new connection and the dataflow still refreshes from the shared connection.
My idea is to eliminate these unnecessary additional "Personal mode' connections and instead use the existing shared connections consistently.
Administrator on 06 Mar 2024 20:24:38
Thank you for reporting this! We're looking at it internally.
This portal is dedicated to ideas, so I'm declining this idea but would recommend posting issues like this in the Data Factory forum or creating a support ticket for it.