Managed private endpoint and Azure SQL Database

Hi thuanss , thank you for reaching out to the Microsoft Fabric Community Forum.

You are correct that Microsoft Fabric currently does not natively support direct connectivity to private endpoints for Azure SQL Database through the Copy Data feature without using an on-premises data gateway. The managed private endpoint in your workspace establishes a secure connection, but as of now, Fabric's native integration doesn't fully utilize these endpoints for certain tasks, including Copy Data.

And you are right, managing additional infrastructure can be a hassle. If possible, please consider below:

1. Consider using Azure Synapse Analytics or standalone Azure Data Factory, which provide better integration with private endpoints without requiring an on-premises gateway. Once data is copied or transformed, you can integrate it back into Fabric for further processing.
2. Consider Using an Azure Integration Runtime (IR) with a Managed Virtual Network as when you create an Azure Integration Runtime within a Managed Virtual Network, the IR is provisioned with the Managed VNet and uses private endpoints to securely connect to supported data stores. This eliminates the need for an on-premises gateway.
3. Using service principal authentication with Azure Data Factory can provide a more seamless way to connect to your Azure SQL Database without needing an on-premises data gateway.

If this helps, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details.
Thank you.