Allow hybrid connection for the same data source

We are trying to define a hybrid table where the recent data is cached in Import Mode and older data is queried on demand in Direct Query. We are trying to leverage Power BI's Composite Model, but this approach doesn't let us define a hybrid for the same table. Additionally, we tried to do it ourselves by merging the data together with Power Query with "Table.Combine({TableDirectQuery, TableImportMode})", but it doesn't seem to be working correctly and it defaults to the mode defined in the source table (i.e., DirectQuery in this case).