QuestionQ102

VerifiedImplement and manage semantic models

You have a custom Direct Lake semantic model named Model1 that has one billion rows of data.

You use Tabular Editor to connect to Model1 by using the XMLA endpoint.

You need to ensure that when users interact with reports based on Model1, their queries always use Direct Lake mode.

What should you do?

Explanation

The DirectLakeBehavior property (configured to 'DirectLakeOnly') ensures all queries use Direct Lake mode without fallback to DirectQuery. This is critical for a one-billion-row semantic model to maintain optimal performance. The property is configured via Tabular Editor using TOM or TMSL, not through Default Mode, Partitions Mode, or Storage Location settings.

Community Discussion

No comments yet. Be the first to start the discussion!