Sharepoint folder is missing in get data excel.

Question

Sharepoint folder is missing in get data excel.

Answer 1

Can you take a screenshot of what you see? Do you have any error message?

Answer 2

After the from folder option i did'nt get sharepoint folder option.

Answer 3

We are unable to get sharepoint folder option .

Answer 4

For a workaround, if you are willing, you may firstly sync files from the SharePoint library where the Excel file is saved. You can click the Sync button from ribbon in the SharePoint library to sync files.

In Excel, go to Data tab>Get Data>From File>From Excel workbook, then navigate to the SharePoint sync folder and choose your Excel file > click Import >choose a sheet and click Load to load data.

Screenshots and article for your reference:

Sync SharePoint and Teams files with your computer (microsoft.com)

Cited from https://answers.microsoft.com/en-us/msoffice/forum/all/import-data-from-sharepoint-file-into-excel/f4e0be84-3591-4d17-873d-799a0fd470e5

Answer 5

Looks like making the trick

The only problem here is that invited users from some tenants might not be able to sync folders. Getting that permission might be an issue.

Something that I do is to create the query in PBI and then copy that in excel, or directly type in an empty query.

Many connectors unreachable from excel menus are included as code. Some don't