Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us at the 2025 Microsoft Fabric Community Conference. March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for $400 discount. Register now

Reply
arkiboys
Advocate II
Advocate II

notebook parameter

hello

in the fabric lakehouse notebook, how can I create parameters ? so that I can pass values to from ADF pipeline

thanks

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @arkiboys ,

Thanks for using Fabric Community.
As I understand you are looking for options to pass parameters from data pipeline to notebook.

Yes, it is possible to pass parameters from a notebook activity (data pipeline) to a notebook in Microsoft Fabric. To do this, you can use the Settings tab of the Notebook activity. In the Settings tab, under the Parameters section, you can add parameters that you want to pass to the notebook. The parameters can be of any type, such as strings, numbers, or arrays.

 

Here are the steps you can follow:

 

Step1: Create a notebook with required parameters. And make sure to select “toggle parameter cell” under more commands.

vgchennamsft_0-1715327943486.png

 

vgchennamsft_1-1715327943559.png

 

 

Step 2: Create a Pipeline for notebook activity and select the notebook in the settings option which you have created. And pass the parameters under “base parameters”.

 

Note : Name should be same in base parameters and notebook in order to pass the parameter.

 

vgchennamsft_0-1715328039492.png

 

 

Hope this is helpful. Please let me know incase of further queries.

 

 

View solution in original post

7 REPLIES 7
Anonymous
Not applicable

Hi @arkiboys ,

Thanks for using Fabric Community.
As I understand you are looking for options to pass parameters from data pipeline to notebook.

Yes, it is possible to pass parameters from a notebook activity (data pipeline) to a notebook in Microsoft Fabric. To do this, you can use the Settings tab of the Notebook activity. In the Settings tab, under the Parameters section, you can add parameters that you want to pass to the notebook. The parameters can be of any type, such as strings, numbers, or arrays.

 

Here are the steps you can follow:

 

Step1: Create a notebook with required parameters. And make sure to select “toggle parameter cell” under more commands.

vgchennamsft_0-1715327943486.png

 

vgchennamsft_1-1715327943559.png

 

 

Step 2: Create a Pipeline for notebook activity and select the notebook in the settings option which you have created. And pass the parameters under “base parameters”.

 

Note : Name should be same in base parameters and notebook in order to pass the parameter.

 

vgchennamsft_0-1715328039492.png

 

 

Hope this is helpful. Please let me know incase of further queries.

 

 

If the value of the name parameter is not set inside the notebook so would "Output" get printed ?

I have a use case where the item value of foreach acitivity in a data pipeline need to be set to a base parameter which will then be processed in the notebook but the notebook errors out with not found error



Regards,
Sachin
Check out my Blog

So that is returning values from the notebook to the pipeline.. What about in the reverse, and passing parameters from the pipeline to the notebook. Use case being incremental or full load parameter being passed.

Ah I see, it is possible.. just set up the parameter and value, then in the notebook just use the name of parameter. Very straight forward.

Hi, 

Can I ask how to pass parameter from pipeline to notebook? I cannot do that as you say.

 

MinhTa2024_0-1731558426401.png

MinhTa2024_2-1731558450340.png

 

hey, were you able to solve this? I believe we can simply pass it in the parameter and when we run the pipeline we can access it directly

Anonymous
Not applicable

Hi @arkiboys ,

Glad to know that your query got resolved. Please continue using Fabric Community on your further queries.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

FebFBC_Carousel

Fabric Monthly Update - February 2025

Check out the February 2025 Fabric update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.