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
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise