Issue with Sharepoint.Contents and Power Query

[nwoo20]

Hello,

I am having issues combining binaries from a Sharepoint folder using Sharepoint.Contents. The issue came up a few weeks ago.

Details of the bug:

I found that using = Sharepoint.Contents fails in this way with ApiVersion = 15 but works OK with version 14.

When trying to combine the binaries an error message appears despite the binaries being the supported types (excel workbooks in this case)

"Combine Files

We didn't recognize the format of your first file (companyname.sharepoint.com). Please filter the list of files so it contains only supported types (Text, CSV, Excel Workbooks, etc.) and try again."

..

Version 15 for some reason best know to the people who changed it and broke the function is that the Documents Folder name now shows in The Content table as Shard Documents rather than Documents which is the correct folder name for me on a brand new site

More details from others have the same issue can be found here:

Using PowerQuery to import files from a SharePoint folder- file format - Microsoft Community

Thanks,

[v-xiaoyan-msft]

Hi @nwoo20 ,

Based on my research this does not appear to be a Power BI issue. Please contact the SharePoint team's support for professional help.

Best regards.
Community Support Team_ Caitlyn

[nwoo20]

Thanks Caitlyn - can you provide resources on your research? I have reached out to our IT team in the past and they mentioned it's likely a PowerBI issue.

[v-xiaoyan-msft]

Hi @nwoo20 ,

I searched the internal error reporting platform for this issue and Power BI has not had this error message recently.

Kindly see if this thread helps.

Solved: Combining Files Error in Power Query - Microsoft Power BI Community

Best regards.
Community Support Team_ Caitlyn