Table visible in lakehouse but no data visible

[joyeldavis007]

Hi team,

im using Notebook to move data from my silver lakehouse to gold lakehouse along with minor transformations.
There are 10 tables and 1 table which is comparatively bigger than the others shows table schema but no data.

I checked the source table and it has data and below are the transformations i do before i overwrite the table.the print also shows its successfully loaded but there will not be any data if i query in lakehouse.

if i rerun the code it works, but sometimes this happens. Can someone help me to fix this?

[AntoineW]

Hello @joyeldavis007,

When overwriting a table from a Fabric notebook, make sure you use both:

gold_path = "Tables/gold_lakehouse/your_table_name"

df_transformed.write \

    .format("delta") \

    .mode("overwrite") \

    .option("overwriteSchema", "true") \

    .save(gold_path)

 

• overwriteSchema ensures the schema is correctly updated.

• saveAsTable guarantees the data is committed into the Lakehouse Tables area (not just written as loose files).

In short: always use overwriteSchema + saveAsTable and give Fabric a bit of time to sync — otherwise you may see “schema only, no rows” right after the overwrite.

 

Hope it can help you ! 

Best regards,

Antoine

[joyeldavis007]

Hey AntoineW,

i lost my code block while posting, i'm already using overwriteschema with saveAsTable.But instead of providing the path i just mentioned the table name inside saveAsTable.Will that might be the issue?

Attaching my code block.

 df.write.format("delta").mode("overwrite").option("overwriteSchema", "true").saveAsTable(resource_gold)
    print(f"✅ Saved gold table: {resource_gold}")

[Thomaslleblanc]

If you are trying to view in SQL Analytics Endpoint, there is a delay. In that interface, in the upper right, there is a button to Refresh

[joyeldavis007]

Hey Thomas,

i have a data flow after this notebook to copy this gold data into an individual's lakehouse, That dataflow fails with this error
DeltaDataFileMissingAddFileAction,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=No matching AddFile action for data file
thats how i notice this blank table. then i go back to default lakehouse view and SQL end point. But both will be blank even if i refresh the view.

[v-prasare]

If your issue still persists, please consider raising a support ticket for further assistance.
To raise a support ticket for Fabric and Power BI, kindly follow the steps outlined in the following guide:

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

[v-prasare]

We are following up once again regarding your query. Could you please confirm if the issue has been resolved through the support ticket with Microsoft?
If the issue has been resolved, we kindly request you to share the resolution or key insights here to help others in the community. If we don’t hear back, we’ll go ahead and close this thread.
Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread. We’ll be happy to help.

Thank you for your understanding and participation.

[joyeldavis007]

@v-prasare  I have raised a support ticket parrallely as i posted on this thread. However,  its still not resolved and support team is working on it. I can update the thread once we get a resolution.

[v-prasare]

sure, thanks for the update.