The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to Solution.
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
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.
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.
Now go back to the SQL endpoint of lakehouse and click refresh to see that it is running normally.
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!
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