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.

     

VenDaFabricator's avatar
VenDaFabricator
Resolver I
2 years ago

Hi Anonymous 

 

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."

 

  • VenDaFabricator's avatar
    VenDaFabricator
    Resolver I
    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 ,

      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