Forum Discussion
Changes Not Reflected in Fabric Lakehouse table from azure sql db table using EventStream
i get that but the problem is there is no datetime column in my source.
Hi Sudip ,
Do you mean you want to add a datetime column? You can refer to the following operation:
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
No. i dont need any other extra columns. I am expecting the eventstream to write data on existing table inside Lakehouse.
here is the simple workflow:
1. Azure SQL db (CDC) as source, single table selected for now to pass into eventstream
2. Lakehouse as destination where the table already exists
3. Made some changes in the source table (which i expect to be reflected in lakehouse table)
4. Its not happening . I see the changed in EventStream but its not written in Lakehouse table.
Could you help on this??
Hi Sudip ,
If you don't add the manage fields that step, add lakehouse as a destination and select create new table, you can't find the new table in lakehouse either?
If after refreshing you can see the new table in lakehouse then I think the problem still lies in the manage fields step, if you still can't see it I suggest you open a ticket and a dedicated Microsoft engineer will come to solve the problem for you.
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.The link of Power BI Support: Support | Microsoft Power BI
For how to create a support ticket, please refer to How to create a support ticket in Power BI - Microsoft Power BI Community
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.