Forum Discussion
Lakehouse data discrepancy between notebook and SQL endpoint or Dataflow
Hi Anonymous ,
Can you provide some screenshot information describing exactly what you did to access the data in different ways? Everything works fine in my tests.
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Sure, here are some screenshots. You can see that the Notebook returns zero rows, but when I view the data, there are more than 1000 records.
From the pictures, it looks like the table is a shortcut table.
I wouldn't know if that is relevant to the issue you are experiencing.
Do you know what is the source of the shortcut table? (aka Target of the shortcut).
Anyway, you say that you see the data when you connect from Dataflow Gen2. So it seems quite clear that the data is actually there. Just the Notebook don't find the data - that is the issue here.
Have you tried refreshing preview inside the Dataflow Gen2, or refresh the entire Dataflow Gen2, just to double check that the data is actually in the Lakehouse table?
Or clicked refresh in the user interface everywhere in the Lakehouse (both on Lakehouse level, table folder level, table level) and SQL Analytics Endpoint. There are quite many possible places to click refresh, almost a bit confusing.
Yes, the table is indeed a shortcut table. I have verified that the source table contains the expected data.
I have also created a notebook from the source and the same result
