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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
sschuetz
Frequent Visitor

dbt activity in fabric data factory

Hi all,

 

I'm trying to get the the dbt activit running in the fabric data factory.

unfortunatly i cannot find any documentation whatsoever.

 

After configuring i get the error: "Invaild payload. Error message Cannot resolve Data Factory runtime 'WorkspaceIR'."

 

is there a configuration i'm missing?

 

Thanks

9 REPLIES 9
alexanderamlani
New Member

I'm also facing the same issue, clarity would be understood , I also would like to know if we can host dbt in fabric without dbt cloud

Anonymous
Not applicable

Hi @sschuetz ,

Thanks for using Fabric Community.
As I understand you are using dbt activity in fabric data factory.

vgchennamsft_0-1713424327405.png

Inorder to guide better can you please share the screenshot of your issue?

hi @Anonymous 

 

exactly this activity.

 

sschuetz_0-1713428076156.png

 

Anonymous
Not applicable

Hi @sschuetz ,

At this time, we are reaching out to the internal team to get some help on this .
We will update you once we hear back from them.

In meantime, please refer below links I hope this might give some insights.

Docs -
DBT in Microsoft Fabric: MY JOURNAL (linkedin.com)
Set up dbt for Fabric Data Warehouse - Microsoft Fabric | Microsoft Learn


Appreciate your patience.

Anonymous
Not applicable

Hi @sschuetz ,

We have a response from internal team -

The Data Factory team is actively exploring mechanisms to enrich their orchestration capabilities. While customers have been orchestrating dbt cloud using web activity, we are exploring ways to simplify the user journey with an activity. We do not have any release dates for this feature yet. "

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

Hi @Anonymous 

 

I don't understand your answer: The activity is availiable in fabric data factory. 

So you are telling me it is live but not usable?

 

 

Anonymous
Not applicable

Hi @sschuetz,

The functionality is planned for the future and is not fully functional currently

The dbt activity is a available in the UI now. If it's not functional, why do we see it?

Sounds like it slipped out and shouldn't have been released publicly yet. 

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

November Update

Fabric Monthly Update - November 2024

Check out the November 2024 Fabric update to learn about new features.

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! Early Bird pricing ends December 9th.