How to call fabric notebook from adf

[Anonymous]

How to call fabric notebook from adf

[burakkaragoz · Accepted solution]

Hi @Anonymous ,

Right now, calling a Fabric Notebook directly from Azure Data Factory (ADF) isn’t natively supported like Synapse notebooks. But here are a couple of workarounds you can try:

Option 1: Use a Fabric Pipeline Instead

• Fabric Pipelines support Notebook activities natively.
• You can trigger a Fabric pipeline from ADF using a Web activity or REST API call to the Fabric pipeline endpoint.

Option 2: Trigger via Power Automate

• Create a Power Automate flow that runs your Fabric Notebook (via Fabric pipeline).
• Then call that flow from ADF using a Webhook or HTTP activity.

Option 3: Use REST API (when available)

• Microsoft is gradually rolling out REST APIs for Fabric workloads. Once the Notebook execution API is public, you’ll be able to call it directly from ADF.

Let me know if you want help setting up the Fabric pipeline trigger or the Power Automate flow.

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.

[v-csrikanth · Accepted solution]

Hi @Anonymous 
As mentioned by @burakkaragoz you can’t call a Fabric notebook direct with a built-in ADF activity, but you can invoke it via the Fabric REST API using a Web activity:

can’t call a Fabric notebook direct with a built-in ADF activity, but you can invoke it via the Fabric REST API using a Web activity in detailed steps:

• Enable your Data Factory’s system-assigned managed identity and grant it Contributor (or Notebook Operator) access on the Fabric workspace

• In your ADF pipeline, add a Web activity, set Authentication to Managed Identity, and enter Resource= https:api.app.fabric.microsoft.com
• Configure the activity’s URL as:  https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/items/{notebookId}/jobs/instances?jobType=RunNotebook
• Set Method = POST, Headers → Content-Type: application/json, and Body either {} or include to pass notebook parameters.  { "executionData": { "parameters": { "param1":"value1" } } }
• Run the pipeline; the Web activity will trigger the notebook run. You can monitor status via the Get Item Job Instance REST API.

Reference links : https://learn.microsoft.com/en-us/fabric/data-engineering/notebook-public-api 

If the above information helps you, please give us a Kudos and marked the Accept as a solution.

Best Regards,
Community Support Team _ C Srikanth.

[burakkaragoz · Accepted solution]

Hi @Anonymous ,

Right now, calling a Fabric Notebook directly from Azure Data Factory (ADF) isn’t natively supported like Synapse notebooks. But here are a couple of workarounds you can try:

Option 1: Use a Fabric Pipeline Instead

• Fabric Pipelines support Notebook activities natively.
• You can trigger a Fabric pipeline from ADF using a Web activity or REST API call to the Fabric pipeline endpoint.

Option 2: Trigger via Power Automate

• Create a Power Automate flow that runs your Fabric Notebook (via Fabric pipeline).
• Then call that flow from ADF using a Webhook or HTTP activity.

Option 3: Use REST API (when available)

• Microsoft is gradually rolling out REST APIs for Fabric workloads. Once the Notebook execution API is public, you’ll be able to call it directly from ADF.

Let me know if you want help setting up the Fabric pipeline trigger or the Power Automate flow.

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.