Forum Discussion
Fabric connections appear to require a static endpoint
We're migrating Azure Data Factory (ADF) pipelines to Microsoft Fabric Data Factory using the REST API. Many of our ADF linked services are parameterized. For example, an Azure SQL linked service uses a server name like:
@{concat('company-sqlsrv-', linkedService().environment, '-database.database.windows.net')}
where environment is provided at runtime (for example, dev, test, or prod) through a global parameter. We also have REST and ADLS linked services where the endpoint or storage path is supplied dynamically (for example, linkedService().baseUrl or a storage path constructed from runtime parameters such as {layer}/{source}).
Fabric connections appear to require a static endpoint, so these don't seem to map directly.
I have a few questions:
Is there a supported way to create a Fabric connection that remains parameterized like an ADF linked service, or is creating one connection per concrete endpoint the only supported approach?
For "generic" linked services that are reused with many runtime URLs or storage locations, what is the recommended design pattern in Microsoft Fabric?
When calling POST /v1/connections, what is the correct credentialDetails payload for creating an Azure SQL connection through an On-Premises Data Gateway? We're receiving a 400 InvalidInput response with the message:
"The Values field is required."
Additionally, WorkspaceIdentity appears to be rejected for gateway-bound connections.
If anyone has documentation, sample payloads, or recommended migration patterns for this scenario, I'd really appreciate the guidance.
3 Replies
- tayloramySuper User
Hi dataengineerv2,
As far as I know there is no way to paramaterize Fabric connections in the service.
- v-achippaCommunity Support
Hi dataengineerv2,
Thank you for reaching out to Microsoft Fabric Community.
Thank you tayloramy for the prompt response.
Fabric connections currently use a static endpoint and do not support runtime parameterization like ADF linked services. For migration scenarios, the recommended approach is to create separate connections for each endpoint (for example, Dev, Test, and Prod) and continue to parameterize other pipeline values where supported.
- Regarding the 400 error, looks like the request payload is not in the expected format for the selected authentication type. Since gateway based connection payloads are not fully documented and WorkspaceIdentity is not supported for all gateway scenarios, if the issue persists, please open a Microsoft support ticket so the request payload can be reviewed in detail.
Create a Fabric and Power BI Support Ticket - Power BI | Microsoft Learn
Thanks and regards,
Anjan Kumar Chippa
- v-achippaCommunity Support
Hi dataengineerv2,
As we haven’t heard back from you, we wanted to kindly follow up to check if your issue is resolved? or have you raised a support ticket?
Thanks and regards,
Anjan Kumar Chippa