Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

0

Issue with Sharepoint.Contents and Power Query

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,

 

 

Status: Delivered

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

Comments
v-xiaoyan-msft
Community Support
Status changed to: Delivered

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
Regular Visitor

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
Community Support

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