Setup multiple tables as Lakehouse Destination using Event Stream

[Sudip]

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.

How can I set multiple destination tables??

[Sudip]

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 . 

[Anonymous]

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.

[Anonymous]

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.

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.