Forum Discussion
Error combining files in Power query from Azure Datalake despite being excel files
New Power BI User here. I'm have the same issue trying to combine .xlsx files from a OneDrive Business Folder. I can navigate to the folder but when I click combine i get
We didn't recognize the format of your first file (). Please filter the list of files so it contains only supported types (Text, CSV, Excel workbooks, etc.) and try again.
I know this is an old post but could anyone point me to a solution or tell me I'm not going mad and there is a bug?
Thanks
This was working. I had some of my reports set up in this method early last year. They are still running fine. Went to set up another report the same way today, and I keep getting the above error too. Haven't found a solution to my issue yet as I am accessing through SharePoint.
Came across this if it helps - https://community.powerbi.com/t5/Community-Blog/Workaround-to-the-problem-in-the-dataflow-We-did-not-recognize/ba-p/1813452