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

You can attach sample excel file(s) instead of picture

in the meantime try Parsing Binary data using Power Query formulas