Using query string from IQY file from Sharepoint "export to excel" as PowerQuery source in PowerBI

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.