DAX

Two flavors of Direct Lake: Direct Lake on SQL endpoint is the “legacy” version of Direct Lake

Direct Lake on OneLake is a new mode that will be integrated with OneLake security.

model in Direct Lake is always stored on the cloud, and it does not store anything on the local computer. However, this integration opens up the possibility of using external tools and simplifies the introduction of other features, like the next one.

Composite models with Direct Lake and Import mode

you can mix tables in Direct Lake mode (also coming from different sources) and in Import mode.

does not create “limited” relationships between tables from different data sources

The table in Import mode does not have the current limitations of tables in Direct Lake

ill be possible to materialize a view on Lakehouse using SQL statements

: It will also be possible to create calculated tables and calculated columns based on tables connected through Direct Lake.

The semantic model will introduce the notion of “Calendars

The last announcement is the more important one for the long term. You will be able to write and use functions defined in DAX. These are called User-Defined Functions (UDFs), which you should not confuse with User Data Functions in Azure: the DAX UDFs exist in semantic models, are written, and can be consumed in DAX.