Oct 27 2021 03:15 PM
Hello all,
It appears I'm heading down familiar territory, but my question doesn't seem to have been specifically answered.
I notice this thread, amongst others.
I shall be looking at this thread, with an excellent answer from @Sergei Baklan as well.
So, to my issue. I have been using PQ to source data from a folder on my desktop. There's a report I can run from our client database, I drag and drop it in the folder, it updates the spreadsheet to do all the formatting, cleaning and date checking I need, job done.
Now I want to do the same, but using sharepoint, so that anyone in the particular sharepoint space can drag the same report into a sharepoint folder and then refresh the PQ.
Similar to other threads: I can only get the folder linked using "from folder" and even if you link the sharepoint to your drive so it appears under "from folder" it is then back to only working for me and not others.
Using any of the sharepoint specific options under "Get Data" leads to various errors around url names.
I'll post more details shortly, but any help greatly appreciated.
Oct 28 2021 02:38 PM
SolutionYou 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.
Oct 28 2021 03:09 PM
Oct 29 2021 04:54 AM
Connecting to root one of the columns will be Folder path - filter on on folder you work with.
After filtering, expand content. Rest is similar as with From Folder connector.
Oct 31 2021 05:16 PM
Nov 01 2021 04:58 AM
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
Nov 02 2021 03:00 PM
Dec 20 2021 02:58 PM
@Sergei Baklan Thanks again for this, couldn't seem to use expand option for that column, but removing other columns and just keeping binary and folder path columns did the job.
Jul 18 2022 06:50 PM
Jul 19 2022 02:14 AM
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.
Oct 28 2021 02:38 PM
SolutionYou 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.