Forum Discussion
Sharepoint list data imported into Excel 2016 using Odata:Does not refresh when published to Sharepo
Using Excel 2013 it was possible to import the list(s) data from SharePoint online into excel using OData option. This excel when uploaded to SharePoint document library, It was possible to perform t...
Try this as your source step in Power Query, after replacing the parts in italics with your own info:
OData.Feed("https://yourdomain.sharepoint.com/sites/yoursite/_api/web", null, [Implementation="2.0"])