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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Sudip
Regular Visitor

Setup multiple tables as Lakehouse Destination using Event Stream

Using Fabric Eventstream, I was looking to capture the changes from Azure SQL Server tables and load them into Fabric Lakehouse.

I have multiple CDC enabled tables in Azure and I can take this as Source in Fabric EventStream (Screenshot attached). Now I would like to pass these tables to corresponding tables in Lakehouse . But I only option to choose just single table in destination.

Sudip_0-1717688841930.png

 

 

Sudip_6-1717688907046.png

 

How can I set multiple destination tables??

3 REPLIES 3
Sudip
Regular Visitor

My destination are mutliple tables . How can I pass Table1 source to Table1 destination lakehouse delta table, Table2 to table2 delta table and so on.  All the destination tables are in one lakehouse . 

Hi @Sudip ,

I suggest you to create a separate Eventstream in Fabric for each source table in Azure SQL Server that you have CDC enabled on just as what I say before: "There can only be one Destination per Eventstream branch".
If this does not resolve the issue for you, I'd suggest mentioning a Support Ticket. A dedicated Microsoft engineer will come to solve the problem for you.

The link of Support Ticket: https://admin.powerplatform.microsoft.com/newsupportticket/fabricsynapserealtimeanalytics

For how to create a support ticket, please refer to https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/6830...

It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.


Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-junyant-msft
Community Support
Community Support

Hi @Sudip ,

There can only be one Destination per Eventstream branch, and a Destination can only contain one table; you cannot select more than one table.
But you can create multiple branches, as in the image below, as a way to get multiple Destination, disguised as passing into multiple tables.

vjunyantmsft_0-1717723025615.png


Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
FabricCarousel_June2024

Fabric Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors