Reputation:
Every time I try to add multiple files together they get combined. Imagine having 20 CSV files, it would be so tedious to add the files one-by-one in Power Bi. I was wondering if there was any way to add multiple CSV files together without merging them?
The reason I want them to be separate is so that the data is segregated and I can access them easily.
Upvotes: 0
Views: 1064
Reputation: 124
Try placing all csv files in a single folder and then given location of that folder to powerbi while importing.
For reference: https://exceleratorbi.com.au/combine-csv-files-power-query/
Upvotes: 2