Import data from sharepoint to excel not available

Copper Contributor


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,


6 Replies
Looks like something is missing from your post?

@Jan Karel Pieterse 


Hi, here the screenshots.


Capture d'écran 2023-10-25 155236.pngCapture d'écran 2023-10-26 152717.pngCapture d'écran 2023-10-26 152805.png

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.
Hi, did you see my answer? I am still in troubles with that.
Thank you in advance,
Perhaps better if you ask your IT dept