Nested join / join multiple tables in Power Query

Hello,

I have the following situation in Power Query.

A fact table that has foreign keys to multiple dimensions.

eg.

ID_Fact ID_FK1 ID_FK2 value

I want to merge the fact table with the dimension tables based on the ID's.

The caveat however is I want to do this dynamically.

So if in the fact table a new foreign key is added, it should join that new table as well, without having to change the query.

How do I know which column is a foreign key? Because this is data entered in a different table:

FK Columns

So what I want to do, is to join the fact table with every table present in the foreign key list-table.

For simplicity, you can assume that all tables and columns have the same naming convention and that all columns required are present.

So if in the above table the value 'FK3_ID' is added, it should join the fact with the new table 'FK3' on the 'FK3_ID' column. 

I'm confident the key lies in using a recursive query, but I'm unsuccessful.

Thank you.