Forum Discussion

VenDaFabricator's avatar
VenDaFabricator
Resolver I
2 years ago
Solved

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 a...
Need Help
  • VenDaFabricator's avatar
    VenDaFabricator
    2 years ago

    This now been resolved by Microsoft Fabric product team.  In SQL Analytics endpoint you can refresh tables.

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

Known issue - Tables aren't visible to the SQL analytics endpoint for some shortcuts - 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.