Power BI Desktop November 2022 Issue - Cannot combine files from SharePoint folder

[shike_marples]

My Power BI Desktop updated to the November 2022 version and I am no longer able to connect to a SharePoint folder and combine Excel (xlsx) files. The error returned is "We didn't recognize the format of your first file". I have unstalled the Nov 2022 version and went back to Oct 2022 version and it is working.

[v-mengzhu-msft]

Hi @shike_marples ,

Can't repro your problem.In my testing, I can connect to a sharepoint folder and combine excel file.

How do you combine ? And what's the format of your first file?

Best regards,

Community Support Team Selina zhu

[mkazy_PGS]

I am also experiencing the same issue that @shike_marples is reporting after the November update. 

SharePoint folder is the target with .xlsx files in the folder (only) and when attempting to Combine, I receive the same error that was outlined above. 

[shike_marples]

Hello @v-mengzhu-msft 

Here is my testing results when using the Oct 2022 version and Nov 2022 version. Same SharePoint site, same file:

Oct 2022

Nov 2022

[zoberender]

I am running into the same issue.  Specifically, I am using SharePoint.Contents to access the SharePoint site.  Using the SharePoint.Contents method, I get the same error as @shike_marples.  

If I use the SharePoint.Files method, I can still connect to the files and combine them.  This method require many steps of filtering to find the "right" files.  It is also a huge drag on processing as there are thousands of files across the entire SharePoint site.  

The files are clearly Excel Files but the Combine function does not work.  If I click on Binary, where it would normally pull in the Excel and sho the different Tables/Sheets, it doesn't.  It shows the below.