Account
Skip to main content

Direct Lake Flavor

The source binding for generated semantic models. Available values are DirectLakeOnOneLake, DirectLakeOnSql and Import. Import writes import partitions that load the tables of the project's SQL Server data mart through Power Query, for Power BI Desktop and the Power BI service, whatever the project's integration template. A project scoped value overrides the instance level value. When the setting is blank, DirectLakeOnOneLake is used.

Options: DirectLakeOnOneLake, DirectLakeOnSql, Import

OptionBehavior
DirectLakeOnOneLake (default)Direct Lake binding on OneLake. Produces a model only for projects that use the Fabric Data Factory integration template (FDF)
DirectLakeOnSqlDirect Lake binding on SQL. Produces a model only for projects that use the Fabric Data Factory integration template (FDF)
ImportImport partitions that load the tables of the project's SQL Server data mart through Power Query, for any integration template

The value is matched without regard to case or surrounding spaces. A blank value is treated as DirectLakeOnOneLake. Any other value is reported as a build error for the project, and no files are written for its model.

Semantic model generation is an opt-in preview. See Semantic Models for the folder layout a build emits.

When to Change This Setting​

Keep the default for a Direct Lake model on OneLake. Choose Import when the model should load the project's SQL Server data mart for Power BI Desktop or the Power BI service. Set a project scoped value when projects need different bindings.

SettingInteraction
Enable Semantic ModelTurns the semantic model output on
Model NameThe name of the model this binding applies to

Notes​

  • This setting is part of the Microsoft Fabric settings category.
  • The default value for this setting is DirectLakeOnOneLake.