Forum Discussion

PraveenVeli's avatar
PraveenVeli
Advocate I
4 months ago

Refresh Fabric SQL Endpoint failing when deploying using Deployment pipelines

Hi,

We are using the Refresh Fabric SQL End point activity within Fabric Data Factrory pipeline and it failes with below error when we try to push that Data Factory pipeline using deployment pipelines.

 

 

Erros: Import failure: RequestValidationFailed. 'WorkspaceId' cannot be null.

 

We tripple checked the Workspace Is populated in the Source workspace where we have the DF pipeline at. We also cannot use the Library variables as the activity complains it needs to be Object data type and we don't see Object data type in library variables.

pipelines

5 Replies

  • v-prasare's avatar
    v-prasare
    Community Support
    4 months ago

    Hi PraveenVeli,

    Even if the Workspace is populated correctly in the source workspace, this issue can still occur during Deployment Pipeline promotion. The Refresh SQL Endpoint activity requires an explicit workspace reference as part of its configuration (per Refresh SQL Endpoint Activity - Microsoft Fabric | Microsoft Learn). The underlying Fabric REST API for SQL endpoint refresh also requires a mandatory workspaceId.

    During deployment, Fabric copies item metadata between stages but does not automatically rebind environment‑specific workspace references. Since Data Factory pipelines currently don’t support parameterizing such bindings (for example, connectors can’t use parameters and Library variables don’t support Object datatype), the workspace reference cannot be resolved in the target stage.

     

     

    Thanks,

    Prashanth

    • PraveenVeli's avatar
      PraveenVeli
      Advocate I
      4 months ago

      Hi Hi v-prasare , 
      I don't know if this is a current limitation or a bug within Data Factory pipelines. Except for the Refresh Fabric SQL Endpoint activity, the other activity connections support parameters or variables. We have been using the parametrs/Variables successfully for other Activities within Data Factory Pipelines.

      • v-prasare's avatar
        v-prasare
        Community Support
        4 months ago

        Hi PraveenVeli ,

        This currently appears to be a limitation with the Refresh Fabric SQL Endpoint activity, as it requires a workspace reference (Object type) which cannot be parameterized during Deployment Pipeline promotion, unlike other activities where parameters/variables work.

        If this is impacting your deployment scenarios, we’d recommend raising this as a feature request/idea Microsoft Fabric Ideas.

        so the product team can review and consider adding support for parameterization in future updates.

         

         

         

        Thank you for your patience and look forward to hearing from you.
        Best Regards,
        Prashanth Are
        MS Fabric community suppor

  • v-prasare's avatar
    v-prasare
    Community Support
    4 months ago

    Hi PraveenVeli,

    As we haven’t heard back from you, we’d like to check if our previous response addressed your query or if you require any further assistance. Please feel free to reach out if you need additional support.

     

     

     

    Thank you for your patience and look forward to hearing from you.
    Best Regards,
    Prashanth Are
    MS Fabric community suppor

  • v-prasare's avatar
    v-prasare
    Community Support
    4 months ago

    We are following up once again regarding your query. Could you please confirm if you have raised ideas with Microsoft?
    If not please raise idea and upvote it. Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread. We’ll be happy to help.