refreshing in power query

hi

i have a bunch of workbooks that i would combined and sent it to power pivot, i accomplished it by using the standard power query method (first selecting one workbook as a sample and combining it as seen below in the image

the problem is as you see when i hit the "refresh all" button in excel, i'm getting an error as you can see in the picture

the error reads "The query cannot be loaded to the worksheet because there are no displayable columns in the result" how can i fix that ?

thanks

Capture.JPG