What is the best way to import from a folder containing multiple file types?

[Anonymous]

I want to import .CSV files from a folder and import Excel files from the same folder into the same PBI report and combine into the same table. Is this possible using the Get Data wizard?

If not, is there a way to exclude certain file types from an import before combining the contents into a single table?

[anandav · Accepted solution]

Hi @Anonymous,

You can use the Get Data -> More.. -> Folder to select the folder you want to get teh files from.

When loading click Edit and go to Query Editor. You can filter files by Extension. So for the first query filter Extension by .xls to get Excel files.

Then repeat the process to Get Data from Folder and filter by Extension .csv to get the second query for csv files.

 

Note that your columns need to be same type and count if you want to do this.

I haven't tried but am sure if the Excel and csv files have same number of columns and types you can use Append Query to combine them into a single table.

If this solves your problem please mark as the solution.

[Anonymous]

Thank you, @anandav! That was exactly what I needed.