Forum Discussion

Anonymous

Not applicable

8 years ago

Solved

Combine files with structure change

Hi all, In PowerBI I have setup a query to retrieve several CSV files from a datasource. The query also combines these files into a single table using the 'combine files' function. When new fil...

Greg_Deckler
8 years ago
So, you can change which file is used as your sample file. There is an spot in the Folder query structure that allows you to change this. Also, since it is CSV, this defaults to specifying the number of fields in the Source line. You could edit this and remove that specification, that is the usual fix then you get a CSV file that changes the number of columns after you initially create the query.

Greg_Deckler

Community Champion

8 years ago

So, you can change which file is used as your sample file. There is an spot in the Folder query structure that allows you to change this. Also, since it is CSV, this defaults to specifying the number of fields in the Source line. You could edit this and remove that specification, that is the usual fix then you get a CSV file that changes the number of columns after you initially create the query.

Anonymous

Not applicable

8 years ago

Thanks, that worked for me. This is what I changed: