Sempy Link Labs: Add a new table to a semantic model from a Fabric Warehouse delta table source

[PJ-Fairday]

Hey folks,

Sempy link labs has been a life saver for numerous semantic model tasks. However I'm stuck on this one. My gold layer is in Fabric Warehouse and the semantic model is in direct lake mode. I use sempy to automate admin and build work. However I'm finding that there is one simple thing that I cannot do which is to add a new semantic model based on a Fabric warehouse source.

I'm looking for a warehouse-compatible version of 

sempy_labs.directlake.add_table_to_direct_lake_semantic_model

When I run the below... 

from sempy_labs import directlake as dl
dl.add_table_to_direct_lake_semantic_model(dataset=dataset, table_name='New Date', lakehouse_table_name='dim_date', workspace=workspace)

I get an error that dim_date is not a lakehouse table:

ValueError: 🔴 This function is only valid for Direct Lake semantic models which source from Fabric lakehouses (not warehouses).

Adding a table to a semantic model is quite a basic function. I'm hoping that there is a way to do this programatically
Thanks!

[PJ-Fairday]

Thanks I've written code to do this will submit it to the semantic-link-labs repo so hopefully will be available in a future version!

[ssrithar · Accepted solution]

Hi @PJ-Fairday ,

The add_table_to_direct_lake_semantic_model function is specifically designed for lakehouse-sourced Direct Lake models and does not currently support warehouse-sourced models.If needed you can add a goldproject layer of lakehouse and that is how we have it so we can have the direct lake sematic model and have sempy automation.

If this post helps, then please appreciate giving a Kudos or accepting as a 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!