Forum Discussion
Solved
Data connection SharePoint
Hi, I want to use excel sheets in a sub folder within an In site library on SharePoint as my data source. I tried several ways (Sharepoint List, Folder, Online List), but not getting it done. Who...
The following method and walkthrough is a common and easy-to-use pattern provided by Wyn Hopkins that I have used often. It is one thing to connect to the folder, and quite another to combine the files. This works well for a number of file formats including Excel and CSV.
Magically combine Excel files From SharePoint Folder with bonus debugging tip!
Use SharePoint Folder connector from Power BI. Use the root url of your SP. I I tried it.
For example my site has several folders and subfolders and then folder inside the sub folder and files. I can see all those files in the list. Base url looks like:
https://[yourDomainName].sharepoint.com/sites/MySPSite