Forum Discussion
Lakehouse data discrepancy between notebook and SQL endpoint or Dataflow
Hello everyone, I’m experiencing an issue with a table in my Microsoft Fabric Lakehouse and I’m hoping someone can assist me. Problem Description: I have a table in my Lakehouse that shows d...
That’s correct, the Notebook doesn’t show the data either. However, when using the SQL endpoint or Dataflow, the data is displayed correctly.
Could you try to use a command like this in the Notebook:
%%sql
SELECT * FROM tableName VERSION AS OF 1
(You can also replace 1 with another number. You can use DESCRIBE HISTORY to find out which versions have been made of the table, and then try to query some of the most recent versions).