Forum Discussion
Sharepoint Folder
Hi admiralman,
Based on my test, we have to list all available folders, then select those we need from the list. As mentioned in above link:
Now that we’re in, we’ll be able to see all of the files from all of the folders that we have access to in that specific site. This might be a pretty long list, so let’s do some filtering on the “Folder Path” column and select the folder where your data is being stored so you only get the files from it.
If we direct to a specific folder in URL (https://microsoft.sharepoint.com/xxxx/xxxx/Shared%20Documents/Power%20BI), it will fail to connect and prompt below error.
Regards,
Yuliana Gu
Hi admiralman
If you open up your SharePoint site in Internet Explorer and then navigate to your Document Libriary and then click on the Ribbon, there will be an option to Open in Windows Explorer.
Once that is done, in the Power BI Query Editor you can then click on Get Data from Excel file and then use the URL and the file name and connect to the file.
Another option is you could possibly do it by clicking on Get Data and then selecting Folder. And then paste in the URL from your Windows Explorer.
Thanks but I am not looking at targeting a specific file but rather the folder. I want to be able to basically say "for every file in this folder bring in the file, perform the necessary transformations, and merge the data into my dataset so I can report on it". There is this option when targeting files on the local hard drive.
Hi admiralman
You could possibly create a function for each file and then loop through each file into one dataset?
- Sure...there are a lot of ways to attack this programmatically. I could schedule a power shell to connect and consolidate all files onto one. Does no one know how the Sharepoint folder is supposed to work?
