combine files, but not all

[ovonel]

I have a folder with 6 csv.

5 of them should be combined into a single table and the other one should be a separate table.

The final model should have 2 tables.

PowerBI is letting me only combine ALL, how can I combine only 5 of them and not all?

(I want to combine files 2 to 6… and leave the 1st file as its own table…)

[v-yiruan-msft · Accepted solution]

Hi @ovonel ,

You can follow the steps below to get it:

1. Connect to the related folder and filter out/remove the file which you want to keep a single query and combine the left files

2. Connct to the file which you want to keep a single table again separately

Best Regards