Process for using Workbench to read a Sharepoint Excel File



I'm trying to set up Workbench to read a sharepoint stored excel file.

While in sharepoint I am generating a link to the file (which is a web https:// link) but after putting this into Workbench as a "local file" it fails to reach the file. Guidance on what I'm missing in Workbench or Sharepoint to get this working would be very much appreciated.

BTW - I am working with my IT department to get the Online Rest connector working (it's requesting Admin rights despite being set up in Azure as per the guide) but this is throwing up other issues right now which is why I am looking at Workbench as a short term solution.