Power Query when combining the file it error "We didn't recognize the format of your first file"

[LoopDong]

Power Query when combining the file it error "We didn't recognize the format of your first file"

Data location: sharepoint folder

Around 6 month ago, it works good, I even built a flow by doing the same way. But now I tried Power Query and Power BI Desktop have the same error.

It's much appricated if someone can help on this.

[LoopDong]

Add more information:

when I do the same operation in Excel, it will automatically create the  "Transform File" just like below.

[ams1]

Hi,

Given a lot of things can change in a non-static folder in 6 months 😁, I'd advise you to visit that sharepoint location outside PowerQuery and see what files are there.