Forum Discussion
Power Query/Sharepoint
You may use From SharePoint Folder connector
using for the connection root site URL and filtering after that on desired folder. But that will be new project, From Folder connector is not mapped on SharePoint folder. At least directly.
Using the regular folder method means the query works regardless of the file name. So as long as the report/columns match, and there's only one file in folder, the report will work as intended. (And if it's wrong, the errors are obvious, and you just put the right report in the folder and refresh.)
This method relies on the file name remaining identical. Not a deal breaker, but mildly annoying.
(Trying to find a solution for a lot of users with different capabilities to follow.)
Perhaps I misunderstood something, but you don't need filenames here as well. After you filter on SharePoint folder you may keep only Content column
After expand it you have same windows for combining files having first file as a sample
- Hi again folks. I think this has been answered before, but want to double check. I have had a spreadsheet working well using "from sharepoint folder" option, but now it's stopped working. I'm having trouble even getting in to see where the error lies in the process, but having just tried to recreate the spreadsheet I'm running into an issue which I think is pretty foundational.
The url I use is at a regional level, as you can't go into further subfolders with the url. But that creates an issue because when I go to Transform the data, the list of items/folders is over 1000, and the data I want is outside of that first 1000. Is there a way around this?If you scroll down preview window shows you rows over 1000, the only that could take time
Profiling you also could change on entire data set and it also could be time consuming
But in general you don't need that for filtering. If you know folder path or its part you may filter column directly from the menu
it doesn't matter records selected by filter in first 1000 rows or not, that's only preview.
- It;s entirely possible I misunderstood something. I'll have a further look and post screen grabs if I can. Thanks again.