Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Add more information:
when I do the same operation in Excel, it will automatically create the "Transform File" just like below.
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.