Import data from sharepoint to excel not available

Question

Hi,In view of my license (copy in PJ) and according to this page:&nbsp;&nbsp;&nbsp;Power Query data sources in Excel versions - Microsoft Support;&nbsp;I should be able to import data from Sharepoint, but I don't get any suggestions in the "get data" menu in my Excel workbook. (See PJ)I also tested via "From the web" but couldn't load the Sharepoint list. The only table I've managed to get through "From the web" is unusable and doesn't match the location I want to use.According to my technical department, I have administrator rights on 365 and Sharepoint.In the meantime,Kilian&nbsp;

jkpieterse · Answer

Looks like something is missing from your post?

kilianaqui · Answer

JKPieterse&nbsp;&nbsp;Hi, here the screenshots.&nbsp;

jkpieterse · Answer

kilianaqui&nbsp;This page shows the available connectors per subscription and Excel version type:https://support.microsoft.com/en-us/office/power-query-data-sources-in-excel-versions-e9332067-8e49-46fc-97ff-f2e1bfa0cb16&nbsp;

kilianaqui · Answer

Thank you for your answer.This is the link I put on my post, that's why I am confused. We can see that the "Microsoft 365 Apps for Enterprise" version (my actual version) get all connectors but it doesn't appear in my Excel workbook.

kilianaqui · Answer

Hi, did you see my answer? I am still in troubles with that.Thank you in advance,

Forum Discussion

Import data from sharepoint to excel not available

Resources