I used OneLake shortcut transformation in Microsoft Fabric to convert Excel files into Delta tables in a Lakehouse. I confirmed that DESCRIBE DETAIL for the target tables shows format = delta, and that physical Parquet files also exist. After that, I referenced these tables again from another Lakehouse using OneLake shortcuts, and then tried to create a Direct Lake semantic model from the downstream Lakehouse. However, when creating the Direct Lake semantic model, the following error occurred: We cannot refresh this semantic model because one or multiple source tables either do not exist or access was denied. The target tables are displayed correctly in Lakehouse Explorer and are recognized as Delta tables. Also, in my previous experience, Direct Lake can be used with similar multi-hop shortcut architectures when the shortcut-transformed tables originate from CSV or JSON files. Therefore, this behavior does not appear to be a general limitation of multi-hop shortcuts. Instead, it seems to be a product limitation or feature gap related to the following combination: ・Excel-originated shortcut-transformed tables ・Multi-hop shortcut lineage ・Direct Lake semantic model validation behavior Excel files are widely used by business users. Therefore, it is very important to be able to easily convert Excel data into Delta tables in Fabric, reuse them across multiple Lakehouses, and analyze them efficiently with Direct Lake. Currently, I am using a DirectQuery semantic model as a workaround. However, if a table is recognized as a Delta table, I believe it should be possible to create a Direct Lake semantic model from a downstream Lakehouse as well. Request: Please support Direct Lake semantic model creation for Delta tables created by Excel shortcut transformation, even when they are referenced through multi-hop OneLake shortcuts. This improvement would make it easier to naturally combine business data usage starting from Excel, reuse across Lakehouses, and high-performance analytics with Direct Lake.
... View more