Use shareable connections in Dataflow Gen2

[#1]

Have the ability to share connections that can be used in Dataflow Gen2

[deatherage]

This is important for me as well.

We have a 3rd Party vendor that allows us to connect to a Azure SQL instance to extract data. We have 2 different logins to the same azure sql server/database and the only difference in the connection string is the username and password. They use row-level security on their data. The dataflow gen2 has to be owned by 2 different users so the personal cloud connectors can have correct credentials instead of being able to select the same cloud connectors that we use in our Semantic model connection strings. Here is the informational message I see when I look at the details of the cloud connector.

"Currently, these cloud connections are not supported by Dataflows, Dataflows Gen2, and Datamarts. To create personal cloud connections for these experiences, please use the Dataflows or Datamarts editor in "Get Data"."

Please get this fix on the roadmap.

[nishalit]

Support for Shareable Connections in Dataflows Gen2 is planned for the second half of CY2024.

[jcantwell]

Will this also be considered for Dataflows Gen1?

[rboone]

This is important because without it, I get tons of "Personal Mode" connections that mess up my dataflows. See the thread at the link below.

https://community.fabric.microsoft.com/t5/Dataflow/New-connections-in-Gateways-and-Connections-despite-using-the/m-p/4349999#M4732