Appending specific rows from one table to another using DQ

Hi there,

I've run into a bit of an issue. I have two tables, one which lists all physical products in local currency and another which lists all transactions in the transaction currency. What I want is to append the rows containing service products (in bold) which are sold in local currency to the list of all the physical products. Also, I'm working with DirectQuery. (If not possible to do generally, there are only a dozen relevant products so doing it one-by-one by ie ProdID is feasible.) 

The relevant part of the tables look something like those under, though there are a number of unique columns to each:

PhysicalProducts

AllTransactions

The outcome I'm after:

PhysicalProducts