The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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
Solved! Go to Solution.
Hi @abhiram342 ,
Direct Lake mode will fallback to Direct Query if you are using views:
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/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! | |
#proudtobeasuperuser | |
Hi @abhiram342 ,
Direct Lake mode will fallback to Direct Query if you are using views:
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/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! | |
#proudtobeasuperuser | |