Forum Discussion
Power Query when combining the file it error "We didn't recognize the format of your first file"
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.
2 Replies
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.
Add more information:
when I do the same operation in Excel, it will automatically create the "Transform File" just like below.
