Forum Discussion

shBWrk's avatar
shBWrk
New Member
1 year ago

Import records from multiple SharePoint excel- [Binary] error

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

 

 

 

Need Help
Tips and Tricks

3 Replies

  • audreygerred's avatar
    audreygerred
    Super User
    1 year ago

    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. 

  • shBWrk's avatar
    shBWrk
    New Member
    1 year ago

    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.