SQL Query loading in MS Query but not importing data to excel

Hi All,

I've written a query up in SQL, which runs perfectly fine in SQL Studio Manager & am trying to embed into excel using Microsoft query as I've done loads of times before.

The query returns data within the MS Query preview window & when trying to import this data into a table in excel, it seems to be running for a few seconds & says "Getting data", but then no data appears & I just get static text saying "Query from [connection]" but no data.

I assume this must be because excel doesn't appreciate some of the syntax of my query, but I can't seem to work out which bit.

It uses temporary tables, joins & ISNULL but I'm sure I've used these before without error.

See attached screenshots & the query itself.

Any ideas?! Any insight would be very much appreciated.