Forum Discussion
Sharepoint Folder Connection
Hi, I've connected my powerbi to a sharepoint folder where I have n csv files. I want to create a table for each csv file.
Is there any way to get this and not extract and load each file one by one?
Thank you!
6 Replies
Yes. Filter your view of the files in SharePoint by CSV file, then click the Combine button in the upper right of the file name column. It will do all of them at once. The CSV files must be in the same format/structure for this to work properly.
Hi edhans , I don't want to combine these .csv files. I want to create a table for each .csv because for me each .csv represents one table in my model but I'm looking for a way to load into PBI all these files at the same time (not one by one)
Thank you!
No. Every table from a flat file is a separate connection, each with its own columns, formats, transformations, etc.
Is each CSV file really a different set of data?
