Appending different tables/sources

Hi all,

I am currently encountering an issue when attempting to merge two tables. One table is the Fact table, and it operates in DirectQuery mode due to its substantial data volume. Additionally, I retrieve a second table from our data warehouse, which contains the same columns. However, when I try to append them, I receive an error stating that it is not possible and can only be done when both tables are imported.

Is there a workaround to enable this with a DirectQuery table, or what possible solutions are available for this situation? I couldn't find any solutions thus far.

Thanks in advance