I'm having the same problems with automatically created excel reports, are the reports you are connecting to also auto created? I have used transformation via helper queries using Excel.Workbook, Folder.Files, Folder.Content. All return just the header row and the first row below the headers.