Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anushka96
Frequent Visitor

Tables Visible in Lakehouse but Not in SQL Endpoint

Anushka96_3-1722240199944.pngAnushka96_4-1722240208525.png

Excel files are uploaded to Lakehouse, transformed using Dataflow Gen2, and then uploaded as tables to the Same Lakehouse. These tables are visible in the Lakehouse but not in the SQL endpoint.

1 ACCEPTED SOLUTION
frithjof_v
Super User
Super User

The SQL Analytics Endpoint does not work in Lakehouses which has Schema (Preview) enabled.

 

Ref. similar thread 

Solved: Lakehouse tables not showing up in SQL Endpoint - Microsoft Fabric Community 

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hi @Anushka96 ,

 

Thanks for the reply from @frithjof_v .

 

I created a simple excel file for testing and fetched it through Data Flow Gen2, setting Lakehouse as the destination.

vhuijieymsft_0-1722301716440.png

 

At this time, I entered the lakehouse to switch the SQL endpoint, and I could not see the table in data flow Gen2.

 

I returned to data flow Gen2 and found that the data was being refreshed, and the delay was quite long. Please make sure that the refresh icon is finished.

vhuijieymsft_1-1722301739455.png
vhuijieymsft_2-1722301739456.png

 

Now go back to the SQL endpoint of lakehouse and click refresh to see that it is running normally.

vhuijieymsft_3-1722301757218.png

vhuijieymsft_4-1722301757222.png

 

So in addition to the reasons mentioned by frithjof_v , you can also refresh in the lakehouse after the dataflow Gen2 job is completed.

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

frithjof_v
Super User
Super User

The SQL Analytics Endpoint does not work in Lakehouses which has Schema (Preview) enabled.

 

Ref. similar thread 

Solved: Lakehouse tables not showing up in SQL Endpoint - Microsoft Fabric Community 

Helpful resources

Announcements
Fabric July 2025 Monthly Update Carousel

Fabric Monthly Update - July 2025

Check out the July 2025 Fabric update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.