Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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...
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

frithjof_v's avatar
frithjof_v
Community Champion
2 years ago

Just to confirm: notebook doesn't find the data also in the source table?

However other user interfaces finds the data also in the source table.

 

So the issue seems to be at the source table and notebook is not able to find the data, but other user interfaces are able to see the data.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    That’s correct, the Notebook doesn’t show the data either. However, when using the SQL endpoint or Dataflow, the data is displayed correctly.

    • frithjof_v's avatar
      frithjof_v
      Community Champion
      2 years ago

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