Shortcut

If you want to create shortcuts from the Warehouse to the Lakehouse you won't be able to as that's currently not supported.

Is there a reason you're using a Warehouse in the gold layer? You could use a lakehouse in the gold layer and create shortcuts to the silver lakehouse from there if that fits your scenario

Hi Mohammed- ,

You can add a Lakehouse to Warehouse for cross querying. Click on the '+ Warehouse' button and then you can add a SQL Endpoint of Lakehouse to it. 

But you cannot add tables directly from Lakehouse into a Semantic Model of Warehouse. For that, you can create new Views in Warehouse on top of the Lakehouse tables and those views can be added to the Semantic model.

That is interesting.

I guess the view cannot be queried in Direct Lake mode, I guess Power BI queries to a SQL view will fall back to DirectQuery.

Still, it is interesting that you can add the Lakehouse table to the Data Warehouse semantic model in this way.

v-cboorla-msft 

•  Thanks for your replay , To Complete my test  I Create 2 lakehouse as gold layer
• In the end of my testing i will share complete document witn the commity to get your feed back
• special  data coming from enterprise system Oracle Jdedwards EnterpriseOne
• Thanks again