Get startedGet started for free

Choosing a Direct Lake route

Regional managers want a new Direct Lake model that compares Sales with planned Targets. As the image shows, Sales is in the warehouse WH_RetailSales and Targets is in the lakehouse LH_RetailPlanning. Which Direct Lake route lets one model use both tables, and why?

This exercise is part of the course

Data Ingestion and Semantic Models with Microsoft Fabric

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise