- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Fabric Lakehouse vs SQL Analytics endpoint
I got Dataverse to Onelake sync, tables does show-up in Lakehouse but in SQL Analytics endpoint few of them are not there.
Ex: in below case xx_training _contact table is in Lakehouse and I can also query it within notebook, but in SQL Analytics endpoint it doesn't even exists.
Is there a reason why Fabric didnt created table in sql endpoint?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This now been resolved by Microsoft Fabric product team. In SQL Analytics endpoint you can refresh tables.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
No, this table was not created using spark or is external shortcut, this is Dataverse - Onelake sync, wherein its sync's data to Lakehouse and then creates table for SQL Analytics Endpoint.
There were 'N' tables which were sync'd right and tables do appear in SQL Analytics endpoint, but it missed few tables.
Raised Service Ticket with Microsoft, response was "after looking at the backend telemetry, they found the table sync actually happened from backend, When system tried to re-sync the table by drop and recreate, the drop succeeded, but while creating the table in SQL Endpoint, the creation failed with backend issue. Product group is investigating into it."
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This now been resolved by Microsoft Fabric product team. In SQL Analytics endpoint you can refresh tables.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @VenDaFabricator ,
Thank you for your updating, and you can accept the response as the solution to help the other members find it more quickly.
Best Regards,
Wisdom Wu
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @VenDaFabricator ,
There are some resons may caused this error:
1.The table was created with Spark code won’t be visible to the SQL analytics endpoint.
2.If having an internal shortcut that points to an external shortcut across artifacts, the table in that shortcut don’t show in the SQL analytics endpoint.
3.You can also view the following links to learn about the sql analytics endpoint error.
What is the SQL analytics endpoint for a lakehouse? - Microsoft Fabric | Microsoft Learn
What is data warehousing in Microsoft Fabric? - Microsoft Fabric | Microsoft Learn
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
03-10-2025 03:57 PM | |||
01-16-2025 11:57 AM | |||
01-01-2025 01:31 AM | |||
09-03-2024 04:45 PM | |||
04-10-2024 05:06 AM |