Forum Discussion
Adjust columns in csv before combining?
I have a folder full of csv files which I am currently combining by adding a folder as a data source. The files are exports from an order report (files are by month and year). For 2022, the order rep...
mangaus1111
Solution Sage
Solution SageHi rpmm ,
from this window, instead of choosing the first file as sample, choose one of the files that have the maximum number of columns.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I don't see this window. Is it because my files are being combined as Binary?
menglaro78Microsoft Employee
The photo shown by mangaus1111 you see it only when the first time you select the folder as a data source.
Is it possible share your file ?
Marco
It has some private data. Are you suggesting that maybe I start anew and try re-creating the data source in another PowerBI file? I can try, but there are many transformations I have created which I will need to recreate in the new file 😞