Best Way to Connect Fabric Data Pipelines/Notebooks to PostgreSQL Flexible Server (Private Access)

[kiket]

Hi all,

I need to connect Fabric Data Pipelines or Notebooks to an Azure PostgreSQL Flexible Server that has Private Access (VNet Integration only).

🔹 Key Constraints:

• No Managed Private Endpoints → Not possible because Azure PostgreSQL only allows private endpoints when Public Access is enabled, which I cannot enable.
• No VNet Data Gateway → I prefer to avoid using Dataflows
• Would rather avoid ADF or On-Premises Gateway, but open to suggestions if there’s no better alternative.

What’s the best way to securely connect without exposing PostgreSQL publicly? Any recommended workarounds using Fabric-native solutions, private DNS, or other secure methods?

Thanks! 

[v-nmadadi-msft]

Hi  @kiket ,
Thanks for reaching out to the Microsoft fabric community forum.
 For your particular use case It is recommended to use Managed private endpoints in Fabric
Overview of managed private endpoints for Microsoft Fabric - Microsoft Fabric | Microsoft Learn
Managed private endpoints are feature that allows secure and private access to data sources from certain Fabric workloads. Presently fabric spark workloads and eventstream are supported by managed private endpoint.
We can create private endpoints from network security in workspace settings

Please follow this document to create a private endpoint to Azure PostgreSQL Flexible Server: Create and use managed private endpoints in Microsoft Fabric - Microsoft Fabric | Microsoft Learn

If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS.
Thanks and Regards

[kiket]

Hi  @v-nmadadi-msft, thanks for the reply. As stated on my post, I can't have managed private endpoints because the Network config for azure is set as Private Access 

In order to set up a Managed Private Endpoint I'd have to enable Public Access, which is not an option for us. 

Thanks again

[v-nmadadi-msft · Accepted solution]

Hi @kiket  ,

There have been previous discussions in this forum addressing similar issues to yours. You may find valuable insights or potential solutions by exploring those discussions, the general recommended solution was to use On-Premises Data Gateway installed on an Azure Virtual Machine (VM) within the same Virtual Network as your PostgreSQL.

Solved: Data gateway- Connect Power BI service dataset to ... - Microsoft Fabric Community
Re: How to access Azure SQL Database without allow... - Microsoft Fabric Community

If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS.
Thanks and Regards

[kiket]

Yup, we ended up setting up an On-Prem DG on an Azure VM. Thanks for the help!