Import records from multiple SharePoint excel- [Binary] error

[shBWrk]

Hi,

Im trying to import from multiple sharepoint excel files in to my desktop powerbi. When I run below query, I get the attached screen shot error. = Binary.Combine(#"Filtered Rows"[Content])

The excel files format are general. They include text and email address and some of them includes "" double quotes inside the cells, like--->>> "name". 

I cannot find out what is the issue with the excel files. I reviewed all of them one by one and did not notice any issues with them.

Can anyone please help me find out why I get this error?

Thanks

SBWrk

[shBWrk]

I see many others have similar issue with .xlsx extention but I dont see if any solution has been provided to them in this community.

[shBWrk]

Hi, the files extention is .xlsx

[audreygerred]

Hi! What is the file type extension for your Excel file? If it is .xlsb you will need to convert it to xls or xlsx.