Forum Discussion
Sharepoint folder data source troubles
van_r so you wish to have your csv files from a sharepoint folder. So there is process to connect to a shrepoint folder and then using filter option you can filter a subfolder basis matching criteria.
1. When your source is a sharepoint folder, you have to initial connect to a root folder and then it will show the list of all files.
2. Using filter option, you can filter only matching files matching your subfolder name.
3. Then you will list of files based on the matching criteria
4. then you can combined these files
pl. go through the below link for further help
Power Query SharePoint folder connector - Power Query | Microsoft Docs
Loading Excel Files from Sharepoint - (powerbi.tips)
thank you--possible to have this as a parameters so i dont have to do this for each CSV I want to load? (currently all CSVs are in 1 folder on local drive and the query looks for a parameters to know where to look--the parameter = folder path)
