Hi, I'm trying to use a Sharepoint View as a source.
I do this often with the Sharepoint List connector but there is one list I'm using is very large and complex and it can take a long time just to load the list into the Query Editor and 5-10 Minutes to actually excecute the query. Data I need is only a few hundred rows and there is an existing view that has the data I need.
As a workaround somone suggested I use the "Export to Excel" function of SP to generate an IQY query. For a site I have Admin Rights on it works flawlessly. Unfortunatly the list I want is in another collection and I have permissions issues.
This is what the URL looks like from the IQY file URL
https://.../_vti_bin/owssvr.dll?XMLDATA=1&List={3D259A93-37AE-48BF-986C-53E0C64522DB}&View={29EE8B86-DE90-4285-9159-2A9F1F0ADE2D}&RowLimit=0&RootFolder=%2fsites%2fccg%2fSO%2fLists%2fRecipientLookup
When I try this from PowerQuery I get permissions issues but from Excel it will refresh without issues.
Note - I woudl just use the excel as a source we have onedrive disabled in our environment so its difficult to publish an excel source that will be refershed in the service.
