You could have PowerQuery load a table in excel, create macro to refresh upon open, use windows events to schedule the book to open and refresh, have SSIS read from...

So I'm linked, I have the catalogue, but it shows up as default schema and I cannot query it using a 4 part identifier, only openquery. Have you found a...