Power Automate Azure Databricks connector cannot get output result of a run
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-04-2025 06:24 AM
Hi everybody, I'm using the Azure Databricks connector in Power automate and try to trigger a job run + get result of that single run. My job created in databricks is to run a notebook that contains a single block of SQL code, and that's the only task. But when I run the flow it says, Action 'Get_the_output_for_a_single_run' failed: Retrieving the output of runs with multiple tasks is not supported. Please retrieve the output of each individual task run instead.
I'm a bit confused as have 1 single task & that there's no parameter to choose as task id from the action of "trigger a job run", only the body/run_id to be selected.
has anyone encoutered the same issue and knows how to resolve that? Thank you!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-04-2025 07:47 AM
Even though your Databricks job only has one task, Power Automate might still treats it as a multi-task job under the hood. That’s why you're getting the error when trying to fetch the output directly from the job run.
Here’s a simple workaround you can try and let me know if it works:
1. Trigger the job and grab the run_id from the response.
2. Use the Get Job Run API (GET /api/2.1/jobs/runs/get) to fetch details of the run.
3. From that response, extract the run_id from the tasks block(there should be just one).
4. Then call the Get Task Run Output API (GET /api/2.1/jobs/runs/get-output?run_id=<task_run_id>) to get the actual output.
