Forum Discussion

debiagui's avatar
debiagui
Resolver I
9 months ago
Solved

Unable to edit Semantic Model with Direct Lake over SQL Lakehouse

We have a Semantic Model connected to a Lakehouse using Direct Lake via the SQL Endpoint. The model has been working properly; however, today the “Edit tables” option is unexpectedly disabled. We c...
data engineering
Lakehouse
  • AntoineW's avatar
    AntoineW
    9 months ago

    Hello debiagui,

     

    If any of the following happened in the Lakehouse:

    • The SQL Endpoint was renamed,

    • A table was deleted or replaced,

    • The Lakehouse folder structure changed (e.g., new folders under /Tables),
      then the binding between the semantic model and its data source can break partially.

     

    👉 In this case, “Edit tables” gets disabled because Fabric can’t safely open the table-mapping dialog while schema metadata is inconsistent.

     

    Sometimes, it's a bug interface, the button "Edit Tables" can be grayed and the solution is to click on a table in your model semantic, and the button will appear clickable. 

     

    Hope it can help you !

    Best regards,

    Antoine

AntoineW's avatar
AntoineW
Super User
9 months ago

Hello debiagui,

 

If any of the following happened in the Lakehouse:

  • The SQL Endpoint was renamed,

  • A table was deleted or replaced,

  • The Lakehouse folder structure changed (e.g., new folders under /Tables),
    then the binding between the semantic model and its data source can break partially.

 

👉 In this case, “Edit tables” gets disabled because Fabric can’t safely open the table-mapping dialog while schema metadata is inconsistent.

 

Sometimes, it's a bug interface, the button "Edit Tables" can be grayed and the solution is to click on a table in your model semantic, and the button will appear clickable. 

 

Hope it can help you !

Best regards,

Antoine