Get data folder issue

[GilesWalker]

Hi everyone,

I have used the new get data / folder option with .CSV files and it has worked perfectly. However when I tried it with a .XLSX it kept having issues when I clicked the button to perform the function of combining binaries. The error came up that it couldnt recognise the file type. I then saved the reports into .CSV and they worked.

The data is a simple table with 14 columns and each document has roughly 32 rows with cells containing either a date or text.

Has anyone else had this issue or is this function limited to .CSV?

Thanks,

Giles

[MattAllington · Accepted solution]

Take a look at my blog post on this topic. http://exceleratorbi.com.au/combine-excel-workbooks-power-query-method-2/

[joeort]

@MattAllington - you are a PowerBI genius.  Those posts are magical.

[MattAllington]

Thanks all.  Glad it has been helpful 🙂

[Cofinia]

Thanks @MattAllington, your explanations are very helpfull.

[GilesWalker]

Thanks @MattAllington your walk through worked perfectly thanks for the help.

Giles