topic Re: Table visible in lakehouse but no data visible in Data Engineering

Table visible in lakehouse but no data visible

joyeldavis007 — Fri, 26 Sep 2025 13:39:36 GMT

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?

Re: Table visible in lakehouse but no data visible

AntoineW — Fri, 26 Sep 2025 14:13:49 GMT

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

Re: Table visible in lakehouse but no data visible

joyeldavis007 — Fri, 26 Sep 2025 14:28:37 GMT

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}")

Re: Table visible in lakehouse but no data visible

Thomaslleblanc — Fri, 26 Sep 2025 14:39:00 GMT

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

Re: Table visible in lakehouse but no data visible

joyeldavis007 — Fri, 26 Sep 2025 14:51:16 GMT

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.

Re: Table visible in lakehouse but no data visible

v-prasare — Mon, 06 Oct 2025 13:38:26 GMT

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

Re: Table visible in lakehouse but no data visible

v-prasare — Wed, 08 Oct 2025 10:55:05 GMT

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.

Re: Table visible in lakehouse but no data visible

joyeldavis007 — Wed, 08 Oct 2025 17:01:52 GMT

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.

Re: Table visible in lakehouse but no data visible

v-prasare — Mon, 13 Oct 2025 09:00:07 GMT

sure, thanks for the update.