Forum Discussion
Error combining files in Power query from Azure Datalake despite being excel files
I connected my powerbi to our Azure datalake and was able to load the folders into Power Query Editor and choose the excel files I wanted to combine and upload. However, I get an error when I click on 'Combine'.
Error message:
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.
The error is straightforward however all the files are in xlsx format so the error makes no sense. Could it be because I loaded it through the azure datalake? When I do the same steps but the files live in Sharepoint, I have no problems so I'm assuming it is an issue with Azure files. Here is a snapshot of step before the error:
Then I get the error as stated above.
12 Replies
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
v-juanli-msftCommunity Support
- edhans
Community Champion
Confirmed. I found I can click on the file binary an get to the data tables in the Excel workbooks, but I cannot Combine the binaries as I can from Sharepoint, Onedrive, etc. I am having no issues with CSV files combining from ADL.
I have Azure Data Lake Storage gen 1.
I can replicate the error in both the Nov 2018 Power BI Deskop app and Power Query in Excel from Office 365, Insider Build 1812.
- edhans
Hopefully you can get this confirmed as a bug v-juanli-msft. Note that there are others with this issue. See https://twitter.com/ehansalytics/status/1064965777755791360 for a conversation I had with someone that has written a blog about using Power Query to get files from Azure Data Lake. CSV works fine. Excel files fail. I have more details in this note too.
- v-juanli-msft
