If the table is a temp table then it doesn't exist physically in the database. It only exists for the duration of the login session, hence you cannot connect Tableau to such temporary tables. You may need to create a physical table or database view.
Hope this helps.
Thanks for the reply. Just actually managed to connect to be honest. Have used two hashtags (##) at the front to make it Global and the data has appeared in the Tableau Prep.