Import data from sharepoint to excel not available

[kilianaqui]

Hi,

In view of my license (copy in PJ) and according to this page:   

Power Query data sources in Excel versions - Microsoft Support; 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 

[#2]

Looks like something is missing from your post?

[#3]

@Jan Karel Pieterse 

Hi, here the screenshots.

[#4]

@kilianaqui 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-...

[#5]

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.

[#6]

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

[#7]

Perhaps better if you ask your IT dept