I am trying to import an Excel Spreadsheet that is stored on sharepoint online. Data - Get Data - From Sharepoint Folder.
It then asks you for Sharepoint Site Url.
The folders are then listed but I cannot find a way to locate a specific workbook within a folder within the site.
This was straightforward when spreadsheet was stored on Onedrive.
Can anyone help?
There is very little on google searches. Mostly talks about importing to Power BI.
Bookmarks