Data is not visible in Lakehouse but is visible in dataflowgen2

[is_aar]

Hey,

My data is visible in my dataflow but not in my lakehouse. 
Dataflow goes to the right lakehouse.

I have 3 tables. 2 are visible in my lakehouse but the table incident is not visible
What is the solutions for this? Anyone know

[pallavi_r]

Hi @is_aar ,

This is there in the microsoft's know issue list. Please check the link below.

https://learn.microsoft.com/en-us/fabric/known-issues/known-issue-1114-insert-statements-tables-diff...

I am sure you would have ensured lakehouse destination setting correction with correct schema mapping.

If this post helps, appreciate your kudos.

Thanks,

Pallavi

[v-aatheeque]

Hi @is_aar 

It sounds like you're having an issue where one of your tables (the "incident" table) is not visible in your lakehouse, even though it shows up fine in your dataflow. Here are a few things you can check to help resolve this:

Besides a known issue as suggested by @pallavi_r  did you try the correct schema mapping. along with that can you try the below steps : 

• Open the dataflow and check if the incident table is mapped to the lakehouse.
• Ensure the output destination for the incident table is enabled and pointing to the correct lakehouse.
• Look at the dataflow run history to see if there were any errors or warnings related to the incident table.
• Sometimes, schema mismatches or null values can cause a table to fail silently.
• Try refreshing the lakehouse or reloading the workspace. Occasionally, UI glitches can cause tables to not appear immediately.
  

Looking for your response !!

[is_aar]

Hey! 

I saw in de dataflow history some error is still need to fix. I will late you know

[v-aatheeque]

Hi @is_aar 

Following up on the incident table issue were you able to make any progress with the errors you mentioned in the dataflow?

If there’s anything I can assist with, feel free to reach out.

[is_aar]

HEy @v-aatheeque 

I still have the same issue.

1. Creating a lakehouse

2. Add Dataflow gen2 --> add multiple tables

3. Open SQL endpoint and the table (incident) is present but no data
  Also when opening in SMSS no data. but the other tables are visible and have data

Soo i have no idea the cause is

[v-aatheeque]

Hi  @is_aar 

In this scenario i suggest you to raise a support ticket here. so, that they can assit you in addressing the issue you are facing.

Please follow below link on how to raise a support ticket:

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

[v-aatheeque]

Hi @is_aar 

Just checking in to see if you had a chance to review the suggestions regarding the “incident” table not appearing in your Lakehouse, despite being present in the dataflow.

As mentioned earlier, please verify the schema mapping, output settings, and dataflow run history  and don't forget to refresh the Lakehouse or reload the workspace in case of UI-related delays.

If you’ve already looked into it and are still running into issues, feel free to share more details so we can dig deeper and help resolve it.

Looking forward to your response!
Thanks again for being part of the Fabric Community.

[is_aar]

Hey @v-aatheeque im still figuring some stuff out in the lake house. 
some errors in the dataflow. 

[v-aatheeque]

Hi @is_aar 

Just following up to see if you had a chance to check why the “incident” table isn’t appearing in your Lakehouse, even though it exists in your dataflow.

As noted earlier, please confirm:

• Schema mapping is correct

• Output settings are properly configured

• The dataflow ran successfully
  Also, try refreshing the Lakehouse or reloading the workspace UI to rule out any display issues.

If you've already reviewed these and are still seeing problems, feel free to share more context happy to assist further!

If we don’t hear back, we may close this thread in line with our community guidelines, but you’re always welcome to post a new query anytime.
Thank you for being part of the Microsoft Fabric Community!