fabrical.
Back to feed
Fabric Recent Update·Apr 20, 2026·Penny Zhou

Orchestrate dbt jobs activity in your Fabric pipelines (Preview)

View original article

Coordinating dbt runs with upstream ingestion and downstream consumption often requires complex solutions and different tools. You can now add a dbt job activity (Preview) directly to your Fabric pipelines. This lets you orchestrate dbt transformations alongside other pipeline activities, so you can build end-to-end data workflows without switching tools.

Why this matters

  • Run dbt jobs as part of your pipeline — chain dbt with other activities using dependency conditions.
  • Create or select dbt jobs inline — select an existing dbt job or create one without leaving the pipeline canvas.
  • Parameterized workflows — pass dynamic runtime parameters from your pipeline to the dbt job, enabling reusable, parameterized workflows.
  • Get notified when jobs finish — send Teams or email notifications after each dbt run.
  • Monitor progress in one place — track dbt job status directly within your pipeline run history.

How to use dbt job activity

  1. Open or create a data pipeline in your Fabric workspace.
  2. Add the dbt job activity from the activity pane.
  3. On the Settings tab, configure or select a connection to the workspace that contains your dbt job. You can use an existing connection or create a new one through the Get data page.
  4. Select the target workspace and dbt job item. If you don’t have a dbt job yet, select + New to create one inline.

This pictures show how to use dbt job activity

Figure: Add dbt job activity.

Parameterized workflows in dbt job

Dynamic content can be used to parameterize all columns in the Settings tab. By adding dynamic content, you can set parameters for any dbt job activity property. All columns in the Settings tab support dynamic content.

For instance, you can pass a parameter to the Select field, allowing each pipeline run to execute only the models that meet the specified rules.

This screenshot shows the functions of Pipeline parameterizations

Figure: Configure dynamic content for dbt job.

Advanced settings for dbt job

  • The Settings tab provides access to advanced options for dbt command settings, node selection, and execution behavior.
  • Select your dbt command (build, run, compile, snapshot, or test) and set filters such as select, exclude, full refresh, or fail fast as needed.

This is the screenshot for dbt job activity settings

Figure dbt job advanced settings.

Next steps

By integrating dbt jobs into Fabric pipelines, you can orchestrate transformations alongside other pipeline activities and manage orchestration logic in a single workflow. This Preview capability is designed to reduce complexity while giving you more control and visibility over dbt execution. Try it out in your pipelines and share feedback in the comment section to help guide what comes next.

Related blog posts

Orchestrate dbt jobs activity in your Fabric pipelines (Preview)

Outbound access protection for Data Factory (Generally Available)

Co-author: Abhishek Narain Workspace outbound access protection (OAP) is widely accessible for Data Factory workloads—including Pipelines, Copy Job, and Dataflows—as well as for Mirrored Databases such as Mirrored SQL Database and Mirrored Snowflake. Key benefits Enhanced outbound security: By leveraging OAP rules, organizations can ensure that the Data Factory items from the protected workspace can … Continue reading “Outbound access protection for Data Factory (Generally Available)”

Agentic Fabric: How MCP is turning your data platform into an AI-native operating system

Something fundamental is changing in how developers interact with data platforms. Not a feature update, not a UI refresh, but a shift in the interface itself.

Microsoft Fabric

Accelerate your data potential with a unified analytics solution that connects it all. Microsoft Fabric enables you to manage your data in one place with a suite of analytics experiences that seamlessly work together, all hosted on a lake-centric SaaS solution for simplicity and to maintain a single source of truth.

Get the latest news from Microsoft Fabric Blog

This will prompt you to login with your Microsoft account to subscribe

Visit our product blogs

View articles by category

View articles by date

What's new

Microsoft Store

Education

Business

Developer & IT

Company

  • © 2026 Microsoft
  • Manage Cookies
  • Contact Microsoft
  • Privacy
  • Terms of use
  • Trademarks
  • About our ads
#Announcements#Data Factory