storage mode is disabled in custom semantic model created on lakehouse

[dinesh01]

storage mode is disabled in custom semantic model created on lakehouse. What are the various ways to change the storage mode from direct lake mode to other modes.

[Anonymous]

Hi, @dinesh01 

Currently a limitation. We can't mix direct lake with other storage modes (Import, DirectQuery, or Dua):

Learn about Direct Lake in Power BI and Microsoft Fabric - Microsoft Fabric | Microsoft Learn

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[dinesh01]

Is there a way to convert all direct lake mode tables to import mode in custom semantic model ?

[Anonymous · Accepted solution]

Hi, @dinesh01 

You can use the SQL end point of the SSMS connection workspace to modify the storage mode of the current semantic model, which requires the permission of your capacity administrator:

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.