Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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 | |