Retrieving Data From Multiple Tables of Connected SQL Database Into One Excel Workbook

In "click-button" scenario you can connect to SQL DB via "Get & Transform" to the fact table and dimension table in two separate queries, then in the first query (fact table) apply "Combine queries" (or "Merge queries" - I can't check it right now) button (you can find it in the Main ribbon of the Query Editor windoe) and it will help you to perform left outer join by postage type code column.

Then all you need is to expand the joined table (actually you can select only one column from this table).

If you make this in the very first steps, then it can apply query folding to the source DB, so all join operations will be performed on the DB side and only then combined data will be loaded to Excel.

With the little M-coding you can make this in one query, BTW