Apologies if this should be in PowerBI.
This feels like a real dumb question, I know you can import multiple csv files from the same folder and merge them into one query. I'm struggling to find a way to import multiple csv files from the same folder but not combine them. i.e. I want each csv in its own separate query or table, as the formatting for each csv is different.
Do you have to important each file one by one to create different queries?
This feels like a real dumb question, I know you can import multiple csv files from the same folder and merge them into one query. I'm struggling to find a way to import multiple csv files from the same folder but not combine them. i.e. I want each csv in its own separate query or table, as the formatting for each csv is different.
Do you have to important each file one by one to create different queries?