Error Code 011 - Unable to deserialize the response.

[sgb_fabric]

Hi,

I am trying to create a pipeline to execute a notebook in the current workspace.

we also planned to deploy these items to other environments. I would like to understand how to provide the workspace id and notebook id dynamically to the Notebook activity in the pipeline.

Thanks in advance.

Pipeline config for notebook activity by dynamic expressions:

Currently I am getting below error:

[v-hashadapu]

Hi @sgb_fabric , Hope your issue is solved. If it is, please consider marking the answer 'Accept as solution', so others with similar issues may find it easily. If it isn't, please share the details.
Thank you.

[v-hashadapu]

Hi @sgb_fabric , Hope your issue is solved. If it is, please consider marking the answer 'Accept as solution', so others with similar issues may find it easily. If it isn't, please share the details.
Thank you.

[v-hashadapu]

Hi @sgb_fabric , Hope your issue is solved. If it is, please consider marking the answer 'Accept as solution', so others with similar issues may find it easily. If it isn't, please share the details.
Thank you.

[v-hashadapu]

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

The pipeline is unable to resolve the dynamic expressions for Workspace ID and Notebook ID correctly, likely due to incorrect parameterization or syntax issues.

Please consider below steps:

1. Create two pipeline parameters: WorkspaceID (type: String) and NotebookID (type: String).
2. In the Notebook activity configuration, use dynamic expressions to reference the parameters: Workspace ID: @pipeline().parameters.WorkspaceID, Notebook ID: @pipeline().parameters.NotebookID.
3. When deploying the pipeline to different environments pass the appropriate values for WorkspaceID and NotebookID dynamically.
4. Verify that the pipeline has the necessary permissions to access the specified workspace and notebook.
5. Test the pipeline in a sandbox environment before deploying to production.

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.

[sgb_fabric · Accepted solution]

I think the problem is - the dynamic expression is unable to resolve the given expressions while invoking the notebook activity. I am not sure if this resolves the issue.

I have done below to get a workaround it.

Instead of selecting different notebook in different workspace, I have made the notebook to accept the environment specific values as parameters. This way, I can use same notebook across different environments.

[nilendraFabric]

@sgb_fabric 

thanks for sharing the details 

please see if discussion helps , else I will suggest some other options 

https://community.fabric.microsoft.com/t5/Data-Pipeline/Dynamically-Change-Notebook-ID-for-each-Work...

please accept the solution if this works 

thanks

[sgb_fabric]

Thank you, @nilendraFabric for the quick response.

I tried this solution provided in the link but still facing the same issue:

Below is the error:

[nilendraFabric]

Hello @sgb_fabric 

Could you please share more details please , I am not able to understand the problem statement properly.

Thanks

[sgb_fabric]

Hi @nilendraFabric .. As I mentioned in the question, the objective is to create a pipeline that executes a notebook and writes data to a lakhouse in DEV workspace. We have connected the workspace to the GIT branch. 

The similar pipeline needs to be deployed to TEST workspace, that executes the notebook and writes data to a lakehouse in TEST workspace.

We are facing an issue when I deployed the branch to TEST environment from the GIT branch. When the pipeline is run, it is unable to write the data to the lakehouse in the TEST environment. We suspect that it is still pointing to the DEV workspace. 

So, we wanted to specify the Workspace ID and Notebook ID as dynamic expressions rather than selecting from the dropdown.  

But MS Fabric is throwing an error as shown below while running this pipeline. 

It works when I change it back to select the value from dropdown instead of dynamic expression.