Sharepoint Folder Connection

[Anonymous]

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!

[edhans]

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. 

See this article for details.

[Anonymous]

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!

[edhans]

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?

[Anonymous]

@edhans Sure! What I want is to be able to import all these files in the same folder at the same time in to the PBI instead of  use get data option one by one. Efficiency.

[edhans]

You cannot do that to my knowledge. Flat files are one at a time, or en masse if they are the same and the Combine option works for you. In your case, if they are all separate tables, then you'll need to do them one at a time.

[Greg_Deckler]

Huh, @ImkeF , @edhans ?