topic DirectLake query mode based on lakehouse views in Data Engineering

DirectLake query mode based on lakehouse views

abhiram342 — Tue, 14 May 2024 05:12:28 GMT

Hi All -We aim to develop a semantic model using lakehouse views instead of tables. Are there any potential fallbacks or considerations we should keep in mind? Since we're not incorporating all columns from the lakehouse tables into the semantic model, our approach is to build it based on views.

One option is to reprocess the data, limiting the columns. However, this includes additional processing and setup. Do you have any suggestions or alternatives to streamline this process?

Thanks,

Abhiram

Re: DirectLake query mode based on lakehouse views

tackytechtom — Tue, 14 May 2024 08:14:46 GMT

Hi abhiram342 ,

Direct Lake mode will fallback to Direct Query if you are using views:

https://learn.microsoft.com/en-us/fabric/get-started/direct-lake-overview#known-issues-and-limitations

So, I guess your best shot is indeed to load the data into new tables according to your requirements...

Hope this helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/