Forum Discussion

Frequent Visitor

2 years ago

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 So...

Frequent Visitor

2 years ago

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
Not applicable
2 years ago
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.