Forum Discussion
Solved
Dataflow Gen 2 output differs from Lakehouse table values - Data inconsistency issue
I have a Dataflow Gen 2 that give me a result like this: Project (str) || Pending Tasks (int) || Overdue Task (int) || dataDate (datetime) P406 || 59 || 5 || 18-11-2025 12:15:00 P426 || 1 || 0 || ...
Hi FVarelaI,
Thank you tayloramy, fro your insights.
Dataflow Gen2 data destinations and managed settings - Microsoft Fabric | Microsoft Learn
Data Factory limitations overview - Microsoft Fabric | Microsoft Learn
Thank you.
Hi FVarelaI,
Are you connecting to the SQL Endpoint of the lakehouse? It is known that the SQL Endpoint takes time to catch up with the underlaying delta tables.
After your notebook is done writing data, try forcing a metadata sync:
Refresh SQL analytics endpoint Metadata REST API (Generally Available) | Microsoft Fabric Blog | Microsoft Fabric
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.