Forum Discussion
Data Warehouse with Private Link enabled + Lookup activity - Cannot connect to SQL Database
It appears the Data Warehouse endpoint is currently inaccessible for any pipeline activity (including a Lookup activity) when Private Link is enabled. The documentation explicitly mentions that copying data from or into a Data Warehouse isn’t possible, and even though it doesn’t call out Lookup activity by name, the underlying limitation means the Data Warehouse SQL endpoint can’t be reached from the pipeline runtime once Private Link is enabled. In practice, this blocks queries or stored procedures in Lookup, copy activities, or other attempts to connect to the warehouse.
Many users see the same behavior—a connection failure—because the Data Warehouse endpoints don’t support these operations over the private network yet. Disabling Private Link or using other endpoints (such as a Lakehouse) is often the only current workaround. If you must work with the Warehouse, you may need to revert to public access or use an alternative path until the platform’s roadmap includes support for private-link-enabled Data Warehouse pipeline operations.If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Super UserIt appears the Data Warehouse endpoint is currently inaccessible for any pipeline activity (including a Lookup activity) when Private Link is enabled. The documentation explicitly mentions that copying data from or into a Data Warehouse isn’t possible, and even though it doesn’t call out Lookup activity by name, the underlying limitation means the Data Warehouse SQL endpoint can’t be reached from the pipeline runtime once Private Link is enabled. In practice, this blocks queries or stored procedures in Lookup, copy activities, or other attempts to connect to the warehouse.
Many users see the same behavior—a connection failure—because the Data Warehouse endpoints don’t support these operations over the private network yet. Disabling Private Link or using other endpoints (such as a Lakehouse) is often the only current workaround. If you must work with the Warehouse, you may need to revert to public access or use an alternative path until the platform’s roadmap includes support for private-link-enabled Data Warehouse pipeline operations.
If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Hi, have you reported this to Microsoft? We seem to have a similar problem.
Hi,
Yes, we had a call with some people from Microsoft. It was confirmed that the integration between Data Pipelines and Data Warehouse is not currently working under the Private Link setup.
They are aware of the issue, and development is in progress, but no release date has been specified.
- nilendraFabric
